数据库名USER_DATA
员工基本状况表PERSONNAL
CREATE TABLE "HAOHAO".PERSONNAL
(
EMP_NO VARCHAR(10) NOT NULL,
EMP_NAME VARCHAR(20) NULL,
DEPT_ID VARCHAR(10) NULL,
EMP_GENDER VARCHAR(2) NULL,
EMP_TELENO INT NULL,
EMP_MAIL VARCHAR(20) NULL,
PRIMARY KEY(EMP_NO),
--FOREIGN KEY(DEPT_ID) REFERENCES "HAOHAO"."DEPT"(DEPT_ID)
)
ALTER TABLE "HAOHAO".PERSONNAL ADD FOREIGN KEY(DEPT_ID) REFERENCES "HAOHAO"."DEPT"(DEPT_ID)
用户口令表USER_PSWD
CREATE TABLE "HAOHAO".USER_PSWD
(
HAOHAO_USER VARCHAR(20) NOT NULL,
HAOHAO_PSWD VARCHAR(10) NULL,
PRIMARY KEY(HAOHAO_USER)
)
部门信息表DEPT
CREATE TABLE "HAOHAO".DEPT
(
DEPT_ID VARCHAR(10) NOT NULL,
DEPT_NAME VARCHAR(20) NOT NULL,
DEPT_MANAGER VARCHAR(10) NULL,
DEPT_VICEMANAGER VARCHAR(10) NULL,
PRIMARY KEY(DEPT_ID),
FOREIGN KEY(DEPT_MANAGER) REFERENCES "HAOHAO"."PERSONNAL"(EMP_NO),
FOREIGN KEY(DEPT_VICEMANAGER) REFERENCES "HAOHAO"."PERSONNAL"(EMP_NO)
)
内部行文信息表XW
CREATE TABLE "HAOHAO".XW
(
XW_ID VARCHAR(20)NOT NULL,
XW_NAME VARCHAR(20) NULL,
XW_AUTHER VARCHAR(10) NULL,
XW_CONTEXT VARCHAR(50) NULL,
XW_FLAG INT NULL,
XW_DATETIME DATETIME NULL,
PRIMARY KEY(XW_ID)
)
内部行文处理信息表XWCL
CREATE TABLE "HAOHAO".XWCL
(
XWCL_ID VARCHAR(20)NOT NULL,
XWCL_NAME VARCHAR(20) NULL,
XWCL_AUTHER VARCHAR(10) NULL,
XWCL_RECEIVER VARCHAR(10),
XWCL_CONTEXT VARCHAR(50) NULL,
XWCL_REMARK VARCHAR(50) NULL,
XWCL_DATETIME DATETIME NULL,
PRIMARY KEY(XWCL_ID,XWCL_RECEIVER)
)
评论0
最新资源