/*ԱϢ*/
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]) 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 ,					//ű
	[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].[chargeManInfo] (
	[chargeUsername] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,	//˵½ʺ
	[chargeName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,		//
	[chargePassword] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,	//˵½
	[departmentId] [int] 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].[dayTaskInfo] (
	[dayTaskId] [int] IDENTITY (1, 1) NOT NULL ,				/*ϵͳ¼*/
	[employeeNo] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,		/*Ա*/
	[dayTaskTitle] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,		/**/
	[dayTaskContent] [text] COLLATE Chinese_PRC_CI_AS NULL ,		/**/
	[dayTaskDate] [datetime] NULL ,						/**/
	[dayTaskIsFinished] [nchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,	/*ǷѾ*/
	[dayTaskAddTime] [datetime] NULL ,					/*´ʱ*/
	[dayTaskUpdateTime] [datetime] NULL 					/*ʱ*/
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
/*Ա־Ϣ*/
CREATE TABLE [dbo].[journalInfo] (
	[journalId] [int] IDENTITY (1, 1) NOT NULL ,				/*־¼*/
	[employeeNo] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,		/*Ա*/
	[journalTitle] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,		/*־*/
	[journalContent] [text] COLLATE Chinese_PRC_CI_AS NULL ,		/*־*/
	[journalEvaluate] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,	/*Ÿ˶Ա־*/
	[journalDate] [datetime] NULL ,						/*־*/
	[journalAddTime] [datetime] NULL ,					/*־ʱ*/
	[journalUpdateTime] [datetime] NULL 					/*־ʱ*/
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
/*¶Ϣ*/
CREATE TABLE [dbo].[monthTaskInfo] (
	[monthTaskId] [int] IDENTITY (1, 1) NOT NULL ,				/*ϵͳ¼*/
	[departmentId] [int] NULL ,						/*ű*/
	[monthTaskTitle] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,	/**/
	[monthTaskContent] [text] COLLATE Chinese_PRC_CI_AS NULL ,		/**/
	[monthTaskYear] [int] NULL ,						/**/
	[monthTaskMonth] [int] NULL ,						/*·*/
	[monthTaskIsFinished] [nchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,	/*ǷѾ*/
	[monthTaskAddTime] [datetime] NULL ,					/*´ʱ*/
	[monthTaskUpdateTime] [datetime] NULL 					/*ʱ*/
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
/* żϢ*/
CREATE TABLE [dbo].[quarterTaskInfo] (
	[quarterTaskId] [int] IDENTITY (1, 1) NOT NULL ,			/*ϵͳ¼*/
	[departmentId] [int] NULL ,						/*ű*/
	[quarterTaskTitle] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,	/**/
	[quarterTaskContent] [text] COLLATE Chinese_PRC_CI_AS NULL ,		/**/
	[quarterTaskYear] [int] NULL ,						/**/
	[quarterNumber] [int] NULL ,						/*ڼ*/
	[quarterTaskIsFinished] [nchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,	/*ǷѾ*/
	[quarterTaskAddTime] [datetime] NULL ,					/*´ʱ*/
	[quarterTaskUpdateTime] [datetime] NULL 				/*ʱ*/
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
/*ϴļϢ*/
CREATE TABLE [dbo].[upfileInfo] (
	[upfileId] [int] IDENTITY (1, 1) NOT NULL ,				/*ϵͳ¼*/
	[employeeNo] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,		/*Ա*/
	[upfileTitle] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,		/*ļϢ*/
	[upfilePath] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,		/*ϴļ·*/
	[upfileSize] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,		/*ϴļС*/					/*ļС*/
	[uploadTime] [datetime] NULL ,						/*ϴʱ*/
) ON [PRIMARY]
/*Ϣ*/
CREATE TABLE [dbo].[newsInfo] (
	[newId] [int] IDENTITY (1, 1) NOT NULL ,				//ϵͳ¼
	[newTitle] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,		//ű
	[newContent] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,			//
	[newFrom] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,		//Դ
	[newWriter] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,		//ŷ
	[newAddTime] [datetime] NULL ,						//żʱ
	[newUpdateTime] [datetime] NULL 					//Ÿʱ
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]


