/*Ա51asϢpx*/
CREATE TABLE [dbo].[admin] (
	[adminUserName] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,	/*Աʺ*/
	[adminPassword] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL 	/*Ա*/
) ON [PRIMARY]
/*ԱϢ*/
CREATE TABLE [dbo].[employee] (
	[employeeId] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,    /*Ա*/
	[name] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,             /*Ա*/
	[cardNumber] [nchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,           /*Ա֤*/
	[nation] [datetime] NULL ,                                          /**/
	[sex] [nvarchar] (2) COLLATE Chinese_PRC_CI_AS NULL ,               /*Ա*/
	[birthday] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,                                        /**/
	[graduateSchool] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,   /*ҵѧУ*/
	[schoolRecord] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,      /*ѧ*/
	[departmentId] [int] NULL ,                                         /*ڲű*/
	[positionId] [int] NULL ,                                           /*ְλ*/
	[telephone] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,         /*绰*/
	[email] [nvarchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,            /*email*/
	[editTime] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,                                        /*༭ʱ*/
	[memo] [ntext] COLLATE Chinese_PRC_CI_AS NULL                       /*Ϣ*/
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
/*Ϣ*/
CREATE TABLE [dbo].[department] (
	[departmentId] [int] IDENTITY (1, 1) NOT NULL ,
	[departmentName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]