工资管理系统 课程项目 use message; CREATE TABLE Users ( UserID bigint(20) NOT NULL , UserName varchar(20) default NULL, UserPassword varchar(20) default NULL, DepartmentID bigint(20), Duty varchar(32), Identity varchar(18), BankID varchar(20), PRIMARY KEY (UserID) ) ; CREATE TABLE Department ( DepartmentID bigint(20) NOT N ULL , DepartmentName varchar(30) default NULL, PRIMARY KEY (DepartmentID) ) ; CREATE TABLE Attendance ( UserID bigint(20) NOT NULL , Schuqin bigint(10), RequireTime bigint(10), PRIMARY KEY (UserID) ) ; ULL , DepartmentName varchar(30) default NULL, PRIMARY KEY (DepartmentID) ) ; CREATE TABLE Attendance ( UserID bigint(20) NOT NULL , Schuqin bigint(10), RequireTime bigint(10), PRIMARY KEY (UserID) ) ;