433 lines
33 KiB
Plaintext
433 lines
33 KiB
Plaintext
-- ----------------------------- 2022-08-30 add by lijiaxing@sunwayworld.com--------------begin
|
|
|
|
-- 建表语句
|
|
CREATE TABLE T_LIMS_STAFF(
|
|
ID NUMBER NOT NULL,
|
|
CREATEDBYID VARCHAR2(36) NULL,
|
|
CREATEDBYNAME VARCHAR2(60) NULL,
|
|
CREATEDTIME DATE NULL,
|
|
CREATEDBYORGID VARCHAR2(36) NULL,
|
|
CREATEDBYORGNAME VARCHAR2(270) NULL,
|
|
USERID VARCHAR2(36) NULL,
|
|
USERNAME VARCHAR2(36) NULL,
|
|
USERNO VARCHAR2(36) NULL,
|
|
SEX VARCHAR2(12) NULL,
|
|
BRITHDAY DATE NULL,
|
|
IDNO VARCHAR2(18) NULL,
|
|
NATIVEPLACE VARCHAR2(120) NULL,
|
|
ADDRESS VARCHAR2(120) NULL,
|
|
ENTRYDATE DATE NULL,
|
|
POST VARCHAR2(36) NULL,
|
|
PROFESSIONALTITLE VARCHAR2(36) NULL,
|
|
GRADUATION DATE NULL,
|
|
MAJOR VARCHAR2(36) NULL,
|
|
EDUDEGREE VARCHAR2(36) NULL,
|
|
REMARKS VARCHAR2(360) NULL
|
|
);
|
|
COMMENT ON TABLE T_LIMS_STAFF IS '人员档案表';
|
|
COMMENT ON COLUMN T_LIMS_STAFF.ID IS '主键';
|
|
COMMENT ON COLUMN T_LIMS_STAFF.CREATEDBYID IS '制单人编码';
|
|
COMMENT ON COLUMN T_LIMS_STAFF.CREATEDBYNAME IS '制单人名称';
|
|
COMMENT ON COLUMN T_LIMS_STAFF.CREATEDTIME IS '制单时间';
|
|
COMMENT ON COLUMN T_LIMS_STAFF.CREATEDBYORGID IS '制单人单位编码';
|
|
COMMENT ON COLUMN T_LIMS_STAFF.CREATEDBYORGNAME IS '制单人单位名称';
|
|
COMMENT ON COLUMN T_LIMS_STAFF.USERID IS '人员编码';
|
|
COMMENT ON COLUMN T_LIMS_STAFF.USERNAME IS '人员姓名';
|
|
COMMENT ON COLUMN T_LIMS_STAFF.USERNO IS '人员工号';
|
|
COMMENT ON COLUMN T_LIMS_STAFF.SEX IS '性别';
|
|
COMMENT ON COLUMN T_LIMS_STAFF.BRITHDAY IS '出生日期';
|
|
COMMENT ON COLUMN T_LIMS_STAFF.IDNO IS '身份证号';
|
|
COMMENT ON COLUMN T_LIMS_STAFF.NATIVEPLACE IS '籍贯';
|
|
COMMENT ON COLUMN T_LIMS_STAFF.ADDRESS IS '现住地址';
|
|
COMMENT ON COLUMN T_LIMS_STAFF.ENTRYDATE IS '入职日期';
|
|
COMMENT ON COLUMN T_LIMS_STAFF.POST IS '岗位';
|
|
COMMENT ON COLUMN T_LIMS_STAFF.PROFESSIONALTITLE IS '职称';
|
|
COMMENT ON COLUMN T_LIMS_STAFF.GRADUATION IS '毕业时间';
|
|
COMMENT ON COLUMN T_LIMS_STAFF.MAJOR IS '所学专业';
|
|
COMMENT ON COLUMN T_LIMS_STAFF.EDUDEGREE IS '文化程度';
|
|
COMMENT ON COLUMN T_LIMS_STAFF.REMARKS IS '备注';
|
|
|
|
ALTER TABLE T_LIMS_STAFF ADD CONSTRAINT PK_LIMS_STAFF PRIMARY KEY (ID);
|
|
|
|
CALL INSERTI18N('T_LIMS_STAFF.SERVICE_NAME', '人员档案表', '人员档案表', 'zh-CN', '人员档案表');
|
|
CALL INSERTI18N('T_LIMS_STAFF.ID', '人员档案表的主键', '主键', 'zh-CN', '主键');
|
|
CALL INSERTI18N('T_LIMS_STAFF.CREATEDBYID', '人员档案表的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
|
|
CALL INSERTI18N('T_LIMS_STAFF.CREATEDBYNAME', '人员档案表的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
|
|
CALL INSERTI18N('T_LIMS_STAFF.CREATEDTIME', '人员档案表的制单时间', '制单时间', 'zh-CN', '制单时间');
|
|
CALL INSERTI18N('T_LIMS_STAFF.CREATEDBYORGID', '人员档案表的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
|
|
CALL INSERTI18N('T_LIMS_STAFF.CREATEDBYORGNAME', '人员档案表的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
|
|
CALL INSERTI18N('T_LIMS_STAFF.USERID', '人员档案表的人员编码', '人员编码', 'zh-CN', '人员编码');
|
|
CALL INSERTI18N('T_LIMS_STAFF.USERNAME', '人员档案表的人员姓名', '人员姓名', 'zh-CN', '人员姓名');
|
|
CALL INSERTI18N('T_LIMS_STAFF.USERNO', '人员档案表的人员工号', '人员工号', 'zh-CN', '人员工号');
|
|
CALL INSERTI18N('T_LIMS_STAFF.SEX', '人员档案表的性别', '性别', 'zh-CN', '性别');
|
|
CALL INSERTI18N('T_LIMS_STAFF.BRITHDAY', '人员档案表的出生日期', '出生日期', 'zh-CN', '出生日期');
|
|
CALL INSERTI18N('T_LIMS_STAFF.IDNO', '人员档案表的身份证号', '身份证号', 'zh-CN', '身份证号');
|
|
CALL INSERTI18N('T_LIMS_STAFF.NATIVEPLACE', '人员档案表的籍贯', '籍贯', 'zh-CN', '籍贯');
|
|
CALL INSERTI18N('T_LIMS_STAFF.ADDRESS', '人员档案表的现住地址', '现住地址', 'zh-CN', '现住地址');
|
|
CALL INSERTI18N('T_LIMS_STAFF.ENTRYDATE', '人员档案表的入职日期', '入职日期', 'zh-CN', '入职日期');
|
|
CALL INSERTI18N('T_LIMS_STAFF.POST', '人员档案表的岗位', '岗位', 'zh-CN', '岗位');
|
|
CALL INSERTI18N('T_LIMS_STAFF.PROFESSIONALTITLE', '人员档案表的职称', '职称', 'zh-CN', '职称');
|
|
CALL INSERTI18N('T_LIMS_STAFF.GRADUATION', '人员档案表的毕业时间', '毕业时间', 'zh-CN', '毕业时间');
|
|
CALL INSERTI18N('T_LIMS_STAFF.MAJOR', '人员档案表的所学专业', '所学专业', 'zh-CN', '所学专业');
|
|
CALL INSERTI18N('T_LIMS_STAFF.EDUDEGREE', '人员档案表的文化程度', '文化程度', 'zh-CN', '文化程度');
|
|
CALL INSERTI18N('T_LIMS_STAFF.REMARKS', '人员档案表的备注', '备注', 'zh-CN', '备注');
|
|
CALL INSERTI18N('BASEMODULE.BASEDATA.STAFF.STAFFS.MODAL.ADD', '新增', '新增', 'zh-CN', '新增');
|
|
CALL INSERTI18N('BASEMODULE.BASEDATA.STAFF.STAFFS.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息');
|
|
CALL INSERTI18N('BASEMODULE.BASEDATA.STAFF.STAFFS.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮');
|
|
CALL INSERTI18N('BASEMODULE.BASEDATA.STAFF.STAFFS.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框');
|
|
CALL INSERTI18N('BASEMODULE.BASEDATA.STAFF.STAFFS.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框');
|
|
|
|
-- 创建菜单语句
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('9101', '人员管理', '', '91', '9101', '008.svg', '人员管理');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('910101', '人员信息', '/secure/basemodule/basedata/staff/staffs/page/edit-list', '9101', '910101', '008.svg', '人员信息');
|
|
|
|
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
|
|
VALUES ('T_LIMS_STAFF', '0', '0');
|
|
|
|
|
|
COMMIT;
|
|
|
|
-- 建表语句
|
|
CREATE TABLE T_LIMS_STAFF_TEST_GRANT(
|
|
ID NUMBER NOT NULL,
|
|
CREATEDBYID VARCHAR2(36) NULL,
|
|
CREATEDBYNAME VARCHAR2(60) NULL,
|
|
CREATEDTIME DATE NULL,
|
|
CREATEDBYORGID VARCHAR2(36) NULL,
|
|
CREATEDBYORGNAME VARCHAR2(270) NULL,
|
|
PROCESSSTATUS VARCHAR2(36) NULL,
|
|
STAFFID NUMBER NULL,
|
|
STAFFNAME VARCHAR2(60) NULL,
|
|
TESTID NUMBER NULL,
|
|
REMARKS VARCHAR2(360) NULL
|
|
);
|
|
COMMENT ON TABLE T_LIMS_STAFF_TEST_GRANT IS '人员检测项目授权表';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_TEST_GRANT.ID IS '主键';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_TEST_GRANT.CREATEDBYID IS '制单人编码';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_TEST_GRANT.CREATEDBYNAME IS '制单人名称';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_TEST_GRANT.CREATEDTIME IS '制单时间';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_TEST_GRANT.CREATEDBYORGID IS '制单人单位编码';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_TEST_GRANT.CREATEDBYORGNAME IS '制单人单位名称';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_TEST_GRANT.PROCESSSTATUS IS '流程状态';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_TEST_GRANT.STAFFID IS '人员ID';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_TEST_GRANT.STAFFNAME IS '人员名称';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_TEST_GRANT.TESTID IS '检测项目ID';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_TEST_GRANT.REMARKS IS '备注';
|
|
|
|
ALTER TABLE T_LIMS_STAFF_TEST_GRANT ADD CONSTRAINT PK_LIMS_STAFF_TEST_GRANT PRIMARY KEY (ID);
|
|
|
|
CALL INSERTI18N('T_LIMS_STAFF_TEST_GRANT.SERVICE_NAME', '人员检测项目授权表', '人员检测项目授权表', 'zh-CN', '人员检测项目授权表');
|
|
CALL INSERTI18N('T_LIMS_STAFF_TEST_GRANT.ID', '人员检测项目授权表的主键', '主键', 'zh-CN', '主键');
|
|
CALL INSERTI18N('T_LIMS_STAFF_TEST_GRANT.CREATEDBYID', '人员检测项目授权表的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
|
|
CALL INSERTI18N('T_LIMS_STAFF_TEST_GRANT.CREATEDBYNAME', '人员检测项目授权表的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
|
|
CALL INSERTI18N('T_LIMS_STAFF_TEST_GRANT.CREATEDTIME', '人员检测项目授权表的制单时间', '制单时间', 'zh-CN', '制单时间');
|
|
CALL INSERTI18N('T_LIMS_STAFF_TEST_GRANT.CREATEDBYORGID', '人员检测项目授权表的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
|
|
CALL INSERTI18N('T_LIMS_STAFF_TEST_GRANT.CREATEDBYORGNAME', '人员检测项目授权表的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
|
|
CALL INSERTI18N('T_LIMS_STAFF_TEST_GRANT.PROCESSSTATUS', '人员检测项目授权表的流程状态', '流程状态', 'zh-CN', '流程状态');
|
|
CALL INSERTI18N('T_LIMS_STAFF_TEST_GRANT.STAFFID', '人员检测项目授权表的人员ID', '人员ID', 'zh-CN', '人员ID');
|
|
CALL INSERTI18N('T_LIMS_STAFF_TEST_GRANT.STAFFNAME', '人员检测项目授权表的人员名称', '人员名称', 'zh-CN', '人员名称');
|
|
CALL INSERTI18N('T_LIMS_STAFF_TEST_GRANT.TESTID', '人员检测项目授权表的检测项目ID', '检测项目ID', 'zh-CN', '检测项目ID');
|
|
CALL INSERTI18N('T_LIMS_STAFF_TEST_GRANT.REMARKS', '人员检测项目授权表的备注', '备注', 'zh-CN', '备注');
|
|
CALL INSERTI18N('BASEMODULE.BASEDATA.STAFF.TESTGRANTS.MODAL.ADD', '新增', '新增', 'zh-CN', '新增');
|
|
CALL INSERTI18N('BASEMODULE.BASEDATA.STAFF.TESTGRANTS.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息');
|
|
CALL INSERTI18N('BASEMODULE.BASEDATA.STAFF.TESTGRANTS.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮');
|
|
CALL INSERTI18N('BASEMODULE.BASEDATA.STAFF.TESTGRANTS.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框');
|
|
CALL INSERTI18N('BASEMODULE.BASEDATA.STAFF.TESTGRANTS.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框');
|
|
|
|
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
|
|
VALUES ('T_LIMS_STAFF_TEST_GRANT', '1', '0');
|
|
|
|
INSERT INTO T_CORE_MENU_EXT (ID, SERVICENAME, TABLENAME, TYPE, ENABLE)
|
|
VALUES ('910102', '检测项目授权', 'T_LIMS_STAFF_TEST_GRANT', 'audit_def', '1');
|
|
|
|
|
|
COMMIT;
|
|
|
|
-- 建表语句
|
|
CREATE TABLE T_LIMS_STAFF_EQUIPT_GRANT(
|
|
ID NUMBER NOT NULL,
|
|
CREATEDBYID VARCHAR2(36) NULL,
|
|
CREATEDBYNAME VARCHAR2(60) NULL,
|
|
CREATEDTIME DATE NULL,
|
|
CREATEDBYORGID VARCHAR2(36) NULL,
|
|
CREATEDBYORGNAME VARCHAR2(270) NULL,
|
|
PROCESSSTATUS VARCHAR2(36) NULL,
|
|
STAFFID NUMBER NULL,
|
|
STAFFNAME VARCHAR2(60) NULL,
|
|
EQUIPTID NUMBER NULL,
|
|
REMARKS VARCHAR2(360) NULL
|
|
);
|
|
COMMENT ON TABLE T_LIMS_STAFF_EQUIPT_GRANT IS '仪器设备授权表';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_EQUIPT_GRANT.ID IS '主键';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_EQUIPT_GRANT.CREATEDBYID IS '制单人编码';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_EQUIPT_GRANT.CREATEDBYNAME IS '制单人名称';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_EQUIPT_GRANT.CREATEDTIME IS '制单时间';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_EQUIPT_GRANT.CREATEDBYORGID IS '制单人单位编码';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_EQUIPT_GRANT.CREATEDBYORGNAME IS '制单人单位名称';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_EQUIPT_GRANT.PROCESSSTATUS IS '流程状态';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_EQUIPT_GRANT.STAFFID IS '人员ID';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_EQUIPT_GRANT.STAFFNAME IS '人员名称';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_EQUIPT_GRANT.EQUIPTID IS '设备ID';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_EQUIPT_GRANT.REMARKS IS '备注';
|
|
|
|
ALTER TABLE T_LIMS_STAFF_EQUIPT_GRANT ADD CONSTRAINT PK_LIMS_STAFF_EQUIPT_GRANT PRIMARY KEY (ID);
|
|
|
|
CALL INSERTI18N('T_LIMS_STAFF_EQUIPT_GRANT.SERVICE_NAME', '仪器设备授权表', '仪器设备授权表', 'zh-CN', '仪器设备授权表');
|
|
CALL INSERTI18N('T_LIMS_STAFF_EQUIPT_GRANT.ID', '仪器设备授权表的主键', '主键', 'zh-CN', '主键');
|
|
CALL INSERTI18N('T_LIMS_STAFF_EQUIPT_GRANT.CREATEDBYID', '仪器设备授权表的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
|
|
CALL INSERTI18N('T_LIMS_STAFF_EQUIPT_GRANT.CREATEDBYNAME', '仪器设备授权表的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
|
|
CALL INSERTI18N('T_LIMS_STAFF_EQUIPT_GRANT.CREATEDTIME', '仪器设备授权表的制单时间', '制单时间', 'zh-CN', '制单时间');
|
|
CALL INSERTI18N('T_LIMS_STAFF_EQUIPT_GRANT.CREATEDBYORGID', '仪器设备授权表的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
|
|
CALL INSERTI18N('T_LIMS_STAFF_EQUIPT_GRANT.CREATEDBYORGNAME', '仪器设备授权表的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
|
|
CALL INSERTI18N('T_LIMS_STAFF_EQUIPT_GRANT.PROCESSSTATUS', '仪器设备授权表的流程状态', '流程状态', 'zh-CN', '流程状态');
|
|
CALL INSERTI18N('T_LIMS_STAFF_EQUIPT_GRANT.STAFFID', '仪器设备授权表的人员ID', '人员ID', 'zh-CN', '人员ID');
|
|
CALL INSERTI18N('T_LIMS_STAFF_EQUIPT_GRANT.STAFFNAME', '仪器设备授权表的人员名称', '人员名称', 'zh-CN', '人员名称');
|
|
CALL INSERTI18N('T_LIMS_STAFF_EQUIPT_GRANT.EQUIPTID', '仪器设备授权表的设备ID', '设备ID', 'zh-CN', '设备ID');
|
|
CALL INSERTI18N('T_LIMS_STAFF_EQUIPT_GRANT.REMARKS', '仪器设备授权表的备注', '备注', 'zh-CN', '备注');
|
|
CALL INSERTI18N('BASEMODULE.BASEDATA.STAFF.EQUIPTGRANTS.MODAL.ADD', '新增', '新增', 'zh-CN', '新增');
|
|
CALL INSERTI18N('BASEMODULE.BASEDATA.STAFF.EQUIPTGRANTS.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息');
|
|
CALL INSERTI18N('BASEMODULE.BASEDATA.STAFF.EQUIPTGRANTS.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮');
|
|
CALL INSERTI18N('BASEMODULE.BASEDATA.STAFF.EQUIPTGRANTS.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框');
|
|
CALL INSERTI18N('BASEMODULE.BASEDATA.STAFF.EQUIPTGRANTS.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框');
|
|
|
|
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
|
|
VALUES ('T_LIMS_STAFF_EQUIPT_GRANT', '1', '0');
|
|
|
|
INSERT INTO T_CORE_MENU_EXT (ID, SERVICENAME, TABLENAME, TYPE, ENABLE)
|
|
VALUES ('910103', '仪器设备授权', 'T_LIMS_STAFF_EQUIPT_GRANT', 'audit_def', '1');
|
|
|
|
|
|
COMMIT;
|
|
|
|
-- 建表语句
|
|
CREATE TABLE T_LIMS_STAFF_CERTIFICATE(
|
|
ID NUMBER NOT NULL,
|
|
CREATEDBYID VARCHAR2(36) NULL,
|
|
CREATEDBYNAME VARCHAR2(60) NULL,
|
|
CREATEDTIME DATE NULL,
|
|
CREATEDBYORGID VARCHAR2(36) NULL,
|
|
CREATEDBYORGNAME VARCHAR2(270) NULL,
|
|
STAFFID NUMBER NULL,
|
|
CERTIFICATECODE VARCHAR2(36) NULL,
|
|
CERTIFICATENAME VARCHAR2(120) NULL,
|
|
ISSUEUNIT VARCHAR2(120) NULL,
|
|
ISSUEDATE DATE NULL,
|
|
EFFECTIVETIME DATE NULL,
|
|
CERTIFICATEDESC VARCHAR2(360) NULL,
|
|
REMARKS VARCHAR2(360) NULL
|
|
);
|
|
COMMENT ON TABLE T_LIMS_STAFF_CERTIFICATE IS '人员资格证书表';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_CERTIFICATE.ID IS '主键';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_CERTIFICATE.CREATEDBYID IS '制单人编码';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_CERTIFICATE.CREATEDBYNAME IS '制单人名称';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_CERTIFICATE.CREATEDTIME IS '制单时间';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_CERTIFICATE.CREATEDBYORGID IS '制单人单位编码';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_CERTIFICATE.CREATEDBYORGNAME IS '制单人单位名称';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_CERTIFICATE.STAFFID IS '人员ID';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_CERTIFICATE.CERTIFICATECODE IS '证书编号';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_CERTIFICATE.CERTIFICATENAME IS '证书名称';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_CERTIFICATE.ISSUEUNIT IS '发证单位';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_CERTIFICATE.ISSUEDATE IS '发证日期';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_CERTIFICATE.EFFECTIVETIME IS '证书有效期';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_CERTIFICATE.CERTIFICATEDESC IS '证书描述';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_CERTIFICATE.REMARKS IS '备注';
|
|
|
|
ALTER TABLE T_LIMS_STAFF_CERTIFICATE ADD CONSTRAINT PK_LIMS_STAFF_CERTIFICATE PRIMARY KEY (ID);
|
|
|
|
CALL INSERTI18N('T_LIMS_STAFF_CERTIFICATE.SERVICE_NAME', '人员资格证书表', '人员资格证书表', 'zh-CN', '人员资格证书表');
|
|
CALL INSERTI18N('T_LIMS_STAFF_CERTIFICATE.ID', '人员资格证书表的主键', '主键', 'zh-CN', '主键');
|
|
CALL INSERTI18N('T_LIMS_STAFF_CERTIFICATE.CREATEDBYID', '人员资格证书表的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
|
|
CALL INSERTI18N('T_LIMS_STAFF_CERTIFICATE.CREATEDBYNAME', '人员资格证书表的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
|
|
CALL INSERTI18N('T_LIMS_STAFF_CERTIFICATE.CREATEDTIME', '人员资格证书表的制单时间', '制单时间', 'zh-CN', '制单时间');
|
|
CALL INSERTI18N('T_LIMS_STAFF_CERTIFICATE.CREATEDBYORGID', '人员资格证书表的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
|
|
CALL INSERTI18N('T_LIMS_STAFF_CERTIFICATE.CREATEDBYORGNAME', '人员资格证书表的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
|
|
CALL INSERTI18N('T_LIMS_STAFF_CERTIFICATE.STAFFID', '人员资格证书表的人员ID', '人员ID', 'zh-CN', '人员ID');
|
|
CALL INSERTI18N('T_LIMS_STAFF_CERTIFICATE.CERTIFICATECODE', '人员资格证书表的证书编号', '证书编号', 'zh-CN', '证书编号');
|
|
CALL INSERTI18N('T_LIMS_STAFF_CERTIFICATE.CERTIFICATENAME', '人员资格证书表的证书名称', '证书名称', 'zh-CN', '证书名称');
|
|
CALL INSERTI18N('T_LIMS_STAFF_CERTIFICATE.ISSUEUNIT', '人员资格证书表的发证单位', '发证单位', 'zh-CN', '发证单位');
|
|
CALL INSERTI18N('T_LIMS_STAFF_CERTIFICATE.ISSUEDATE', '人员资格证书表的发证日期', '发证日期', 'zh-CN', '发证日期');
|
|
CALL INSERTI18N('T_LIMS_STAFF_CERTIFICATE.EFFECTIVETIME', '人员资格证书表的证书有效期', '证书有效期', 'zh-CN', '证书有效期');
|
|
CALL INSERTI18N('T_LIMS_STAFF_CERTIFICATE.CERTIFICATEDESC', '人员资格证书表的证书描述', '证书描述', 'zh-CN', '证书描述');
|
|
CALL INSERTI18N('T_LIMS_STAFF_CERTIFICATE.REMARKS', '人员资格证书表的备注', '备注', 'zh-CN', '备注');
|
|
CALL INSERTI18N('BASEMODULE.BASEDATA.STAFF.CERTIFICATES.MODAL.ADD', '新增', '新增', 'zh-CN', '新增');
|
|
CALL INSERTI18N('BASEMODULE.BASEDATA.STAFF.CERTIFICATES.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息');
|
|
CALL INSERTI18N('BASEMODULE.BASEDATA.STAFF.CERTIFICATES.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮');
|
|
CALL INSERTI18N('BASEMODULE.BASEDATA.STAFF.CERTIFICATES.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框');
|
|
CALL INSERTI18N('BASEMODULE.BASEDATA.STAFF.CERTIFICATES.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框');
|
|
|
|
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
|
|
VALUES ('T_LIMS_STAFF_CERTIFICATE', '0', '0');
|
|
|
|
|
|
COMMIT;
|
|
|
|
-- 建表语句
|
|
CREATE TABLE T_LIMS_STAFF_WORK_EXPERIENCE(
|
|
ID NUMBER NOT NULL,
|
|
CREATEDBYID VARCHAR2(36) NULL,
|
|
CREATEDBYNAME VARCHAR2(60) NULL,
|
|
CREATEDTIME DATE NULL,
|
|
CREATEDBYORGID VARCHAR2(36) NULL,
|
|
CREATEDBYORGNAME VARCHAR2(270) NULL,
|
|
STAFFID NUMBER NULL,
|
|
STARTTIME DATE NULL,
|
|
ENDTIME DATE NULL,
|
|
WORKUNIT VARCHAR2(120) NULL,
|
|
POSITION VARCHAR2(36) NULL,
|
|
MAJORJOB VARCHAR2(360) NULL,
|
|
REMARKS VARCHAR2(360) NULL
|
|
);
|
|
COMMENT ON TABLE T_LIMS_STAFF_WORK_EXPERIENCE IS '人员工作经历表';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_WORK_EXPERIENCE.ID IS '主键';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_WORK_EXPERIENCE.CREATEDBYID IS '制单人编码';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_WORK_EXPERIENCE.CREATEDBYNAME IS '制单人名称';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_WORK_EXPERIENCE.CREATEDTIME IS '制单时间';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_WORK_EXPERIENCE.CREATEDBYORGID IS '制单人单位编码';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_WORK_EXPERIENCE.CREATEDBYORGNAME IS '制单人单位名称';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_WORK_EXPERIENCE.STAFFID IS '人员ID';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_WORK_EXPERIENCE.STARTTIME IS '开始时间';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_WORK_EXPERIENCE.ENDTIME IS '结束时间';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_WORK_EXPERIENCE.WORKUNIT IS '工作单位';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_WORK_EXPERIENCE.POSITION IS '职位';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_WORK_EXPERIENCE.MAJORJOB IS '主要工作内容';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_WORK_EXPERIENCE.REMARKS IS '备注';
|
|
|
|
ALTER TABLE T_LIMS_STAFF_WORK_EXPERIENCE ADD CONSTRAINT PK_LIMS_STAFF_WORK_EXPERIENCE PRIMARY KEY (ID);
|
|
|
|
CALL INSERTI18N('T_LIMS_STAFF_WORK_EXPERIENCE.SERVICE_NAME', '人员工作经历表', '人员工作经历表', 'zh-CN', '人员工作经历表');
|
|
CALL INSERTI18N('T_LIMS_STAFF_WORK_EXPERIENCE.ID', '人员工作经历表的主键', '主键', 'zh-CN', '主键');
|
|
CALL INSERTI18N('T_LIMS_STAFF_WORK_EXPERIENCE.CREATEDBYID', '人员工作经历表的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
|
|
CALL INSERTI18N('T_LIMS_STAFF_WORK_EXPERIENCE.CREATEDBYNAME', '人员工作经历表的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
|
|
CALL INSERTI18N('T_LIMS_STAFF_WORK_EXPERIENCE.CREATEDTIME', '人员工作经历表的制单时间', '制单时间', 'zh-CN', '制单时间');
|
|
CALL INSERTI18N('T_LIMS_STAFF_WORK_EXPERIENCE.CREATEDBYORGID', '人员工作经历表的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
|
|
CALL INSERTI18N('T_LIMS_STAFF_WORK_EXPERIENCE.CREATEDBYORGNAME', '人员工作经历表的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
|
|
CALL INSERTI18N('T_LIMS_STAFF_WORK_EXPERIENCE.STAFFID', '人员工作经历表的人员ID', '人员ID', 'zh-CN', '人员ID');
|
|
CALL INSERTI18N('T_LIMS_STAFF_WORK_EXPERIENCE.STARTTIME', '人员工作经历表的开始时间', '开始时间', 'zh-CN', '开始时间');
|
|
CALL INSERTI18N('T_LIMS_STAFF_WORK_EXPERIENCE.ENDTIME', '人员工作经历表的结束时间', '结束时间', 'zh-CN', '结束时间');
|
|
CALL INSERTI18N('T_LIMS_STAFF_WORK_EXPERIENCE.WORKUNIT', '人员工作经历表的工作单位', '工作单位', 'zh-CN', '工作单位');
|
|
CALL INSERTI18N('T_LIMS_STAFF_WORK_EXPERIENCE.POSITION', '人员工作经历表的职位', '职位', 'zh-CN', '职位');
|
|
CALL INSERTI18N('T_LIMS_STAFF_WORK_EXPERIENCE.MAJORJOB', '人员工作经历表的主要工作内容', '主要工作内容', 'zh-CN', '主要工作内容');
|
|
CALL INSERTI18N('T_LIMS_STAFF_WORK_EXPERIENCE.REMARKS', '人员工作经历表的备注', '备注', 'zh-CN', '备注');
|
|
CALL INSERTI18N('BASEMODULE.BASEDATA.STAFF.WORKEXPERIENCES.MODAL.ADD', '新增', '新增', 'zh-CN', '新增');
|
|
CALL INSERTI18N('BASEMODULE.BASEDATA.STAFF.WORKEXPERIENCES.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息');
|
|
CALL INSERTI18N('BASEMODULE.BASEDATA.STAFF.WORKEXPERIENCES.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮');
|
|
CALL INSERTI18N('BASEMODULE.BASEDATA.STAFF.WORKEXPERIENCES.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框');
|
|
CALL INSERTI18N('BASEMODULE.BASEDATA.STAFF.WORKEXPERIENCES.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框');
|
|
|
|
|
|
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
|
|
VALUES ('T_LIMS_STAFF_WORK_EXPERIENCE', '0', '0');
|
|
|
|
|
|
COMMIT;
|
|
|
|
-- 建表语句
|
|
CREATE TABLE T_LIMS_STAFF_EDU_EXPERIENCE(
|
|
ID NUMBER NOT NULL,
|
|
CREATEDBYID VARCHAR2(36) NULL,
|
|
CREATEDBYNAME VARCHAR2(60) NULL,
|
|
CREATEDTIME DATE NULL,
|
|
CREATEDBYORGID VARCHAR2(36) NULL,
|
|
CREATEDBYORGNAME VARCHAR2(270) NULL,
|
|
STAFFID NUMBER NULL,
|
|
STARTTIME DATE NULL,
|
|
ENDTIME DATE NULL,
|
|
SCHOOL VARCHAR2(120) NULL,
|
|
ADDRESS VARCHAR2(360) NULL,
|
|
MAJOR VARCHAR2(36) NULL,
|
|
REMARKS VARCHAR2(360) NULL
|
|
);
|
|
COMMENT ON TABLE T_LIMS_STAFF_EDU_EXPERIENCE IS '人员教育经历表';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_EDU_EXPERIENCE.ID IS '主键';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_EDU_EXPERIENCE.CREATEDBYID IS '制单人编码';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_EDU_EXPERIENCE.CREATEDBYNAME IS '制单人名称';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_EDU_EXPERIENCE.CREATEDTIME IS '制单时间';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_EDU_EXPERIENCE.CREATEDBYORGID IS '制单人单位编码';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_EDU_EXPERIENCE.CREATEDBYORGNAME IS '制单人单位名称';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_EDU_EXPERIENCE.STAFFID IS '人员ID';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_EDU_EXPERIENCE.STARTTIME IS '开始时间';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_EDU_EXPERIENCE.ENDTIME IS '结束时间';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_EDU_EXPERIENCE.SCHOOL IS '学校';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_EDU_EXPERIENCE.ADDRESS IS '学校地址';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_EDU_EXPERIENCE.MAJOR IS '所学专业';
|
|
COMMENT ON COLUMN T_LIMS_STAFF_EDU_EXPERIENCE.REMARKS IS '备注';
|
|
|
|
ALTER TABLE T_LIMS_STAFF_EDU_EXPERIENCE ADD CONSTRAINT PK_LIMS_STAFF_EDU_EXPERIENCE PRIMARY KEY (ID);
|
|
|
|
CALL INSERTI18N('T_LIMS_STAFF_EDU_EXPERIENCE.SERVICE_NAME', '人员教育经历表', '人员教育经历表', 'zh-CN', '人员教育经历表');
|
|
CALL INSERTI18N('T_LIMS_STAFF_EDU_EXPERIENCE.ID', '人员教育经历表的主键', '主键', 'zh-CN', '主键');
|
|
CALL INSERTI18N('T_LIMS_STAFF_EDU_EXPERIENCE.CREATEDBYID', '人员教育经历表的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
|
|
CALL INSERTI18N('T_LIMS_STAFF_EDU_EXPERIENCE.CREATEDBYNAME', '人员教育经历表的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
|
|
CALL INSERTI18N('T_LIMS_STAFF_EDU_EXPERIENCE.CREATEDTIME', '人员教育经历表的制单时间', '制单时间', 'zh-CN', '制单时间');
|
|
CALL INSERTI18N('T_LIMS_STAFF_EDU_EXPERIENCE.CREATEDBYORGID', '人员教育经历表的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
|
|
CALL INSERTI18N('T_LIMS_STAFF_EDU_EXPERIENCE.CREATEDBYORGNAME', '人员教育经历表的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
|
|
CALL INSERTI18N('T_LIMS_STAFF_EDU_EXPERIENCE.STAFFID', '人员教育经历表的人员ID', '人员ID', 'zh-CN', '人员ID');
|
|
CALL INSERTI18N('T_LIMS_STAFF_EDU_EXPERIENCE.STARTTIME', '人员教育经历表的开始时间', '开始时间', 'zh-CN', '开始时间');
|
|
CALL INSERTI18N('T_LIMS_STAFF_EDU_EXPERIENCE.ENDTIME', '人员教育经历表的结束时间', '结束时间', 'zh-CN', '结束时间');
|
|
CALL INSERTI18N('T_LIMS_STAFF_EDU_EXPERIENCE.SCHOOL', '人员教育经历表的学校', '学校', 'zh-CN', '学校');
|
|
CALL INSERTI18N('T_LIMS_STAFF_EDU_EXPERIENCE.ADDRESS', '人员教育经历表的学校地址', '学校地址', 'zh-CN', '学校地址');
|
|
CALL INSERTI18N('T_LIMS_STAFF_EDU_EXPERIENCE.MAJOR', '人员教育经历表的所学专业', '所学专业', 'zh-CN', '所学专业');
|
|
CALL INSERTI18N('T_LIMS_STAFF_EDU_EXPERIENCE.REMARKS', '人员教育经历表的备注', '备注', 'zh-CN', '备注');
|
|
CALL INSERTI18N('BASEMODULE.BASEDATA.STAFF.EDUEXPERIENCES.MODAL.ADD', '新增', '新增', 'zh-CN', '新增');
|
|
CALL INSERTI18N('BASEMODULE.BASEDATA.STAFF.EDUEXPERIENCES.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息');
|
|
CALL INSERTI18N('BASEMODULE.BASEDATA.STAFF.EDUEXPERIENCES.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮');
|
|
CALL INSERTI18N('BASEMODULE.BASEDATA.STAFF.EDUEXPERIENCES.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框');
|
|
CALL INSERTI18N('BASEMODULE.BASEDATA.STAFF.EDUEXPERIENCES.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框');
|
|
|
|
|
|
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
|
|
VALUES ('T_LIMS_STAFF_EDU_EXPERIENCE', '0', '0');
|
|
|
|
|
|
COMMIT;
|
|
|
|
CALL INSERTI18N('BASEMODULE.BASEDATA.STAFF.STAFFS.STAFF', '基本信息', '基本信息', 'zh-CN', '基本信息');
|
|
CALL INSERTI18N('BASEMODULE.BASEDATA.STAFF.STAFFS.CERTIFICATE', '资格证书', '资格证书', 'zh-CN', '资格证书');
|
|
CALL INSERTI18N('BASEMODULE.BASEDATA.STAFF.STAFFS.WORKEXPERIENCE', '工作经历', '工作经历', 'zh-CN', '工作经历');
|
|
CALL INSERTI18N('BASEMODULE.BASEDATA.STAFF.STAFFS.EDUEXPERIENCE', '教育经历', '教育经历', 'zh-CN', '教育经历');
|
|
CALL INSERTI18N('BASEMODULE.BASEDATA.STAFF.STAFFS.TESTGRANT', '检测项目授权', '检测项目授权', 'zh-CN', '检测项目授权');
|
|
CALL INSERTI18N('BASEMODULE.BASEDATA.STAFF.STAFFS.EQUIPTGRANT', '仪器设备授权', '仪器设备授权', 'zh-CN', '仪器设备授权');
|
|
CALL INSERTI18N('BASEMODULE.BASEDATA.STAFF.STAFFS.EMPTY.TOAST', '未选中人员', '未选中人员', 'zh-CN', '未选中人员');
|
|
CALL INSERTI18N('T_LIMS_STAFF_EQUIPT_GRANT.EXT.EQUIPTNAME', '设备名称', '未选中人员', 'zh-CN', '设备名称');
|
|
CALL INSERTI18N('T_LIMS_STAFF_EQUIPT_GRANT.EXT.EQUIPTCODE', '设备编号', '未选中人员', 'zh-CN', '设备编号');
|
|
CALL INSERTI18N('T_LIMS_STAFF_TEST_GRANT.EXT.TESTCODE', '检测项目编码', '未选中人员', 'zh-CN', '检测项目编码');
|
|
CALL INSERTI18N('T_LIMS_STAFF_TEST_GRANT.EXT.TESTNAME', '检测项目名称', '未选中人员', 'zh-CN', '检测项目名称');
|
|
|
|
|
|
INSERT INTO T_CORE_CODE_CATEGORY (ID, CODECATEGORYNAME, CODECLASSID)
|
|
VALUES ('eduDegree', '文化程度', 'sys');
|
|
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
|
|
VALUES (202208301501, '初中', '1', 1, 'eduDegree', 0, 'admin', '系统管理员', '0');
|
|
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
|
|
VALUES (202208301502, '高中', '2', 2, 'eduDegree', 0, 'admin', '系统管理员', '0');
|
|
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
|
|
VALUES (202208301503, '大学', '3', 3, 'eduDegree', 0, 'admin', '系统管理员', '0');
|
|
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
|
|
VALUES (202208301504, '研究生', '4', 4, 'eduDegree', 0, 'admin', '系统管理员', '0');
|
|
|
|
-- ----------------------------- 2022-08-30 add by lijiaxing@sunwayworld.com------------end
|
|
|
|
-- 创建菜单语句
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('910102', '检测项目授权管理', '', '9101', '2', '008.svg', '人员信息');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('91010201', '检测项目授权申请', '/secure/basemodule/basedata/staff/staff-test-grants/page/edit-list', '910102', '1', '008.svg', '检测项目授权申请');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('91010202', '检测项目授权审核', '/secure/basemodule/basedata/staff/staff-test-grants/page/audit-list', '910102', '2', '008.svg', '检测项目授权审核');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('91010203', '检测项目授权查询', '/secure/basemodule/basedata/staff/staff-test-grants/page/search-list', '910102', '3', '008.svg', '检测项目授权查询');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('910103', '设备授权管理', '', '9101', '3', '008.svg', '设备授权管理');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('91010301', '设备授权申请', '/secure/basemodule/basedata/staff/staff-equipt-grants/page/edit-list', '910103', '1', '008.svg', '设备授权申请');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('91010302', '设备授权审核', '/secure/basemodule/basedata/staff/staff-equipt-grants/page/audit-list', '910103', '2', '008.svg', '设备授权审核');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('91010303', '设备授权查询', '/secure/basemodule/basedata/staff/staff-equipt-grants/page/search-list', '910103', '3', '008.svg', '设备授权查询');
|
|
|
|
INSERT INTO T_CORE_ADMIN_CHOOSE_CONFIG (ID,NAME,TITLE,CATEGORY,URL,WIDTH) VALUES
|
|
(202209051514,'人员','人员','staffChoose','/secure/basemodule/basedata/staff/staffs/page/choose-list','80%');
|
|
INSERT INTO T_CORE_ADMIN_CHOOSE_CONFIG (ID,NAME,TITLE,CATEGORY,URL,WIDTH) VALUES
|
|
(2022082616372,'检测项目','检测项目','testChoose','/secure/basemodule/coredata/tests/page/choose-list','80%'); |