223 lines
17 KiB
Plaintext
223 lines
17 KiB
Plaintext
-- ----------------------------- 2022-09-27 add by qiuyf--------------begin
|
|
|
|
-- 建表语句
|
|
CREATE TABLE T_LIMS_SUPERVISION(
|
|
ID NUMBER NOT NULL,
|
|
PLANCODE VARCHAR2(270) NULL,
|
|
PLANYEAR VARCHAR2(36) NULL,
|
|
PLANNAME VARCHAR2(270) NULL,
|
|
PROCESSSTATUS VARCHAR2(36) NULL,
|
|
CREATEDBYID VARCHAR2(36) NULL,
|
|
CREATEDBYNAME VARCHAR2(60) NULL,
|
|
CREATEDTIME DATE NULL,
|
|
CREATEDBYORGID VARCHAR2(36) NULL,
|
|
CREATEDBYORGNAME VARCHAR2(270) NULL,
|
|
ORGID VARCHAR2(36) NULL,
|
|
ORGNAME VARCHAR2(270) NULL
|
|
);
|
|
COMMENT ON TABLE T_LIMS_SUPERVISION IS '人员监督计划表';
|
|
COMMENT ON COLUMN T_LIMS_SUPERVISION.ID IS '主键';
|
|
COMMENT ON COLUMN T_LIMS_SUPERVISION.PLANCODE IS '计划编码';
|
|
COMMENT ON COLUMN T_LIMS_SUPERVISION.PLANYEAR IS '计划年度';
|
|
COMMENT ON COLUMN T_LIMS_SUPERVISION.PLANNAME IS '计划名称';
|
|
COMMENT ON COLUMN T_LIMS_SUPERVISION.PROCESSSTATUS IS '流程状态';
|
|
COMMENT ON COLUMN T_LIMS_SUPERVISION.CREATEDBYID IS '制单人编码';
|
|
COMMENT ON COLUMN T_LIMS_SUPERVISION.CREATEDBYNAME IS '制单人名称';
|
|
COMMENT ON COLUMN T_LIMS_SUPERVISION.CREATEDTIME IS '制单时间';
|
|
COMMENT ON COLUMN T_LIMS_SUPERVISION.CREATEDBYORGID IS '制单人单位编码';
|
|
COMMENT ON COLUMN T_LIMS_SUPERVISION.CREATEDBYORGNAME IS '制单人单位名称';
|
|
COMMENT ON COLUMN T_LIMS_SUPERVISION.ORGID IS '所属单位编码';
|
|
COMMENT ON COLUMN T_LIMS_SUPERVISION.ORGNAME IS '所属单位名称';
|
|
|
|
ALTER TABLE T_LIMS_SUPERVISION ADD CONSTRAINT PK_LIMS_SUPERVISION PRIMARY KEY (ID);
|
|
|
|
CREATE TABLE T_LIMS_SUPERVISION_ITEM(
|
|
ID NUMBER NOT NULL,
|
|
PLANID NUMBER NULL,
|
|
CHECKUSER VARCHAR2(270) NULL,
|
|
CHECKUSERID VARCHAR2(36) NULL,
|
|
SUPERVISIONMONTH VARCHAR2(36) NULL,
|
|
TESTNAME VARCHAR2(270) NULL,
|
|
PRODUCTINFO VARCHAR2(270) NULL,
|
|
METHODNAME VARCHAR2(270) NULL,
|
|
EVALUATIONMODE VARCHAR2(270) NULL,
|
|
EVALUATIONBASIS VARCHAR2(270) NULL,
|
|
EVALUATIONCONTENT VARCHAR2(270) NULL,
|
|
PROCESSSTATUS VARCHAR2(36) NULL,
|
|
CREATEDBYID VARCHAR2(36) NULL,
|
|
CREATEDBYNAME VARCHAR2(60) NULL,
|
|
CREATEDTIME DATE NULL,
|
|
CREATEDBYORGID VARCHAR2(36) NULL,
|
|
CREATEDBYORGNAME VARCHAR2(270) NULL,
|
|
ORGID VARCHAR2(36) NULL,
|
|
ORGNAME VARCHAR2(270) NULL
|
|
);
|
|
COMMENT ON TABLE T_LIMS_SUPERVISION_ITEM IS '工作计划表';
|
|
COMMENT ON COLUMN T_LIMS_SUPERVISION_ITEM.ID IS '主键';
|
|
COMMENT ON COLUMN T_LIMS_SUPERVISION_ITEM.PLANID IS '计划ID';
|
|
COMMENT ON COLUMN T_LIMS_SUPERVISION_ITEM.CHECKUSER IS '检测人';
|
|
COMMENT ON COLUMN T_LIMS_SUPERVISION_ITEM.CHECKUSERID IS '检测人ID';
|
|
COMMENT ON COLUMN T_LIMS_SUPERVISION_ITEM.SUPERVISIONMONTH IS '监督月份';
|
|
COMMENT ON COLUMN T_LIMS_SUPERVISION_ITEM.TESTNAME IS '测试项目';
|
|
COMMENT ON COLUMN T_LIMS_SUPERVISION_ITEM.PRODUCTINFO IS '产品信息';
|
|
COMMENT ON COLUMN T_LIMS_SUPERVISION_ITEM.METHODNAME IS '测试标准';
|
|
COMMENT ON COLUMN T_LIMS_SUPERVISION_ITEM.EVALUATIONMODE IS '考核方式';
|
|
COMMENT ON COLUMN T_LIMS_SUPERVISION_ITEM.EVALUATIONBASIS IS '评价依据';
|
|
COMMENT ON COLUMN T_LIMS_SUPERVISION_ITEM.EVALUATIONCONTENT IS '评价内容';
|
|
COMMENT ON COLUMN T_LIMS_SUPERVISION_ITEM.PROCESSSTATUS IS '流程状态';
|
|
COMMENT ON COLUMN T_LIMS_SUPERVISION_ITEM.CREATEDBYID IS '制单人编码';
|
|
COMMENT ON COLUMN T_LIMS_SUPERVISION_ITEM.CREATEDBYNAME IS '制单人名称';
|
|
COMMENT ON COLUMN T_LIMS_SUPERVISION_ITEM.CREATEDTIME IS '制单时间';
|
|
COMMENT ON COLUMN T_LIMS_SUPERVISION_ITEM.CREATEDBYORGID IS '制单人单位编码';
|
|
COMMENT ON COLUMN T_LIMS_SUPERVISION_ITEM.CREATEDBYORGNAME IS '制单人单位名称';
|
|
COMMENT ON COLUMN T_LIMS_SUPERVISION_ITEM.ORGID IS '所属单位编码';
|
|
COMMENT ON COLUMN T_LIMS_SUPERVISION_ITEM.ORGNAME IS '所属单位名称';
|
|
|
|
ALTER TABLE T_LIMS_SUPERVISION_ITEM ADD CONSTRAINT PK_LIMS_SUPERVISION_ITEM PRIMARY KEY (ID);
|
|
CREATE INDEX IDX_SUPERVISION_ITEM_PLANID ON T_LIMS_SUPERVISION_ITEM (PLANID);
|
|
|
|
CREATE TABLE T_LIMS_SUPERVISION_ITEM_RECORD(
|
|
ID NUMBER NOT NULL,
|
|
ITEMID NUMBER NULL,
|
|
TARGET VARCHAR2(270) NULL,
|
|
TARGETID VARCHAR2(36) NULL,
|
|
SUPERVISIONTYPE VARCHAR2(36) NULL,
|
|
SUPERVISIONTEST VARCHAR2(270) NULL,
|
|
SUPERVISIONTIME DATE NULL,
|
|
SUPERVISIONDESC VARCHAR2(270) NULL,
|
|
SUPERVISIONREQUEST VARCHAR2(270) NULL,
|
|
SUPERVISIONSITUATION VARCHAR2(270) NULL,
|
|
SUPERVISIONCONCLUSION VARCHAR2(270) NULL,
|
|
PROCESSSTATUS VARCHAR2(36) NULL,
|
|
CREATEDBYID VARCHAR2(36) NULL,
|
|
CREATEDBYNAME VARCHAR2(60) NULL,
|
|
CREATEDTIME DATE NULL,
|
|
CREATEDBYORGID VARCHAR2(36) NULL,
|
|
CREATEDBYORGNAME VARCHAR2(270) NULL,
|
|
ORGID VARCHAR2(36) NULL,
|
|
ORGNAME VARCHAR2(270) NULL
|
|
);
|
|
COMMENT ON TABLE T_LIMS_SUPERVISION_ITEM_RECORD IS '监督记录表';
|
|
COMMENT ON COLUMN T_LIMS_SUPERVISION_ITEM_RECORD.ID IS '主键';
|
|
COMMENT ON COLUMN T_LIMS_SUPERVISION_ITEM_RECORD.ITEMID IS '工作ID';
|
|
COMMENT ON COLUMN T_LIMS_SUPERVISION_ITEM_RECORD.TARGET IS '被监督对象';
|
|
COMMENT ON COLUMN T_LIMS_SUPERVISION_ITEM_RECORD.TARGETID IS '被监督对象ID';
|
|
COMMENT ON COLUMN T_LIMS_SUPERVISION_ITEM_RECORD.SUPERVISIONTYPE IS '监督类型';
|
|
COMMENT ON COLUMN T_LIMS_SUPERVISION_ITEM_RECORD.SUPERVISIONTEST IS '被监督项目';
|
|
COMMENT ON COLUMN T_LIMS_SUPERVISION_ITEM_RECORD.SUPERVISIONTIME IS '监督日期';
|
|
COMMENT ON COLUMN T_LIMS_SUPERVISION_ITEM_RECORD.SUPERVISIONDESC IS '说明';
|
|
COMMENT ON COLUMN T_LIMS_SUPERVISION_ITEM_RECORD.SUPERVISIONREQUEST IS '详细要求';
|
|
COMMENT ON COLUMN T_LIMS_SUPERVISION_ITEM_RECORD.SUPERVISIONSITUATION IS '监督情况';
|
|
COMMENT ON COLUMN T_LIMS_SUPERVISION_ITEM_RECORD.SUPERVISIONCONCLUSION IS '结论';
|
|
COMMENT ON COLUMN T_LIMS_SUPERVISION_ITEM_RECORD.PROCESSSTATUS IS '流程状态';
|
|
COMMENT ON COLUMN T_LIMS_SUPERVISION_ITEM_RECORD.CREATEDBYID IS '制单人编码';
|
|
COMMENT ON COLUMN T_LIMS_SUPERVISION_ITEM_RECORD.CREATEDBYNAME IS '制单人名称';
|
|
COMMENT ON COLUMN T_LIMS_SUPERVISION_ITEM_RECORD.CREATEDTIME IS '制单时间';
|
|
COMMENT ON COLUMN T_LIMS_SUPERVISION_ITEM_RECORD.CREATEDBYORGID IS '制单人单位编码';
|
|
COMMENT ON COLUMN T_LIMS_SUPERVISION_ITEM_RECORD.CREATEDBYORGNAME IS '制单人单位名称';
|
|
COMMENT ON COLUMN T_LIMS_SUPERVISION_ITEM_RECORD.ORGID IS '所属单位编码';
|
|
COMMENT ON COLUMN T_LIMS_SUPERVISION_ITEM_RECORD.ORGNAME IS '所属单位名称';
|
|
|
|
ALTER TABLE T_LIMS_SUPERVISION_ITEM_RECORD ADD CONSTRAINT PK_SUPERVISION_ITEM_RECORD PRIMARY KEY (ID);
|
|
CREATE INDEX IDX_SUPERVISION_ITEM_R_ITEMID ON T_LIMS_SUPERVISION_ITEM_RECORD (ITEMID);
|
|
|
|
CALL INSERTI18N('T_LIMS_SUPERVISION.SERVICE_NAME', '人员监督计划表', '人员监督计划表', 'zh-CN', '人员监督计划表');
|
|
CALL INSERTI18N('T_LIMS_SUPERVISION.ID', '人员监督计划表的主键', '主键', 'zh-CN', '主键');
|
|
CALL INSERTI18N('T_LIMS_SUPERVISION.PLANCODE', '人员监督计划表的计划编码', '计划编码', 'zh-CN', '计划编码');
|
|
CALL INSERTI18N('T_LIMS_SUPERVISION.PLANYEAR', '人员监督计划表的计划年度', '计划年度', 'zh-CN', '计划年度');
|
|
CALL INSERTI18N('T_LIMS_SUPERVISION.PLANNAME', '人员监督计划表的计划名称', '计划名称', 'zh-CN', '计划名称');
|
|
CALL INSERTI18N('T_LIMS_SUPERVISION.PROCESSSTATUS', '人员监督计划表的流程状态', '流程状态', 'zh-CN', '流程状态');
|
|
CALL INSERTI18N('T_LIMS_SUPERVISION.CREATEDBYID', '人员监督计划表的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
|
|
CALL INSERTI18N('T_LIMS_SUPERVISION.CREATEDBYNAME', '人员监督计划表的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
|
|
CALL INSERTI18N('T_LIMS_SUPERVISION.CREATEDTIME', '人员监督计划表的制单时间', '制单时间', 'zh-CN', '制单时间');
|
|
CALL INSERTI18N('T_LIMS_SUPERVISION.CREATEDBYORGID', '人员监督计划表的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
|
|
CALL INSERTI18N('T_LIMS_SUPERVISION.CREATEDBYORGNAME', '人员监督计划表的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
|
|
CALL INSERTI18N('T_LIMS_SUPERVISION.ORGID', '人员监督计划表的所属单位编码', '所属单位编码', 'zh-CN', '所属单位编码');
|
|
CALL INSERTI18N('T_LIMS_SUPERVISION.ORGNAME', '人员监督计划表的所属单位名称', '所属单位名称', 'zh-CN', '所属单位名称');
|
|
CALL INSERTI18N('T_LIMS_SUPERVISION_ITEM.SERVICE_NAME', '工作计划表', '工作计划表', 'zh-CN', '工作计划表');
|
|
CALL INSERTI18N('T_LIMS_SUPERVISION_ITEM.ID', '工作计划表的主键', '主键', 'zh-CN', '主键');
|
|
CALL INSERTI18N('T_LIMS_SUPERVISION_ITEM.PLANID', '工作计划表的计划ID', '计划ID', 'zh-CN', '计划ID');
|
|
CALL INSERTI18N('T_LIMS_SUPERVISION_ITEM.CHECKUSER', '工作计划表的检测人', '检测人', 'zh-CN', '检测人');
|
|
CALL INSERTI18N('T_LIMS_SUPERVISION_ITEM.CHECKUSERID', '工作计划表的检测人ID', '检测人ID', 'zh-CN', '检测人ID');
|
|
CALL INSERTI18N('T_LIMS_SUPERVISION_ITEM.SUPERVISIONMONTH', '工作计划表的监督月份', '监督月份', 'zh-CN', '监督月份');
|
|
CALL INSERTI18N('T_LIMS_SUPERVISION_ITEM.TESTNAME', '工作计划表的测试项目', '测试项目', 'zh-CN', '测试项目');
|
|
CALL INSERTI18N('T_LIMS_SUPERVISION_ITEM.PRODUCTINFO', '工作计划表的产品信息', '产品信息', 'zh-CN', '产品信息');
|
|
CALL INSERTI18N('T_LIMS_SUPERVISION_ITEM.METHODNAME', '工作计划表的测试标准', '测试标准', 'zh-CN', '测试标准');
|
|
CALL INSERTI18N('T_LIMS_SUPERVISION_ITEM.EVALUATIONMODE', '工作计划表的考核方式', '考核方式', 'zh-CN', '考核方式');
|
|
CALL INSERTI18N('T_LIMS_SUPERVISION_ITEM.EVALUATIONBASIS', '工作计划表的评价依据', '评价依据', 'zh-CN', '评价依据');
|
|
CALL INSERTI18N('T_LIMS_SUPERVISION_ITEM.EVALUATIONCONTENT', '工作计划表的评价内容', '评价内容', 'zh-CN', '评价内容');
|
|
CALL INSERTI18N('T_LIMS_SUPERVISION_ITEM.PROCESSSTATUS', '工作计划表的流程状态', '流程状态', 'zh-CN', '流程状态');
|
|
CALL INSERTI18N('T_LIMS_SUPERVISION_ITEM.CREATEDBYID', '工作计划表的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
|
|
CALL INSERTI18N('T_LIMS_SUPERVISION_ITEM.CREATEDBYNAME', '工作计划表的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
|
|
CALL INSERTI18N('T_LIMS_SUPERVISION_ITEM.CREATEDTIME', '工作计划表的制单时间', '制单时间', 'zh-CN', '制单时间');
|
|
CALL INSERTI18N('T_LIMS_SUPERVISION_ITEM.CREATEDBYORGID', '工作计划表的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
|
|
CALL INSERTI18N('T_LIMS_SUPERVISION_ITEM.CREATEDBYORGNAME', '工作计划表的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
|
|
CALL INSERTI18N('T_LIMS_SUPERVISION_ITEM.ORGID', '工作计划表的所属单位编码', '所属单位编码', 'zh-CN', '所属单位编码');
|
|
CALL INSERTI18N('T_LIMS_SUPERVISION_ITEM.ORGNAME', '工作计划表的所属单位名称', '所属单位名称', 'zh-CN', '所属单位名称');
|
|
CALL INSERTI18N('T_LIMS_SUPERVISION_ITEM_RECORD.SERVICE_NAME', '监督记录表', '监督记录表', 'zh-CN', '监督记录表');
|
|
CALL INSERTI18N('T_LIMS_SUPERVISION_ITEM_RECORD.ID', '监督记录表的主键', '主键', 'zh-CN', '主键');
|
|
CALL INSERTI18N('T_LIMS_SUPERVISION_ITEM_RECORD.ITEMID', '监督记录表的工作ID', '工作ID', 'zh-CN', '工作ID');
|
|
CALL INSERTI18N('T_LIMS_SUPERVISION_ITEM_RECORD.TARGET', '监督记录表的被监督对象', '被监督对象', 'zh-CN', '被监督对象');
|
|
CALL INSERTI18N('T_LIMS_SUPERVISION_ITEM_RECORD.TARGETID', '监督记录表的被监督对象ID', '被监督对象ID', 'zh-CN', '被监督对象ID');
|
|
CALL INSERTI18N('T_LIMS_SUPERVISION_ITEM_RECORD.SUPERVISIONTYPE', '监督记录表的监督类型', '监督类型', 'zh-CN', '监督类型');
|
|
CALL INSERTI18N('T_LIMS_SUPERVISION_ITEM_RECORD.SUPERVISIONTEST', '监督记录表的被监督项目', '被监督项目', 'zh-CN', '被监督项目');
|
|
CALL INSERTI18N('T_LIMS_SUPERVISION_ITEM_RECORD.SUPERVISIONTIME', '监督记录表的监督日期', '监督日期', 'zh-CN', '监督日期');
|
|
CALL INSERTI18N('T_LIMS_SUPERVISION_ITEM_RECORD.SUPERVISIONDESC', '监督记录表的说明', '说明', 'zh-CN', '说明');
|
|
CALL INSERTI18N('T_LIMS_SUPERVISION_ITEM_RECORD.SUPERVISIONREQUEST', '监督记录表的详细要求', '详细要求', 'zh-CN', '详细要求');
|
|
CALL INSERTI18N('T_LIMS_SUPERVISION_ITEM_RECORD.SUPERVISIONSITUATION', '监督记录表的监督情况', '监督情况', 'zh-CN', '监督情况');
|
|
CALL INSERTI18N('T_LIMS_SUPERVISION_ITEM_RECORD.SUPERVISIONCONCLUSION', '监督记录表的结论', '结论', 'zh-CN', '结论');
|
|
CALL INSERTI18N('T_LIMS_SUPERVISION_ITEM_RECORD.PROCESSSTATUS', '监督记录表的流程状态', '流程状态', 'zh-CN', '流程状态');
|
|
CALL INSERTI18N('T_LIMS_SUPERVISION_ITEM_RECORD.CREATEDBYID', '监督记录表的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
|
|
CALL INSERTI18N('T_LIMS_SUPERVISION_ITEM_RECORD.CREATEDBYNAME', '监督记录表的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
|
|
CALL INSERTI18N('T_LIMS_SUPERVISION_ITEM_RECORD.CREATEDTIME', '监督记录表的制单时间', '制单时间', 'zh-CN', '制单时间');
|
|
CALL INSERTI18N('T_LIMS_SUPERVISION_ITEM_RECORD.CREATEDBYORGID', '监督记录表的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
|
|
CALL INSERTI18N('T_LIMS_SUPERVISION_ITEM_RECORD.CREATEDBYORGNAME', '监督记录表的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
|
|
CALL INSERTI18N('T_LIMS_SUPERVISION_ITEM_RECORD.ORGID', '监督记录表的所属单位编码', '所属单位编码', 'zh-CN', '所属单位编码');
|
|
CALL INSERTI18N('T_LIMS_SUPERVISION_ITEM_RECORD.ORGNAME', '监督记录表的所属单位名称', '所属单位名称', 'zh-CN', '所属单位名称');
|
|
CALL INSERTI18N('BASEMODULE.QMS.SUPERVISIONS.MODAL.ADD', '新增', '新增', 'zh-CN', '新增');
|
|
CALL INSERTI18N('BASEMODULE.QMS.SUPERVISIONS.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息');
|
|
CALL INSERTI18N('BASEMODULE.QMS.SUPERVISIONS.TAB.ITEM', '工作计划表', '工作计划表', 'zh-CN', '工作计划表');
|
|
CALL INSERTI18N('BASEMODULE.QMS.SUPERVISIONS.TAB.ITEM_RECORD', '监督记录表', '监督记录表', 'zh-CN', '监督记录表');
|
|
CALL INSERTI18N('BASEMODULE.QMS.SUPERVISIONS.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮');
|
|
CALL INSERTI18N('BASEMODULE.QMS.SUPERVISIONS.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框');
|
|
CALL INSERTI18N('BASEMODULE.QMS.SUPERVISIONS.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框');
|
|
|
|
|
|
-- 创建菜单语句
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('7015', '人员监督', '', '70', '7015', '017.svg', '人员监督');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('701501', '年度人员监督计划编制', '/secure/basemodule/qms/supervisions/page/edit-list', '7015', '701501', '', '年度人员监督计划编制');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('701502', '年度人员监督计划审核批准', '/secure/basemodule/qms/supervisions/page/audit-list?bpmn_statusCode=Audit', '7015', '701502', '', '年度人员监督计划审核批准');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('701503', '人员监督计划实施', '/secure/basemodule/qms/supervisions/page/item/edit-list', '7015', '701503', '', '人员监督计划实施');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('701504', '监督过程审核', '/secure/basemodule/qms/supervisions/page/item/audit-list', '7015', '701504', '', '监督过程审核');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('701505', '人员监督查询', '/secure/basemodule/qms/supervisions/page/search-list', '7015', '701505', '', '人员监督查询');
|
|
|
|
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
|
|
VALUES ('T_LIMS_SUPERVISION', '1', '0');
|
|
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
|
|
VALUES ('T_LIMS_SUPERVISION_ITEM', '0', '0');
|
|
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
|
|
VALUES ('T_LIMS_SUPERVISION_ITEM_RECORD', '0', '0');
|
|
|
|
INSERT INTO T_CORE_TABLE_HIERARCHY (ID, TABLENAME, MASTERTABLENAME, REFERCOLUMN)
|
|
VALUES ('701501','T_LIMS_SUPERVISION_ITEM', 'T_LIMS_SUPERVISION', 'PLANID');
|
|
INSERT INTO T_CORE_TABLE_HIERARCHY (ID, TABLENAME, MASTERTABLENAME, REFERCOLUMN)
|
|
VALUES ('701502','T_LIMS_SUPERVISION_ITEM_RECORD', 'T_LIMS_SUPERVISION', 'ITEMID');
|
|
|
|
INSERT INTO T_CORE_MENU_EXT (ID, SERVICENAME, TABLENAME, TYPE, ENABLE)
|
|
VALUES ('701501', '年度人员监督计划', 'T_LIMS_SUPERVISION', 'audit_def', '1');
|
|
INSERT INTO T_CORE_MENU_EXT (ID, SERVICENAME, TABLENAME, TYPE, ENABLE)
|
|
VALUES ('701502', '人员监督实施', 'T_LIMS_SUPERVISION_ITEM', 'audit_def', '1');
|
|
|
|
INSERT INTO T_CORE_SEQUENCE (ID,PATTERN,JSONPARAM) VALUES ('T_LIMS_SUPERVISION','[yyyy][mm][nnnnn]','');
|
|
ALTER TABLE T_LIMS_SUPERVISION_ITEM ADD ENABLEFLAG VARCHAR2(36);
|
|
COMMENT ON COLUMN T_LIMS_SUPERVISION_ITEM.ENABLEFLAG IS '是否开启流程';
|
|
|
|
COMMIT;
|
|
|
|
-- ----------------------------- 2022-09-27 add by qiuyf------------end |