salary.sql

此系统是我做课程设计所写

/*4.3.1 创建员工津贴表jt*/
CREATE TABLE jt 
(
emp_no VARCHAR(6) Not NULL, 
jb_date DATETIME Not NULL, 
jb_daynumber DECIMAL(2) NULL, 
jblb VARCHAR(3) NULL,  
CONSTRAINT  jt_emp_date_pk  PRIMARY KEY (emp_no, jb_date)
)

/*4.3.2 创建考勤管理表格kq*/
CREATE TABLE kq 
(
emp_no VARCHAR(6) Not NULL, 
qq_date DATETIME Not NULL, 
qq_daynumber DECIMAL(2) NULL, 
qq_lb VARCHAR(3) NULL, 
qq_reason VARCHAR(200) NULL, 
CONSTRAINT  kq_emp_date_pk  PRIMARY KEY (emp_no, qq_date)
)

/*4.3.3 创建工资标准表格gzbz*/
CREATE TABLE gzbz 
(
gz DECIMAL(3) NOT NULL, 
gz_name VARCHAR(10) NULL,
gzjbgz DECIMAL(6) NULL,  
CONSTRAINT  gzbz_gz_pk  PRIMARY KEY (gz)
)

/*4.3.4 创建医疗保险表ylbx*/
CREATE TABLE ylbx 
(
emp_no VARCHAR(6) NOT NULL, 
ylbxfy DECIMAL(6) NULL, 
bxf DECIMAL(6) NULL,  
ylbx_date VARCHAR(6) Not NULL
CONSTRAINT ylbx_emp_date_pk PRIMARY KEY (emp_no,ylbx_date)
) 

/*4.3.5 创建员工基本情况表yg*/
CREATE TABLE yg 
(
emp_no VARCHAR(6) NOT NULL, 
emp_name VARCHAR(10) NULL, 
emp_gz VARCHAR(3) NULL, 
emp_department VARCHAR(10) NULL,  
emp_time VARCHAR(6) NULL, 
CONSTRAINT yg_emp_no_pk PRIMARY KEY (emp_no)
) 

/*4.3.6创建员工月工资表ygz*/
CREATE TABLE ygz
(
emp_no VARCHAR(6) NOT NULL, 
jbgz DECIMAL(6) NULL, 
jt DECIMAL(6) NULL, 
kq DECIMAL(6) NULL, 
ylbx DECIMAL(6) NULL, 
bx DECIMAL(6) NULL, 
ygz_total DECIMAL(6) NULL,
ygz_date DATETIME Not NULL,  
CONSTRAINT ygz_emp_date_pk PRIMARY KEY (emp_no, ygz_date)
)  

/*4.3.7创建员工年终奖金表nzjj*/
CREATE TABLE nzjj 
(
emp_no VARCHAR(6) NOT NULL, 
nzjj_date VARCHAR (4) Not NULL, 
nzjj DECIMAL(6) NULL,  
CONSTRAINT nzjj_emp_date PRIMARY KEY (emp_no, nzjj_date)
)  

go