/*创建管理用户表*/
CREATE TEBLE User(USER_ID CHAR(6) NOT NULL,
PASSWD CHAR(16) NOT NULL,
CONSTRAINT UserID PRIMARY KEY(USER_ID));
/*创建员工信息表*/
CREATE TABLE EmpInfo(ID CHAR(6) NOT NULL,
NAME CHAR(8) NOT NULL,
SEX CHAR(1),
BIRTHDAY DATE,
DEPA_ID CHAR(6) NOT NULL,
JOB CHAR(8),
NATION CHAR(4),
ZZMM CHAR(8),
B_SALARY FLOAT NOT NULL,
WORK_TIME FLOAT,
MEMO VARCHAR(200),
CONSTRAINT EmpInfo_ID PRIMARY KEY(ID));
/* 创建员工工资表*/
CREATE TABLE EmpSalary(ID CHAR(6) NOT NULL,
NAME CHAR(8) NOT NULL,
SEX CHAR(1),
DEPA_ID CHAR(6) NOT NULL,
B_SALARY FLOAT NOT NULL,
WORKDAY INTEGER,
ADD INTEGER,
BUTIE FLOAT,
FULI FLOAT,
TEX FLOAT,
KOUCHU FLOAT,
JJ FLOAT,
SJ INTEGER,
BJ INTEGER,
R_SALARY FLOAT,
CONSTRAINT EmpSalary_ID PRIMARY KEY(ID));
/*创建部门表*/
CREATE TABLE DepaInfo(DEPA_ID CHAR(6) NOT NULL,
DEPA_NAME CHAR(12) NOT NULL,
CONSTRAINT DepInfo_ID PRIMARY KEY(Dep_ID));
/*创建招聘计划表*/
CREATE TABLE ZPInfo(ZP_ID CHAR(6) NOT NULL,
TIME DATE,
DEPA_NAME CHAR(12),
MAN INTEGER,
REQUIRE VARCHAR(200),
CONSTRAINT ZPInfo_ID PRIMARY KEY(ZP_ID));
/*创建培训计划表*/
CREATE TABLE PXInfo(PX_ID CHAR(6) NOT NULL,
TIME DATE,
WHERE CHAR(20),
OBJECT CHER(16),
DEPA_NAME CHAR(12),
MAN INTEGER,
CONSTRAINT PXInfo_ID PRIMARY KEY(PX_ID));
CREATE TEBLE User(USER_ID CHAR(6) NOT NULL,
PASSWD CHAR(16) NOT NULL,
CONSTRAINT UserID PRIMARY KEY(USER_ID));
/*创建员工信息表*/
CREATE TABLE EmpInfo(ID CHAR(6) NOT NULL,
NAME CHAR(8) NOT NULL,
SEX CHAR(1),
BIRTHDAY DATE,
DEPA_ID CHAR(6) NOT NULL,
JOB CHAR(8),
NATION CHAR(4),
ZZMM CHAR(8),
B_SALARY FLOAT NOT NULL,
WORK_TIME FLOAT,
MEMO VARCHAR(200),
CONSTRAINT EmpInfo_ID PRIMARY KEY(ID));
/* 创建员工工资表*/
CREATE TABLE EmpSalary(ID CHAR(6) NOT NULL,
NAME CHAR(8) NOT NULL,
SEX CHAR(1),
DEPA_ID CHAR(6) NOT NULL,
B_SALARY FLOAT NOT NULL,
WORKDAY INTEGER,
ADD INTEGER,
BUTIE FLOAT,
FULI FLOAT,
TEX FLOAT,
KOUCHU FLOAT,
JJ FLOAT,
SJ INTEGER,
BJ INTEGER,
R_SALARY FLOAT,
CONSTRAINT EmpSalary_ID PRIMARY KEY(ID));
/*创建部门表*/
CREATE TABLE DepaInfo(DEPA_ID CHAR(6) NOT NULL,
DEPA_NAME CHAR(12) NOT NULL,
CONSTRAINT DepInfo_ID PRIMARY KEY(Dep_ID));
/*创建招聘计划表*/
CREATE TABLE ZPInfo(ZP_ID CHAR(6) NOT NULL,
TIME DATE,
DEPA_NAME CHAR(12),
MAN INTEGER,
REQUIRE VARCHAR(200),
CONSTRAINT ZPInfo_ID PRIMARY KEY(ZP_ID));
/*创建培训计划表*/
CREATE TABLE PXInfo(PX_ID CHAR(6) NOT NULL,
TIME DATE,
WHERE CHAR(20),
OBJECT CHER(16),
DEPA_NAME CHAR(12),
MAN INTEGER,
CONSTRAINT PXInfo_ID PRIMARY KEY(PX_ID));