SQL+c#4.1数据库建表
4.1.1员工表创建
create table staff(sid int NOT NULL IDENTITY(1,1), name nchar(20) NOT NULL, sex nchar(2) NOT NULL, did int, level nchar(20), jointime date NOT NULL, PRIMARY KEY(sid));
4.1.2部门表创建
create table department(did int NOT NULL IDENTITY(1,1), name nchar(10) NOT NULL, number int NOT NULL, PRIMARY KEY(did));
4.1.3工资表创建
create table salary(id int NOT NULL IDENTITY, sid int NOT NULL, shouldsalary money NOT NULL, realsalary money NOT NULL, time date NOT NULL, PRIMARY KEY(id));
4.1.4出勤表创建
create table attendance(id int NOT NULL IDENTITY, sid int NOT NULL, oday int NOT NULL, aday int NOT NULL, time date NOT NULL, PRIMARY KEY(id));
4.1.5工资代扣表创建
create table withhold(id int NOT NULL IDENTITY, sid int NOT NULL, rid int NOT NULL, time date NOT NULL, PRIMARY KEY(id));
4.1.6保险税收表创建
create table rate(id int NOT NULL IDENTITY, gold money NOT NULL, tax float NOT NULL, min money NOT NULL,PRIMARY KEY(id));
类似这种
只是创建表结构?