Salary数据库信息.docVIP

表： 1、员工信息表： create table Employee( Employee_ID varchar (5) primary key, EmployeeName varchar(20) NOT NULL , Department varchar (20) NOT NULL , Category varchar (5) NOT NULL , EmployeeTitle varchar(15) NOT NULL, Date_time_in datetime NOT NULL, Base_salary int NOT NULL, Tra_allowance int NOT NULL, Phone nvarchar (30) NOT NULL, Age smallint NOT NULL, ) 2、考勤表： CREATE TABLE [dbo].[Attendance] ( [Date1] [datetime] NOT NULL , [EmployeeID] [varchar] (5) COLLATE Chinese_PRC_CI_AS NOT NULL , [EmployeeName] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT