114 lines
8.2 KiB
Plaintext
114 lines
8.2 KiB
Plaintext
|
-- ----------------------------- 2022-09-26 add by qiuyf--------------begin
|
||
|
|
|
||
|
|
-- 建表语句
|
||
|
|
CREATE TABLE T_LIMS_VALIDATION_METHOD(
|
||
|
|
ID NUMBER NOT NULL,
|
||
|
|
GOAL VARCHAR2(270) NULL,
|
||
|
|
PERSONNEL VARCHAR2(270) NULL,
|
||
|
|
REAGENTEQUIP VARCHAR2(270) NULL,
|
||
|
|
ENVREQUEST VARCHAR2(270) NULL,
|
||
|
|
REFERENCE VARCHAR2(270) NULL,
|
||
|
|
TESTFLOW VARCHAR2(270) NULL,
|
||
|
|
VERIFY VARCHAR2(270) NULL,
|
||
|
|
REPETITION VARCHAR2(270) NULL,
|
||
|
|
REAPPEAR VARCHAR2(270) NULL,
|
||
|
|
ACCURACY VARCHAR2(270) NULL,
|
||
|
|
CONCLUSION VARCHAR2(270) NULL,
|
||
|
|
REPORTCODE VARCHAR2(270) NULL,
|
||
|
|
PROJECT VARCHAR2(270) NULL,
|
||
|
|
PRINCIPAL VARCHAR2(270) NULL,
|
||
|
|
PRINCIPALID VARCHAR2(270) NULL,
|
||
|
|
REMARK 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_VALIDATION_METHOD IS '方法验证';
|
||
|
|
COMMENT ON COLUMN T_LIMS_VALIDATION_METHOD.ID IS '主键';
|
||
|
|
COMMENT ON COLUMN T_LIMS_VALIDATION_METHOD.GOAL IS '目的';
|
||
|
|
COMMENT ON COLUMN T_LIMS_VALIDATION_METHOD.PERSONNEL IS '人员';
|
||
|
|
COMMENT ON COLUMN T_LIMS_VALIDATION_METHOD.REAGENTEQUIP IS '关键设备与试剂';
|
||
|
|
COMMENT ON COLUMN T_LIMS_VALIDATION_METHOD.ENVREQUEST IS '环境要求';
|
||
|
|
COMMENT ON COLUMN T_LIMS_VALIDATION_METHOD.REFERENCE IS '参考资料';
|
||
|
|
COMMENT ON COLUMN T_LIMS_VALIDATION_METHOD.TESTFLOW IS '测试流程';
|
||
|
|
COMMENT ON COLUMN T_LIMS_VALIDATION_METHOD.VERIFY IS '验证数据及分析';
|
||
|
|
COMMENT ON COLUMN T_LIMS_VALIDATION_METHOD.REPETITION IS '重复性验证';
|
||
|
|
COMMENT ON COLUMN T_LIMS_VALIDATION_METHOD.REAPPEAR IS '再现性确认';
|
||
|
|
COMMENT ON COLUMN T_LIMS_VALIDATION_METHOD.ACCURACY IS '准确性验证';
|
||
|
|
COMMENT ON COLUMN T_LIMS_VALIDATION_METHOD.CONCLUSION IS '结论';
|
||
|
|
COMMENT ON COLUMN T_LIMS_VALIDATION_METHOD.REPORTCODE IS '报告编码';
|
||
|
|
COMMENT ON COLUMN T_LIMS_VALIDATION_METHOD.PROJECT IS '项目';
|
||
|
|
COMMENT ON COLUMN T_LIMS_VALIDATION_METHOD.PRINCIPAL IS '责任人';
|
||
|
|
COMMENT ON COLUMN T_LIMS_VALIDATION_METHOD.PRINCIPALID IS '责任人ID';
|
||
|
|
COMMENT ON COLUMN T_LIMS_VALIDATION_METHOD.REMARK IS '备注';
|
||
|
|
COMMENT ON COLUMN T_LIMS_VALIDATION_METHOD.PROCESSSTATUS IS '流程状态';
|
||
|
|
COMMENT ON COLUMN T_LIMS_VALIDATION_METHOD.CREATEDBYID IS '制单人编码';
|
||
|
|
COMMENT ON COLUMN T_LIMS_VALIDATION_METHOD.CREATEDBYNAME IS '制单人名称';
|
||
|
|
COMMENT ON COLUMN T_LIMS_VALIDATION_METHOD.CREATEDTIME IS '制单时间';
|
||
|
|
COMMENT ON COLUMN T_LIMS_VALIDATION_METHOD.CREATEDBYORGID IS '制单人单位编码';
|
||
|
|
COMMENT ON COLUMN T_LIMS_VALIDATION_METHOD.CREATEDBYORGNAME IS '制单人单位名称';
|
||
|
|
COMMENT ON COLUMN T_LIMS_VALIDATION_METHOD.ORGID IS '所属单位编码';
|
||
|
|
COMMENT ON COLUMN T_LIMS_VALIDATION_METHOD.ORGNAME IS '所属单位名称';
|
||
|
|
|
||
|
|
ALTER TABLE T_LIMS_VALIDATION_METHOD ADD CONSTRAINT PK_LIMS_VALIDATION_METHOD PRIMARY KEY (ID);
|
||
|
|
|
||
|
|
CALL INSERTI18N('T_LIMS_VALIDATION_METHOD.SERVICE_NAME', '方法验证', '方法验证', 'zh-CN', '方法验证');
|
||
|
|
CALL INSERTI18N('T_LIMS_VALIDATION_METHOD.ID', '方法验证的主键', '主键', 'zh-CN', '主键');
|
||
|
|
CALL INSERTI18N('T_LIMS_VALIDATION_METHOD.GOAL', '方法验证的目的', '目的', 'zh-CN', '目的');
|
||
|
|
CALL INSERTI18N('T_LIMS_VALIDATION_METHOD.PERSONNEL', '方法验证的人员', '人员', 'zh-CN', '人员');
|
||
|
|
CALL INSERTI18N('T_LIMS_VALIDATION_METHOD.REAGENTEQUIP', '方法验证的关键设备与试剂', '关键设备与试剂', 'zh-CN', '关键设备与试剂');
|
||
|
|
CALL INSERTI18N('T_LIMS_VALIDATION_METHOD.ENVREQUEST', '方法验证的环境要求', '环境要求', 'zh-CN', '环境要求');
|
||
|
|
CALL INSERTI18N('T_LIMS_VALIDATION_METHOD.REFERENCE', '方法验证的参考资料', '参考资料', 'zh-CN', '参考资料');
|
||
|
|
CALL INSERTI18N('T_LIMS_VALIDATION_METHOD.TESTFLOW', '方法验证的测试流程', '测试流程', 'zh-CN', '测试流程');
|
||
|
|
CALL INSERTI18N('T_LIMS_VALIDATION_METHOD.VERIFY', '方法验证的验证数据及分析', '验证数据及分析', 'zh-CN', '验证数据及分析');
|
||
|
|
CALL INSERTI18N('T_LIMS_VALIDATION_METHOD.REPETITION', '方法验证的重复性验证', '重复性验证', 'zh-CN', '重复性验证');
|
||
|
|
CALL INSERTI18N('T_LIMS_VALIDATION_METHOD.REAPPEAR', '方法验证的再现性确认', '再现性确认', 'zh-CN', '再现性确认');
|
||
|
|
CALL INSERTI18N('T_LIMS_VALIDATION_METHOD.ACCURACY', '方法验证的准确性验证', '准确性验证', 'zh-CN', '准确性验证');
|
||
|
|
CALL INSERTI18N('T_LIMS_VALIDATION_METHOD.CONCLUSION', '方法验证的结论', '结论', 'zh-CN', '结论');
|
||
|
|
CALL INSERTI18N('T_LIMS_VALIDATION_METHOD.REPORTCODE', '方法验证的报告编码', '报告编码', 'zh-CN', '报告编码');
|
||
|
|
CALL INSERTI18N('T_LIMS_VALIDATION_METHOD.PROJECT', '方法验证的项目', '项目', 'zh-CN', '项目');
|
||
|
|
CALL INSERTI18N('T_LIMS_VALIDATION_METHOD.PRINCIPAL', '方法验证的责任人', '责任人', 'zh-CN', '责任人');
|
||
|
|
CALL INSERTI18N('T_LIMS_VALIDATION_METHOD.PRINCIPALID', '方法验证的责任人ID', '责任人ID', 'zh-CN', '责任人ID');
|
||
|
|
CALL INSERTI18N('T_LIMS_VALIDATION_METHOD.REMARK', '方法验证的备注', '备注', 'zh-CN', '备注');
|
||
|
|
CALL INSERTI18N('T_LIMS_VALIDATION_METHOD.PROCESSSTATUS', '方法验证的流程状态', '流程状态', 'zh-CN', '流程状态');
|
||
|
|
CALL INSERTI18N('T_LIMS_VALIDATION_METHOD.CREATEDBYID', '方法验证的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
|
||
|
|
CALL INSERTI18N('T_LIMS_VALIDATION_METHOD.CREATEDBYNAME', '方法验证的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
|
||
|
|
CALL INSERTI18N('T_LIMS_VALIDATION_METHOD.CREATEDTIME', '方法验证的制单时间', '制单时间', 'zh-CN', '制单时间');
|
||
|
|
CALL INSERTI18N('T_LIMS_VALIDATION_METHOD.CREATEDBYORGID', '方法验证的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
|
||
|
|
CALL INSERTI18N('T_LIMS_VALIDATION_METHOD.CREATEDBYORGNAME', '方法验证的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
|
||
|
|
CALL INSERTI18N('T_LIMS_VALIDATION_METHOD.ORGID', '方法验证的所属单位编码', '所属单位编码', 'zh-CN', '所属单位编码');
|
||
|
|
CALL INSERTI18N('T_LIMS_VALIDATION_METHOD.ORGNAME', '方法验证的所属单位名称', '所属单位名称', 'zh-CN', '所属单位名称');
|
||
|
|
CALL INSERTI18N('BASEMODULE.QMS.VALIDATIONMETHODS.MODAL.ADD', '新增', '新增', 'zh-CN', '新增');
|
||
|
|
CALL INSERTI18N('BASEMODULE.QMS.VALIDATIONMETHODS.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息');
|
||
|
|
CALL INSERTI18N('BASEMODULE.QMS.VALIDATIONMETHODS.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮');
|
||
|
|
CALL INSERTI18N('BASEMODULE.QMS.VALIDATIONMETHODS.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框');
|
||
|
|
CALL INSERTI18N('BASEMODULE.QMS.VALIDATIONMETHODS.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框');
|
||
|
|
|
||
|
|
-- 创建菜单语句
|
||
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
||
|
|
VALUES ('7016', '方法验证管理', '', '70', '7016', '022.svg', '方法验证管理');
|
||
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
||
|
|
VALUES ('701601', '发起方法验证', '/secure/basemodule/qms/validation-methods/page/edit-list', '7016', '701601', '', '发起方法验证');
|
||
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
||
|
|
VALUES ('701602', '组织验证确认', '/secure/basemodule/qms/validation-methods/page/audit-list?bpmn_statusCode=Confirm', '7016', '701602', '', '组织验证确认');
|
||
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
||
|
|
VALUES ('701603', '确认报告审核', '/secure/basemodule/qms/validation-methods/page/audit-list?bpmn_statusCode=Report', '7016', '701603', '', '确认报告审核');
|
||
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
||
|
|
VALUES ('701604', '方法验证管理查询', '/secure/basemodule/qms/validation-methods/page/search-list', '7016', '701604', '', '方法验证管理查询');
|
||
|
|
|
||
|
|
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
|
||
|
|
VALUES ('T_LIMS_VALIDATION_METHOD', '1', '0');
|
||
|
|
|
||
|
|
INSERT INTO T_CORE_MENU_EXT (ID, SERVICENAME, TABLENAME, TYPE, ENABLE)
|
||
|
|
VALUES ('7016', '方法验证管理', 'T_LIMS_VALIDATION_METHOD', 'audit_def', '1');
|
||
|
|
|
||
|
|
|
||
|
|
COMMIT;
|
||
|
|
|
||
|
|
-- ----------------------------- 2022-09-26 add by qiuyf------------end
|