246 lines
21 KiB
Plaintext
246 lines
21 KiB
Plaintext
-- ----------------------------- 2022-10-08 add by qiuyf--------------begin
|
|
|
|
-- 建表语句
|
|
CREATE TABLE T_LIMS_UNCONFORMANCE(
|
|
ID NUMBER NOT NULL,
|
|
DUTYORG VARCHAR2(270) NULL,
|
|
DUTYORGID VARCHAR2(36) NULL,
|
|
COMPANION VARCHAR2(270) NULL,
|
|
COMPANIONID VARCHAR2(36) NULL,
|
|
INCONFORMITYDESC VARCHAR2(270) NULL,
|
|
CONCLUSION VARCHAR2(270) NULL,
|
|
RECOGNIZEUSER VARCHAR2(270) NULL,
|
|
RECOGNIZEUSERID VARCHAR2(36) NULL,
|
|
RECOGNIZETIME DATE NULL,
|
|
AUDITUSER VARCHAR2(270) NULL,
|
|
AUDITUSERID VARCHAR2(36) NULL,
|
|
AUDITLEADER VARCHAR2(270) NULL,
|
|
AUDITLEADERID VARCHAR2(36) NULL,
|
|
INCONFORMITYTYPE VARCHAR2(270) NULL,
|
|
INCONFORMITYDEGREE VARCHAR2(270) NULL,
|
|
ACCEPTDEGREE VARCHAR2(270) NULL,
|
|
DISPOSE VARCHAR2(270) NULL,
|
|
QUALITYPRINCIPALOPINION VARCHAR2(270) NULL,
|
|
TECHPRINCIPAL VARCHAR2(270) NULL,
|
|
TECHPRINCIPALID VARCHAR2(36) NULL,
|
|
REASONANALYSIS VARCHAR2(270) NULL,
|
|
MEASURE VARCHAR2(270) NULL,
|
|
FINISHRECTITYPLANTIME DATE NULL,
|
|
RECTITYPRINCIPAL VARCHAR2(270) NULL,
|
|
RECTITYPRINCIPALID VARCHAR2(36) NULL,
|
|
QUALITYPRINCIPAL VARCHAR2(270) NULL,
|
|
QUALITYPRINCIPALID VARCHAR2(36) NULL,
|
|
VERIFICATION VARCHAR2(270) NULL,
|
|
FINISHRECTITYTIME DATE NULL,
|
|
TRACKPRINCIPAL VARCHAR2(270) NULL,
|
|
TRACKPRINCIPALID VARCHAR2(36) NULL,
|
|
VERIFYTIME DATE NULL,
|
|
MEASUREVALIDITY VARCHAR2(270) NULL,
|
|
APPROVEQUALITYPRINCIPAL VARCHAR2(270) NULL,
|
|
APPROVEQUALITYPRINCIPALID VARCHAR2(36) NULL,
|
|
REMARK VARCHAR2(270) NULL,
|
|
PROCESSSTATUS VARCHAR2(36) NULL,
|
|
ORGID VARCHAR2(270) NULL,
|
|
ORGNAME VARCHAR2(36) NULL,
|
|
CREATEDBYID VARCHAR2(36) NULL,
|
|
CREATEDBYNAME VARCHAR2(60) NULL,
|
|
CREATEDTIME DATE NULL,
|
|
CREATEDBYORGID VARCHAR2(36) NULL,
|
|
CREATEDBYORGNAME VARCHAR2(270) NULL,
|
|
CLOSEFLAG VARCHAR2(36) NULL
|
|
);
|
|
COMMENT ON TABLE T_LIMS_UNCONFORMANCE IS '不符合项';
|
|
COMMENT ON COLUMN T_LIMS_UNCONFORMANCE.ID IS '主键';
|
|
COMMENT ON COLUMN T_LIMS_UNCONFORMANCE.DUTYORG IS '责任部门';
|
|
COMMENT ON COLUMN T_LIMS_UNCONFORMANCE.DUTYORGID IS '责任部门ID';
|
|
COMMENT ON COLUMN T_LIMS_UNCONFORMANCE.COMPANION IS '陪同人';
|
|
COMMENT ON COLUMN T_LIMS_UNCONFORMANCE.COMPANIONID IS '陪同人ID';
|
|
COMMENT ON COLUMN T_LIMS_UNCONFORMANCE.INCONFORMITYDESC IS '不符合事实描述';
|
|
COMMENT ON COLUMN T_LIMS_UNCONFORMANCE.CONCLUSION IS '结论';
|
|
COMMENT ON COLUMN T_LIMS_UNCONFORMANCE.RECOGNIZEUSER IS '识别人';
|
|
COMMENT ON COLUMN T_LIMS_UNCONFORMANCE.RECOGNIZEUSERID IS '识别人ID';
|
|
COMMENT ON COLUMN T_LIMS_UNCONFORMANCE.RECOGNIZETIME IS '识别日期';
|
|
COMMENT ON COLUMN T_LIMS_UNCONFORMANCE.AUDITUSER IS '审核员';
|
|
COMMENT ON COLUMN T_LIMS_UNCONFORMANCE.AUDITUSERID IS '审核员ID';
|
|
COMMENT ON COLUMN T_LIMS_UNCONFORMANCE.AUDITLEADER IS '审核组长';
|
|
COMMENT ON COLUMN T_LIMS_UNCONFORMANCE.AUDITLEADERID IS '审核组长ID';
|
|
COMMENT ON COLUMN T_LIMS_UNCONFORMANCE.INCONFORMITYTYPE IS '不符合类型';
|
|
COMMENT ON COLUMN T_LIMS_UNCONFORMANCE.INCONFORMITYDEGREE IS '不符合程度';
|
|
COMMENT ON COLUMN T_LIMS_UNCONFORMANCE.ACCEPTDEGREE IS '可接受程度';
|
|
COMMENT ON COLUMN T_LIMS_UNCONFORMANCE.DISPOSE IS '处理决定';
|
|
COMMENT ON COLUMN T_LIMS_UNCONFORMANCE.QUALITYPRINCIPALOPINION IS '质量负责人审批意见';
|
|
COMMENT ON COLUMN T_LIMS_UNCONFORMANCE.TECHPRINCIPAL IS '技术负责人';
|
|
COMMENT ON COLUMN T_LIMS_UNCONFORMANCE.TECHPRINCIPALID IS '技术负责人ID';
|
|
COMMENT ON COLUMN T_LIMS_UNCONFORMANCE.REASONANALYSIS IS '原因分析';
|
|
COMMENT ON COLUMN T_LIMS_UNCONFORMANCE.MEASURE IS '纠正/预防措施';
|
|
COMMENT ON COLUMN T_LIMS_UNCONFORMANCE.FINISHRECTITYPLANTIME IS '计划完成整改日期';
|
|
COMMENT ON COLUMN T_LIMS_UNCONFORMANCE.RECTITYPRINCIPAL IS '整改部门负责人';
|
|
COMMENT ON COLUMN T_LIMS_UNCONFORMANCE.RECTITYPRINCIPALID IS '整改部门负责人ID';
|
|
COMMENT ON COLUMN T_LIMS_UNCONFORMANCE.QUALITYPRINCIPAL IS '质量负责人';
|
|
COMMENT ON COLUMN T_LIMS_UNCONFORMANCE.QUALITYPRINCIPALID IS '质量负责人ID';
|
|
COMMENT ON COLUMN T_LIMS_UNCONFORMANCE.VERIFICATION IS '跟踪验证(纠正、预防措施完成情况)';
|
|
COMMENT ON COLUMN T_LIMS_UNCONFORMANCE.FINISHRECTITYTIME IS '实际完成整改日期';
|
|
COMMENT ON COLUMN T_LIMS_UNCONFORMANCE.TRACKPRINCIPAL IS '跟踪负责人';
|
|
COMMENT ON COLUMN T_LIMS_UNCONFORMANCE.TRACKPRINCIPALID IS '跟踪负责人ID';
|
|
COMMENT ON COLUMN T_LIMS_UNCONFORMANCE.VERIFYTIME IS '验证日期';
|
|
COMMENT ON COLUMN T_LIMS_UNCONFORMANCE.MEASUREVALIDITY IS '纠正措施有效性';
|
|
COMMENT ON COLUMN T_LIMS_UNCONFORMANCE.APPROVEQUALITYPRINCIPAL IS '审批质量负责人';
|
|
COMMENT ON COLUMN T_LIMS_UNCONFORMANCE.APPROVEQUALITYPRINCIPALID IS '审批质量负责人ID';
|
|
COMMENT ON COLUMN T_LIMS_UNCONFORMANCE.REMARK IS '备注';
|
|
COMMENT ON COLUMN T_LIMS_UNCONFORMANCE.PROCESSSTATUS IS '流程状态';
|
|
COMMENT ON COLUMN T_LIMS_UNCONFORMANCE.ORGID IS '所属单位编码';
|
|
COMMENT ON COLUMN T_LIMS_UNCONFORMANCE.ORGNAME IS '所属单位名称';
|
|
COMMENT ON COLUMN T_LIMS_UNCONFORMANCE.CREATEDBYID IS '制单人编码';
|
|
COMMENT ON COLUMN T_LIMS_UNCONFORMANCE.CREATEDBYNAME IS '制单人名称';
|
|
COMMENT ON COLUMN T_LIMS_UNCONFORMANCE.CREATEDTIME IS '制单时间';
|
|
COMMENT ON COLUMN T_LIMS_UNCONFORMANCE.CREATEDBYORGID IS '制单人单位编码';
|
|
COMMENT ON COLUMN T_LIMS_UNCONFORMANCE.CREATEDBYORGNAME IS '制单人单位名称';
|
|
COMMENT ON COLUMN T_LIMS_UNCONFORMANCE.CLOSEFLAG IS '是否现场关闭';
|
|
|
|
ALTER TABLE T_LIMS_UNCONFORMANCE ADD CONSTRAINT PK_LIMS_UNCONFORMANCE PRIMARY KEY (ID);
|
|
|
|
CALL INSERTI18N('T_LIMS_UNCONFORMANCE.SERVICE_NAME', '不符合项', '不符合项', 'zh-CN', '不符合项');
|
|
CALL INSERTI18N('T_LIMS_UNCONFORMANCE.ID', '不符合项的主键', '主键', 'zh-CN', '主键');
|
|
CALL INSERTI18N('T_LIMS_UNCONFORMANCE.DUTYORG', '不符合项的责任部门', '责任部门', 'zh-CN', '责任部门');
|
|
CALL INSERTI18N('T_LIMS_UNCONFORMANCE.DUTYORGID', '不符合项的责任部门ID', '责任部门ID', 'zh-CN', '责任部门ID');
|
|
CALL INSERTI18N('T_LIMS_UNCONFORMANCE.COMPANION', '不符合项的陪同人', '陪同人', 'zh-CN', '陪同人');
|
|
CALL INSERTI18N('T_LIMS_UNCONFORMANCE.COMPANIONID', '不符合项的陪同人ID', '陪同人ID', 'zh-CN', '陪同人ID');
|
|
CALL INSERTI18N('T_LIMS_UNCONFORMANCE.INCONFORMITYDESC', '不符合项的不符合事实描述', '不符合事实描述', 'zh-CN', '不符合事实描述');
|
|
CALL INSERTI18N('T_LIMS_UNCONFORMANCE.CONCLUSION', '不符合项的结论', '结论', 'zh-CN', '结论');
|
|
CALL INSERTI18N('T_LIMS_UNCONFORMANCE.RECOGNIZEUSER', '不符合项的识别人', '识别人', 'zh-CN', '识别人');
|
|
CALL INSERTI18N('T_LIMS_UNCONFORMANCE.RECOGNIZEUSERID', '不符合项的识别人ID', '识别人ID', 'zh-CN', '识别人ID');
|
|
CALL INSERTI18N('T_LIMS_UNCONFORMANCE.RECOGNIZETIME', '不符合项的识别日期', '识别日期', 'zh-CN', '识别日期');
|
|
CALL INSERTI18N('T_LIMS_UNCONFORMANCE.AUDITUSER', '不符合项的审核员', '审核员', 'zh-CN', '审核员');
|
|
CALL INSERTI18N('T_LIMS_UNCONFORMANCE.AUDITUSERID', '不符合项的审核员ID', '审核员ID', 'zh-CN', '审核员ID');
|
|
CALL INSERTI18N('T_LIMS_UNCONFORMANCE.AUDITLEADER', '不符合项的审核组长', '审核组长', 'zh-CN', '审核组长');
|
|
CALL INSERTI18N('T_LIMS_UNCONFORMANCE.AUDITLEADERID', '不符合项的审核组长ID', '审核组长ID', 'zh-CN', '审核组长ID');
|
|
CALL INSERTI18N('T_LIMS_UNCONFORMANCE.INCONFORMITYTYPE', '不符合项的不符合类型', '不符合类型', 'zh-CN', '不符合类型');
|
|
CALL INSERTI18N('T_LIMS_UNCONFORMANCE.INCONFORMITYDEGREE', '不符合项的不符合程度', '不符合程度', 'zh-CN', '不符合程度');
|
|
CALL INSERTI18N('T_LIMS_UNCONFORMANCE.ACCEPTDEGREE', '不符合项的可接受程度', '可接受程度', 'zh-CN', '可接受程度');
|
|
CALL INSERTI18N('T_LIMS_UNCONFORMANCE.DISPOSE', '不符合项的处理决定', '处理决定', 'zh-CN', '处理决定');
|
|
CALL INSERTI18N('T_LIMS_UNCONFORMANCE.QUALITYPRINCIPALOPINION', '不符合项的质量负责人审批意见', '质量负责人审批意见', 'zh-CN', '质量负责人审批意见');
|
|
CALL INSERTI18N('T_LIMS_UNCONFORMANCE.TECHPRINCIPAL', '不符合项的技术负责人', '技术负责人', 'zh-CN', '技术负责人');
|
|
CALL INSERTI18N('T_LIMS_UNCONFORMANCE.TECHPRINCIPALID', '不符合项的技术负责人ID', '技术负责人ID', 'zh-CN', '技术负责人ID');
|
|
CALL INSERTI18N('T_LIMS_UNCONFORMANCE.REASONANALYSIS', '不符合项的原因分析', '原因分析', 'zh-CN', '原因分析');
|
|
CALL INSERTI18N('T_LIMS_UNCONFORMANCE.MEASURE', '不符合项的纠正/预防措施', '纠正/预防措施', 'zh-CN', '纠正/预防措施');
|
|
CALL INSERTI18N('T_LIMS_UNCONFORMANCE.FINISHRECTITYPLANTIME', '不符合项的计划完成整改日期', '计划完成整改日期', 'zh-CN', '计划完成整改日期');
|
|
CALL INSERTI18N('T_LIMS_UNCONFORMANCE.RECTITYPRINCIPAL', '不符合项的整改部门负责人', '整改部门负责人', 'zh-CN', '整改部门负责人');
|
|
CALL INSERTI18N('T_LIMS_UNCONFORMANCE.RECTITYPRINCIPALID', '不符合项的整改部门负责人ID', '整改部门负责人ID', 'zh-CN', '整改部门负责人ID');
|
|
CALL INSERTI18N('T_LIMS_UNCONFORMANCE.QUALITYPRINCIPAL', '不符合项的质量负责人', '质量负责人', 'zh-CN', '质量负责人');
|
|
CALL INSERTI18N('T_LIMS_UNCONFORMANCE.QUALITYPRINCIPALID', '不符合项的质量负责人ID', '质量负责人ID', 'zh-CN', '质量负责人ID');
|
|
CALL INSERTI18N('T_LIMS_UNCONFORMANCE.VERIFICATION', '不符合项的跟踪验证(纠正、预防措施完成情况)', '跟踪验证(纠正、预防措施完成情况)', 'zh-CN', '跟踪验证(纠正、预防措施完成情况)');
|
|
CALL INSERTI18N('T_LIMS_UNCONFORMANCE.FINISHRECTITYTIME', '不符合项的实际完成整改日期', '实际完成整改日期', 'zh-CN', '实际完成整改日期');
|
|
CALL INSERTI18N('T_LIMS_UNCONFORMANCE.TRACKPRINCIPAL', '不符合项的跟踪负责人', '跟踪负责人', 'zh-CN', '跟踪负责人');
|
|
CALL INSERTI18N('T_LIMS_UNCONFORMANCE.TRACKPRINCIPALID', '不符合项的跟踪负责人ID', '跟踪负责人ID', 'zh-CN', '跟踪负责人ID');
|
|
CALL INSERTI18N('T_LIMS_UNCONFORMANCE.VERIFYTIME', '不符合项的验证日期', '验证日期', 'zh-CN', '验证日期');
|
|
CALL INSERTI18N('T_LIMS_UNCONFORMANCE.MEASUREVALIDITY', '不符合项的纠正措施有效性', '纠正措施有效性', 'zh-CN', '纠正措施有效性');
|
|
CALL INSERTI18N('T_LIMS_UNCONFORMANCE.APPROVEQUALITYPRINCIPAL', '不符合项的审批质量负责人', '审批质量负责人', 'zh-CN', '审批质量负责人');
|
|
CALL INSERTI18N('T_LIMS_UNCONFORMANCE.APPROVEQUALITYPRINCIPALID', '不符合项的审批质量负责人ID', '审批质量负责人ID', 'zh-CN', '审批质量负责人ID');
|
|
CALL INSERTI18N('T_LIMS_UNCONFORMANCE.REMARK', '不符合项的备注', '备注', 'zh-CN', '备注');
|
|
CALL INSERTI18N('T_LIMS_UNCONFORMANCE.PROCESSSTATUS', '不符合项的流程状态', '流程状态', 'zh-CN', '流程状态');
|
|
CALL INSERTI18N('T_LIMS_UNCONFORMANCE.ORGID', '不符合项的所属单位编码', '所属单位编码', 'zh-CN', '所属单位编码');
|
|
CALL INSERTI18N('T_LIMS_UNCONFORMANCE.ORGNAME', '不符合项的所属单位名称', '所属单位名称', 'zh-CN', '所属单位名称');
|
|
CALL INSERTI18N('T_LIMS_UNCONFORMANCE.CREATEDBYID', '不符合项的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
|
|
CALL INSERTI18N('T_LIMS_UNCONFORMANCE.CREATEDBYNAME', '不符合项的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
|
|
CALL INSERTI18N('T_LIMS_UNCONFORMANCE.CREATEDTIME', '不符合项的制单时间', '制单时间', 'zh-CN', '制单时间');
|
|
CALL INSERTI18N('T_LIMS_UNCONFORMANCE.CREATEDBYORGID', '不符合项的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
|
|
CALL INSERTI18N('T_LIMS_UNCONFORMANCE.CREATEDBYORGNAME', '不符合项的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
|
|
CALL INSERTI18N('T_LIMS_UNCONFORMANCE.CLOSEFLAG', '不符合项的是否现场关闭', '是否现场关闭', 'zh-CN', '是否现场关闭');
|
|
CALL INSERTI18N('BASEMODULE.QMS.UNCONFORMANCES.MODAL.ADD', '新增', '新增', 'zh-CN', '新增');
|
|
CALL INSERTI18N('BASEMODULE.QMS.UNCONFORMANCES.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息');
|
|
CALL INSERTI18N('BASEMODULE.QMS.UNCONFORMANCES.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮');
|
|
CALL INSERTI18N('BASEMODULE.QMS.UNCONFORMANCES.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框');
|
|
CALL INSERTI18N('BASEMODULE.QMS.UNCONFORMANCES.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框');
|
|
|
|
-- 创建菜单语句
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('7004', '不符合项管理', '', '70', '7004', '005.svg', '不符合项管理');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('700401', '登记不符合项', '/secure/basemodule/qms/unconformances/page/edit-list', '7004', '700401', '', '登记不符合项');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('700402', '不符合判定', '/secure/basemodule/qms/unconformances/page/audit-list?bpmn_statusCode=Judge', '7004', '700402', '', '不符合判定');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('700403', '不符合判定审批', '/secure/basemodule/qms/unconformances/page/audit-list?bpmn_statusCode=Audit', '7004', '700403', '', '不符合判定审批');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('700404', '不符合确认关闭', '/secure/basemodule/qms/unconformances/page/audit-list?bpmn_statusCode=Close', '7004', '700404', '', '不符合确认关闭');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('700405', '纠正预防措施制定', '/secure/basemodule/qms/unconformances/page/audit-list?bpmn_statusCode=Formulate', '7004', '700405', '', '纠正预防措施制定');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('700406', '纠正预防措施审核', '/secure/basemodule/qms/unconformances/page/audit-list?bpmn_statusCode=StepAudit', '7004', '700406', '', '纠正预防措施审核');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('700407', '纠正预防措施实施', '/secure/basemodule/qms/unconformances/page/audit-list?bpmn_statusCode=Implement', '7004', '700407', '', '纠正预防措施实施');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('700408', '跟踪验证', '/secure/basemodule/qms/unconformances/page/audit-list?bpmn_statusCode=Verify', '7004', '700408', '', '跟踪验证');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('700409', '纠正预防结果审核', '/secure/basemodule/qms/unconformances/page/audit-list?bpmn_statusCode=ResultAudit', '7004', '700409', '', '纠正预防结果审核');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('700410', '不符合项管理查询', '/secure/basemodule/qms/unconformances/page/search-list', '7004', '700410', '', '不符合项管理查询');
|
|
|
|
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
|
|
VALUES ('T_LIMS_UNCONFORMANCE', '1', '0');
|
|
|
|
INSERT INTO T_CORE_MENU_EXT (ID, SERVICENAME, TABLENAME, TYPE, ENABLE)
|
|
VALUES ('7004', '不符合项管理', 'T_LIMS_UNCONFORMANCE', 'audit_def', '1');
|
|
|
|
|
|
COMMIT;
|
|
-- ----------------------------- 2022-10-08 add by qiuyf------------end
|
|
|
|
|
|
-- ----------------------------- 2022-10-20 add by wangyuwei--------------begin
|
|
|
|
INSERT INTO T_CORE_CODE_CATEGORY (ID,CODECATEGORYNAME,CODECLASSID,REMARK,ORDERNO,VERSION,CREATEDBYID,CREATEDBYNAME,CREATEDTIME)
|
|
VALUES('inconformityType','不符合类型','sys', NULL, NULL, NULL,NULL,NULL,NULL);
|
|
INSERT INTO LIMS_BP_DEV.T_CORE_CODE
|
|
(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
|
|
VALUES(20221020001, '体系性', 'inconformityType', '1', 4, 1, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'Systematicity');
|
|
INSERT INTO LIMS_BP_DEV.T_CORE_CODE
|
|
(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
|
|
VALUES(20221020002, '实施性', 'inconformityType', '1', 4, 2, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'Implementation');
|
|
INSERT INTO LIMS_BP_DEV.T_CORE_CODE
|
|
(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
|
|
VALUES(20221020003, '效果性', 'inconformityType', '1', 3, 3, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'Effectiveness');
|
|
|
|
INSERT INTO T_CORE_CODE_CATEGORY (ID,CODECATEGORYNAME,CODECLASSID,REMARK,ORDERNO,VERSION,CREATEDBYID,CREATEDBYNAME,CREATEDTIME)
|
|
VALUES('inconformityDegree','不符合程度','sys', NULL, NULL, NULL,NULL,NULL,NULL);
|
|
INSERT INTO LIMS_BP_DEV.T_CORE_CODE
|
|
(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
|
|
VALUES(20221020004, '一般不符合，能现场整改后关闭', 'inconformityDegree', '2', 5, 1, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'GenerallyUnqualified');
|
|
INSERT INTO LIMS_BP_DEV.T_CORE_CODE
|
|
(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
|
|
VALUES(20221020005, '一般不符合项，但现场又不能现场整改关闭', 'inconformityDegree', '2', 5, 2, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'GeneralNonconformities');
|
|
INSERT INTO LIMS_BP_DEV.T_CORE_CODE
|
|
(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
|
|
VALUES(20221020006, '严重不符合', 'inconformityDegree', '2', 5, 3, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'SeriousNonconformity');
|
|
|
|
INSERT INTO T_CORE_CODE_CATEGORY (ID,CODECATEGORYNAME,CODECLASSID,REMARK,ORDERNO,VERSION,CREATEDBYID,CREATEDBYNAME,CREATEDTIME)
|
|
VALUES('acceptDegree','可接受程度','sys', NULL, NULL, NULL,NULL,NULL,NULL);
|
|
INSERT INTO LIMS_BP_DEV.T_CORE_CODE
|
|
(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
|
|
VALUES(20221020007, '可接受', 'acceptDegree', '6', 6, 1, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'Acceptable');
|
|
INSERT INTO LIMS_BP_DEV.T_CORE_CODE
|
|
(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
|
|
VALUES(20221020008, '不可接受', 'acceptDegree', '6', 6, 2, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'Unacceptable');
|
|
|
|
INSERT INTO T_CORE_CODE_CATEGORY (ID,CODECATEGORYNAME,CODECLASSID,REMARK,ORDERNO,VERSION,CREATEDBYID,CREATEDBYNAME,CREATEDTIME)
|
|
VALUES('dispose','处理决定','sys', NULL, NULL, NULL,NULL,NULL,NULL);
|
|
INSERT INTO LIMS_BP_DEV.T_CORE_CODE
|
|
(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
|
|
VALUES(20221020009, '现场整改关闭', 'dispose', '7', 7, 1, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'rectificationClosing');
|
|
INSERT INTO LIMS_BP_DEV.T_CORE_CODE
|
|
(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
|
|
VALUES(20221020010, '标识、隔离', 'dispose', '7', 7, 2, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'IdentificationIsolation');
|
|
INSERT INTO LIMS_BP_DEV.T_CORE_CODE
|
|
(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
|
|
VALUES(20221020011, '停止工作', 'dispose', '7', 7, 3, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'StopWorking');
|
|
INSERT INTO LIMS_BP_DEV.T_CORE_CODE
|
|
(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
|
|
VALUES(20221020012, '纠正措施', 'dispose', '7', 7, 4, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'CorrectiveMeasures');
|
|
INSERT INTO LIMS_BP_DEV.T_CORE_CODE
|
|
(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
|
|
VALUES(20221020013, '其他', 'dispose', '7', 7, 5, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'others');
|
|
INSERT INTO LIMS_BP_DEV.T_CORE_CODE
|
|
(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
|
|
VALUES(20221020014, '其他时可以输入', 'dispose', '7', 7, 6, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'otherInput');
|
|
-- ----------------------------- 2022-10-20 add by wangyuwei--------------end
|