员工信息表
CREATE TABLE IF NOT EXISTS EMP_INFO (
EMP_ID INT(10) PRIMARY KEY,
EMP_NAME VARCHAR(16),
DEP_ID VARCHAR(10),
POSITION_ID INT(5),
PRI_TYPE INT(10),
ENTRY_DATE DATE,
QUIT_DATE DATE,
CONSTRAINT FK_DEP FOREIGN KEY(DEP_ID) REFERENCES DEPS (DEP_ID),
CONSTRAINT FK_POS FOREIGN KEY(POSITION_ID) REFERENCES POSITION (POSITION_ID),
CONSTRAINT FK_TYPE FOREIGN KEY(PRI_TYPE) REFERENCES PRIV_TYPE (TYPE_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--职位信息表
CREATE TABLE IF NOT EXISTS POSITION (
POSITION_ID INT(5) PRIMARY KEY,
POSITION_NAME VARCHAR(50)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--部门信息表
CREATE TABLE IF NOT EXISTS DEPS (
DEP_ID VARCHAR(10) PRIMARY KEY,
DEP_NAME VARCHAR(30),
SOB_ID CHAR(4)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--权限表
CREATE TABLE IF NOT EXISTS PRIV_TYPE(
TYPE_ID INT(10) PRIMARY KEY,
本内容试读结束,登录后可阅读更多
下载后可阅读完整内容,剩余1页未读,立即下载