/*ԱϢ*/
CREATE TABLE [dbo].[admin] (
	[adminUsername] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,	/*Աʺ*/
	[adminPassword] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 		/*Ա*/
) ON [PRIMARY]
/*ԱϢ*/
CREATE TABLE [dbo].[employeeInfo] (						
	[employeeNo] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,	//Ա
	[employeeName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,		//Ա
	[employeePassword] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,	//Ա½
	[employeeSex] [nchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,		//ԱԱ
	[employeeBirthday] [datetime] NULL ,					//Ա
	[employeeDepartmentId] [int] NULL ,					//ű
	[employeeWorkTypeId] [int] NULL ,					//ְλ
	[employeeEducationId] [int] NULL ,					//α
	[employeeHomeTel] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,	//ͥ绰
	[employeeMobile] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,	//ƶ绰
	[employeeCard] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,		//֤
	[employeeEmail] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,		//ʼַ
	[employeeAddress] [nvarchar] (80) COLLATE Chinese_PRC_CI_AS NULL 	//סַ
) ON [PRIMARY]
/*Ϣ*/
CREATE TABLE [dbo].[departmentInfo] (
	[departmentId] [int] IDENTITY (1, 1) NOT NULL ,				//ű
	[departmentName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL		// 
) ON [PRIMARY]
/*Ϣ*/
CREATE TABLE [dbo].[educationInfo] (
	[educationId] [int] IDENTITY (1, 1) NOT NULL ,				//α
	[educationName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL		//
) ON [PRIMARY]
/*ְλͱ*/
CREATE TABLE [dbo].[workTypeInfo] (
	[workTypeId] [int] IDENTITY (1, 1) NOT NULL ,				//ְλ
	[workTypeName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,		//ְλ
	[workStartHour] [int] NULL ,						//ϰ࿪ʼʱСʱ
	[workStartMinute] [int] NULL ,						//ϰ࿪ʼʱ
	[workEndHour] [int] NULL ,						//°ʱСʱ
	[workEndMinute] [int] NULL 						//°ʱ
) ON [PRIMARY]
/*Ϣ*/
CREATE TABLE [dbo].[attendanceInfo] (
	[attendanceId] [int] IDENTITY (1, 1) NOT NULL ,				/*Ϣ*/
	[attendanceEmployeeNo] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,	/*Ա*/
	[attendanceYear] [int] NULL ,						/**/
	[attendanceMonth] [int] NULL ,						/*·*/
	[attendanceDay] [int] NULL ,						/**/
	[attendanceStartTime] [datetime] NULL ,					/*ϰǩʱ*/
	[attendanceEndTime] [datetime] NULL ,					/*°ǩʱ*/
	[attendanceStartFlag] [smallint] NULL ,					/*ǷѾϰǩ*/
	[attendanceEndFlag] [smallint] NULL 					/*ǷѾ°ǩ*/
) ON [PRIMARY]




