-- ----------------------------- 2022-10-11 add by qiuyf--------------begin -- 建表语句 CREATE TABLE T_LIMS_QUALITY( ID NUMBER NOT NULL, PLANCODE VARCHAR2(270) NULL, PLANYEAR VARCHAR2(90) NULL, MONITORPLAN 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_QUALITY IS '质量计划表'; COMMENT ON COLUMN T_LIMS_QUALITY.ID IS '主键'; COMMENT ON COLUMN T_LIMS_QUALITY.PLANCODE IS '计划编码'; COMMENT ON COLUMN T_LIMS_QUALITY.PLANYEAR IS '计划年度'; COMMENT ON COLUMN T_LIMS_QUALITY.MONITORPLAN IS '监控计划'; COMMENT ON COLUMN T_LIMS_QUALITY.REMARK IS '备注'; COMMENT ON COLUMN T_LIMS_QUALITY.PROCESSSTATUS IS '流程状态'; COMMENT ON COLUMN T_LIMS_QUALITY.CREATEDBYID IS '制单人编码'; COMMENT ON COLUMN T_LIMS_QUALITY.CREATEDBYNAME IS '制单人名称'; COMMENT ON COLUMN T_LIMS_QUALITY.CREATEDTIME IS '制单时间'; COMMENT ON COLUMN T_LIMS_QUALITY.CREATEDBYORGID IS '制单人单位编码'; COMMENT ON COLUMN T_LIMS_QUALITY.CREATEDBYORGNAME IS '制单人单位名称'; COMMENT ON COLUMN T_LIMS_QUALITY.ORGID IS '所属单位编码'; COMMENT ON COLUMN T_LIMS_QUALITY.ORGNAME IS '所属单位名称'; ALTER TABLE T_LIMS_QUALITY ADD CONSTRAINT PK_LIMS_QUALITY PRIMARY KEY (ID); CREATE TABLE T_LIMS_QUALITY_ITEM( ID NUMBER NOT NULL, PLANID NUMBER NULL, MONITORITEM VARCHAR2(270) NULL, PRODUCTNAME VARCHAR2(270) NULL, MONITORSTANDARD VARCHAR2(270) NULL, MONITORGOAL VARCHAR2(270) NULL, MONITORMETHOD VARCHAR2(270) NULL, MONITORUSER VARCHAR2(270) NULL, MONITORUSERID VARCHAR2(36) NULL, IMPLTIME DATE NULL, EXECUTOR VARCHAR2(270) NULL, EXECUTORID VARCHAR2(36) 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_QUALITY_ITEM IS '质量计划项目表'; COMMENT ON COLUMN T_LIMS_QUALITY_ITEM.ID IS '主键'; COMMENT ON COLUMN T_LIMS_QUALITY_ITEM.PLANID IS '计划ID'; COMMENT ON COLUMN T_LIMS_QUALITY_ITEM.MONITORITEM IS '计划监控项目'; COMMENT ON COLUMN T_LIMS_QUALITY_ITEM.PRODUCTNAME IS '产品名称'; COMMENT ON COLUMN T_LIMS_QUALITY_ITEM.MONITORSTANDARD IS '测试标准'; COMMENT ON COLUMN T_LIMS_QUALITY_ITEM.MONITORGOAL IS '监控目的'; COMMENT ON COLUMN T_LIMS_QUALITY_ITEM.MONITORMETHOD IS '监控方法'; COMMENT ON COLUMN T_LIMS_QUALITY_ITEM.MONITORUSER IS '监控人'; COMMENT ON COLUMN T_LIMS_QUALITY_ITEM.MONITORUSERID IS '监控人ID'; COMMENT ON COLUMN T_LIMS_QUALITY_ITEM.IMPLTIME IS '计划实施时间'; COMMENT ON COLUMN T_LIMS_QUALITY_ITEM.EXECUTOR IS '执行人'; COMMENT ON COLUMN T_LIMS_QUALITY_ITEM.EXECUTORID IS '执行人ID'; COMMENT ON COLUMN T_LIMS_QUALITY_ITEM.PROCESSSTATUS IS '流程状态'; COMMENT ON COLUMN T_LIMS_QUALITY_ITEM.CREATEDBYID IS '制单人编码'; COMMENT ON COLUMN T_LIMS_QUALITY_ITEM.CREATEDBYNAME IS '制单人名称'; COMMENT ON COLUMN T_LIMS_QUALITY_ITEM.CREATEDTIME IS '制单时间'; COMMENT ON COLUMN T_LIMS_QUALITY_ITEM.CREATEDBYORGID IS '制单人单位编码'; COMMENT ON COLUMN T_LIMS_QUALITY_ITEM.CREATEDBYORGNAME IS '制单人单位名称'; COMMENT ON COLUMN T_LIMS_QUALITY_ITEM.ORGID IS '所属单位编码'; COMMENT ON COLUMN T_LIMS_QUALITY_ITEM.ORGNAME IS '所属单位名称'; ALTER TABLE T_LIMS_QUALITY_ITEM ADD CONSTRAINT PK_LIMS_QUALITY_ITEM PRIMARY KEY (ID); CREATE INDEX IDX_LIMS_QUALITY_ITEM_PLANID ON T_LIMS_QUALITY_ITEM (PLANID); CALL INSERTI18N('T_LIMS_QUALITY.SERVICE_NAME', '质量计划表', '质量计划表', 'zh-CN', '质量计划表'); CALL INSERTI18N('T_LIMS_QUALITY.ID', '质量计划表的主键', '主键', 'zh-CN', '主键'); CALL INSERTI18N('T_LIMS_QUALITY.PLANCODE', '质量计划表的计划编码', '计划编码', 'zh-CN', '计划编码'); CALL INSERTI18N('T_LIMS_QUALITY.PLANYEAR', '质量计划表的计划年度', '计划年度', 'zh-CN', '计划年度'); CALL INSERTI18N('T_LIMS_QUALITY.MONITORPLAN', '质量计划表的监控计划', '监控计划', 'zh-CN', '监控计划'); CALL INSERTI18N('T_LIMS_QUALITY.REMARK', '质量计划表的备注', '备注', 'zh-CN', '备注'); CALL INSERTI18N('T_LIMS_QUALITY.PROCESSSTATUS', '质量计划表的流程状态', '流程状态', 'zh-CN', '流程状态'); CALL INSERTI18N('T_LIMS_QUALITY.CREATEDBYID', '质量计划表的制单人编码', '制单人编码', 'zh-CN', '制单人编码'); CALL INSERTI18N('T_LIMS_QUALITY.CREATEDBYNAME', '质量计划表的制单人名称', '制单人名称', 'zh-CN', '制单人名称'); CALL INSERTI18N('T_LIMS_QUALITY.CREATEDTIME', '质量计划表的制单时间', '制单时间', 'zh-CN', '制单时间'); CALL INSERTI18N('T_LIMS_QUALITY.CREATEDBYORGID', '质量计划表的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码'); CALL INSERTI18N('T_LIMS_QUALITY.CREATEDBYORGNAME', '质量计划表的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称'); CALL INSERTI18N('T_LIMS_QUALITY.ORGID', '质量计划表的所属单位编码', '所属单位编码', 'zh-CN', '所属单位编码'); CALL INSERTI18N('T_LIMS_QUALITY.ORGNAME', '质量计划表的所属单位名称', '所属单位名称', 'zh-CN', '所属单位名称'); CALL INSERTI18N('T_LIMS_QUALITY_ITEM.SERVICE_NAME', '质量计划项目表', '质量计划项目表', 'zh-CN', '质量计划项目表'); CALL INSERTI18N('T_LIMS_QUALITY_ITEM.ID', '质量计划项目表的主键', '主键', 'zh-CN', '主键'); CALL INSERTI18N('T_LIMS_QUALITY_ITEM.PLANID', '质量计划项目表的计划ID', '计划ID', 'zh-CN', '计划ID'); CALL INSERTI18N('T_LIMS_QUALITY_ITEM.MONITORITEM', '质量计划项目表的计划监控项目', '计划监控项目', 'zh-CN', '计划监控项目'); CALL INSERTI18N('T_LIMS_QUALITY_ITEM.PRODUCTNAME', '质量计划项目表的产品名称', '产品名称', 'zh-CN', '产品名称'); CALL INSERTI18N('T_LIMS_QUALITY_ITEM.MONITORSTANDARD', '质量计划项目表的测试标准', '测试标准', 'zh-CN', '测试标准'); CALL INSERTI18N('T_LIMS_QUALITY_ITEM.MONITORGOAL', '质量计划项目表的监控目的', '监控目的', 'zh-CN', '监控目的'); CALL INSERTI18N('T_LIMS_QUALITY_ITEM.MONITORMETHOD', '质量计划项目表的监控方法', '监控方法', 'zh-CN', '监控方法'); CALL INSERTI18N('T_LIMS_QUALITY_ITEM.MONITORUSER', '质量计划项目表的监控人', '监控人', 'zh-CN', '监控人'); CALL INSERTI18N('T_LIMS_QUALITY_ITEM.MONITORUSERID', '质量计划项目表的监控人ID', '监控人ID', 'zh-CN', '监控人ID'); CALL INSERTI18N('T_LIMS_QUALITY_ITEM.IMPLTIME', '质量计划项目表的计划实施时间', '计划实施时间', 'zh-CN', '计划实施时间'); CALL INSERTI18N('T_LIMS_QUALITY_ITEM.EXECUTOR', '质量计划项目表的执行人', '执行人', 'zh-CN', '执行人'); CALL INSERTI18N('T_LIMS_QUALITY_ITEM.EXECUTORID', '质量计划项目表的执行人ID', '执行人ID', 'zh-CN', '执行人ID'); CALL INSERTI18N('T_LIMS_QUALITY_ITEM.PROCESSSTATUS', '质量计划项目表的流程状态', '流程状态', 'zh-CN', '流程状态'); CALL INSERTI18N('T_LIMS_QUALITY_ITEM.CREATEDBYID', '质量计划项目表的制单人编码', '制单人编码', 'zh-CN', '制单人编码'); CALL INSERTI18N('T_LIMS_QUALITY_ITEM.CREATEDBYNAME', '质量计划项目表的制单人名称', '制单人名称', 'zh-CN', '制单人名称'); CALL INSERTI18N('T_LIMS_QUALITY_ITEM.CREATEDTIME', '质量计划项目表的制单时间', '制单时间', 'zh-CN', '制单时间'); CALL INSERTI18N('T_LIMS_QUALITY_ITEM.CREATEDBYORGID', '质量计划项目表的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码'); CALL INSERTI18N('T_LIMS_QUALITY_ITEM.CREATEDBYORGNAME', '质量计划项目表的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称'); CALL INSERTI18N('T_LIMS_QUALITY_ITEM.ORGID', '质量计划项目表的所属单位编码', '所属单位编码', 'zh-CN', '所属单位编码'); CALL INSERTI18N('T_LIMS_QUALITY_ITEM.ORGNAME', '质量计划项目表的所属单位名称', '所属单位名称', 'zh-CN', '所属单位名称'); CALL INSERTI18N('BASEMODULE.QMS.QUALITYCONTROLS.MODAL.ADD', '新增', '新增', 'zh-CN', '新增'); CALL INSERTI18N('BASEMODULE.QMS.QUALITYCONTROLS.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息'); CALL INSERTI18N('BASEMODULE.QMS.QUALITYCONTROLS.TAB.ITEM', '质量计划项目表', '质量计划项目表', 'zh-CN', '质量计划项目表'); CALL INSERTI18N('BASEMODULE.QMS.QUALITYCONTROLS.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮'); CALL INSERTI18N('BASEMODULE.QMS.QUALITYCONTROLS.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框'); CALL INSERTI18N('BASEMODULE.QMS.QUALITYCONTROLS.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框'); -- 创建菜单语句 INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME) VALUES ('7001', '质量控制管理', '', '70', '7001', '026.svg', '质量控制管理'); INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME) VALUES ('700101', '质量控制计划编制', '/secure/basemodule/qms/qualitys/page/edit-list', '7001', '700101', '', '质量控制计划编制'); INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME) VALUES ('700102', '质量控制计划审核', '/secure/basemodule/qms/qualitys/page/audit-list?bpmn_statusCode=Adiut', '7001', '700102', '', '质量控制计划审核'); INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME) VALUES ('700103', '质量控制计划批准', '/secure/basemodule/qms/qualitys/page/audit-list?bpmn_statusCode=Approve', '7001', '700103', '', '质量控制计划批准'); INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME) VALUES ('700104', '安排实施', '/secure/basemodule/qms/qualitys/page/audit-list?bpmn_statusCode=Implement', '7001', '700104', '', '安排实施'); INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME) VALUES ('700105', '质量控制报告输出', '/secure/basemodule/qms/qualitys/page/audit-list?bpmn_statusCode=Report', '7001', '700105', '', '质量控制报告输出'); INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME) VALUES ('700106', '质量控制报告审批', '/secure/basemodule/qms/qualitys/page/audit-list?bpmn_statusCode=ReportAudit', '7001', '700106', '', '质量控制报告审批'); INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME) VALUES ('700107', '质量控制查询', '/secure/basemodule/qms/qualitys/page/search-list', '7001', '700107', '', '质量控制查询'); INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT) VALUES ('T_LIMS_QUALITY', '1', '0'); INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT) VALUES ('T_LIMS_QUALITY_ITEM', '0', '0'); INSERT INTO T_CORE_TABLE_HIERARCHY (ID, TABLENAME, MASTERTABLENAME, REFERCOLUMN) VALUES ('700101','T_LIMS_QUALITY_ITEM', 'T_LIMS_QUALITY', 'PLANID'); INSERT INTO T_CORE_MENU_EXT (ID, SERVICENAME, TABLENAME, TYPE, ENABLE) VALUES ('700101', '质量控制管理', 'T_LIMS_QUALITY', 'audit_def', '1'); INSERT INTO T_CORE_SEQUENCE (ID,PATTERN,JSONPARAM) VALUES ('T_LIMS_QUALITY','[yyyy][nnnn]',NULL); COMMIT; -- ----------------------------- 2022-10-11 add by qiuyf------------end -- ----------------------------- 2022-10-11 add by qiuyf--------------begin -- 建表语句 CREATE TABLE T_LIMS_COMPARISON( ID NUMBER NOT NULL, ACTIVITY VARCHAR2(270) NULL, ORGANIZATION VARCHAR2(270) NULL, ACTIVITYTIME DATE 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_COMPARISON IS '对比计划表'; COMMENT ON COLUMN T_LIMS_COMPARISON.ID IS '主键'; COMMENT ON COLUMN T_LIMS_COMPARISON.ACTIVITY IS '能力验证或比对活动名称'; COMMENT ON COLUMN T_LIMS_COMPARISON.ORGANIZATION IS '主办或组织单位名称'; COMMENT ON COLUMN T_LIMS_COMPARISON.ACTIVITYTIME IS '活动时间'; COMMENT ON COLUMN T_LIMS_COMPARISON.PROCESSSTATUS IS '流程状态'; COMMENT ON COLUMN T_LIMS_COMPARISON.CREATEDBYID IS '制单人编码'; COMMENT ON COLUMN T_LIMS_COMPARISON.CREATEDBYNAME IS '制单人名称'; COMMENT ON COLUMN T_LIMS_COMPARISON.CREATEDTIME IS '制单时间'; COMMENT ON COLUMN T_LIMS_COMPARISON.CREATEDBYORGID IS '制单人单位编码'; COMMENT ON COLUMN T_LIMS_COMPARISON.CREATEDBYORGNAME IS '制单人单位名称'; COMMENT ON COLUMN T_LIMS_COMPARISON.ORGID IS '所属单位编码'; COMMENT ON COLUMN T_LIMS_COMPARISON.ORGNAME IS '所属单位名称'; ALTER TABLE T_LIMS_COMPARISON ADD CONSTRAINT PK_LIMS_COMPARISON PRIMARY KEY (ID); CREATE TABLE T_LIMS_COMPARISON_ITEM( ID NUMBER NOT NULL, PLANID NUMBER NULL, COMPARISONITEM VARCHAR2(270) NULL, TESTMETHOD VARCHAR2(270) NULL, TESTSAMPLE VARCHAR2(270) NULL, TESTEQUIPT VARCHAR2(270) NULL, FINISHTIME DATE NULL, IMPLPRINCIPAL VARCHAR2(270) NULL, IMPLPRINCIPALID VARCHAR2(36) NULL, ITEMNAME VARCHAR2(270) NULL, GOAL VARCHAR2(270) NULL, ITEM VARCHAR2(270) NULL, IMPLTIME DATE NULL, PROPOSEUSER VARCHAR2(270) NULL, PROPOSEUSERID VARCHAR2(36) NULL, PROPOSETIME DATE NULL, ORGANIZER VARCHAR2(270) NULL, ORGANIZERID VARCHAR2(36) NULL, IMPLUSER VARCHAR2(270) NULL, IMPLUSERID VARCHAR2(36) NULL, ITEMUSER VARCHAR2(270) NULL, ITEMUSERID VARCHAR2(270) NULL, SITUATIONG VARCHAR2(270) NULL, GOODSDESC VARCHAR2(270) NULL, CRITERION VARCHAR2(270) NULL, DEVIATION VARCHAR2(270) NULL, TESTRESULT VARCHAR2(270) NULL, TESTCONCLUSION VARCHAR2(270) NULL, REASON VARCHAR2(270) NULL, MEASURE 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_COMPARISON_ITEM IS '对比计划项目表'; COMMENT ON COLUMN T_LIMS_COMPARISON_ITEM.ID IS '主键'; COMMENT ON COLUMN T_LIMS_COMPARISON_ITEM.PLANID IS '计划ID'; COMMENT ON COLUMN T_LIMS_COMPARISON_ITEM.COMPARISONITEM IS '验证或比对项目'; COMMENT ON COLUMN T_LIMS_COMPARISON_ITEM.TESTMETHOD IS '检测方法'; COMMENT ON COLUMN T_LIMS_COMPARISON_ITEM.TESTSAMPLE IS '检测样品'; COMMENT ON COLUMN T_LIMS_COMPARISON_ITEM.TESTEQUIPT IS '检测仪器'; COMMENT ON COLUMN T_LIMS_COMPARISON_ITEM.FINISHTIME IS '完成期限'; COMMENT ON COLUMN T_LIMS_COMPARISON_ITEM.IMPLPRINCIPAL IS '实施负责人'; COMMENT ON COLUMN T_LIMS_COMPARISON_ITEM.IMPLPRINCIPALID IS '实施负责人ID'; COMMENT ON COLUMN T_LIMS_COMPARISON_ITEM.ITEMNAME IS '项目名称'; COMMENT ON COLUMN T_LIMS_COMPARISON_ITEM.GOAL IS '目的'; COMMENT ON COLUMN T_LIMS_COMPARISON_ITEM.ITEM IS '比对项目'; COMMENT ON COLUMN T_LIMS_COMPARISON_ITEM.IMPLTIME IS '实施日期'; COMMENT ON COLUMN T_LIMS_COMPARISON_ITEM.PROPOSEUSER IS '提出人'; COMMENT ON COLUMN T_LIMS_COMPARISON_ITEM.PROPOSEUSERID IS '提出人ID'; COMMENT ON COLUMN T_LIMS_COMPARISON_ITEM.PROPOSETIME IS '提出日期'; COMMENT ON COLUMN T_LIMS_COMPARISON_ITEM.ORGANIZER IS '组织人'; COMMENT ON COLUMN T_LIMS_COMPARISON_ITEM.ORGANIZERID IS '组织人ID'; COMMENT ON COLUMN T_LIMS_COMPARISON_ITEM.IMPLUSER IS '实施人'; COMMENT ON COLUMN T_LIMS_COMPARISON_ITEM.IMPLUSERID IS '实施人ID'; COMMENT ON COLUMN T_LIMS_COMPARISON_ITEM.ITEMUSER IS '项目小组成员'; COMMENT ON COLUMN T_LIMS_COMPARISON_ITEM.ITEMUSERID IS '项目小组成员ID'; COMMENT ON COLUMN T_LIMS_COMPARISON_ITEM.SITUATIONG IS '参加实验室情况'; COMMENT ON COLUMN T_LIMS_COMPARISON_ITEM.GOODSDESC IS '被测物品说明'; COMMENT ON COLUMN T_LIMS_COMPARISON_ITEM.CRITERION IS '判定原则'; COMMENT ON COLUMN T_LIMS_COMPARISON_ITEM.DEVIATION IS '有无偏离情况'; COMMENT ON COLUMN T_LIMS_COMPARISON_ITEM.TESTRESULT IS '检测结果'; COMMENT ON COLUMN T_LIMS_COMPARISON_ITEM.TESTCONCLUSION IS '检测结论'; COMMENT ON COLUMN T_LIMS_COMPARISON_ITEM.REASON IS '原因分析'; COMMENT ON COLUMN T_LIMS_COMPARISON_ITEM.MEASURE IS '改进措施'; COMMENT ON COLUMN T_LIMS_COMPARISON_ITEM.PROCESSSTATUS IS '流程状态'; COMMENT ON COLUMN T_LIMS_COMPARISON_ITEM.CREATEDBYID IS '制单人编码'; COMMENT ON COLUMN T_LIMS_COMPARISON_ITEM.CREATEDBYNAME IS '制单人名称'; COMMENT ON COLUMN T_LIMS_COMPARISON_ITEM.CREATEDTIME IS '制单时间'; COMMENT ON COLUMN T_LIMS_COMPARISON_ITEM.CREATEDBYORGID IS '制单人单位编码'; COMMENT ON COLUMN T_LIMS_COMPARISON_ITEM.CREATEDBYORGNAME IS '制单人单位名称'; COMMENT ON COLUMN T_LIMS_COMPARISON_ITEM.ORGID IS '所属单位编码'; COMMENT ON COLUMN T_LIMS_COMPARISON_ITEM.ORGNAME IS '所属单位名称'; ALTER TABLE T_LIMS_COMPARISON_ITEM ADD CONSTRAINT PK_LIMS_COMPARISON_ITEM PRIMARY KEY (ID); CREATE INDEX IDX_LIMS_COMPARISON_ITEM_PLANID ON T_LIMS_COMPARISON_ITEM (PLANID); CALL INSERTI18N('T_LIMS_COMPARISON.SERVICE_NAME', '对比计划表', '对比计划表', 'zh-CN', '对比计划表'); CALL INSERTI18N('T_LIMS_COMPARISON.ID', '对比计划表的主键', '主键', 'zh-CN', '主键'); CALL INSERTI18N('T_LIMS_COMPARISON.ACTIVITY', '对比计划表的能力验证或比对活动名称', '能力验证或比对活动名称', 'zh-CN', '能力验证或比对活动名称'); CALL INSERTI18N('T_LIMS_COMPARISON.ORGANIZATION', '对比计划表的主办或组织单位名称', '主办或组织单位名称', 'zh-CN', '主办或组织单位名称'); CALL INSERTI18N('T_LIMS_COMPARISON.ACTIVITYTIME', '对比计划表的活动时间', '活动时间', 'zh-CN', '活动时间'); CALL INSERTI18N('T_LIMS_COMPARISON.PROCESSSTATUS', '对比计划表的流程状态', '流程状态', 'zh-CN', '流程状态'); CALL INSERTI18N('T_LIMS_COMPARISON.CREATEDBYID', '对比计划表的制单人编码', '制单人编码', 'zh-CN', '制单人编码'); CALL INSERTI18N('T_LIMS_COMPARISON.CREATEDBYNAME', '对比计划表的制单人名称', '制单人名称', 'zh-CN', '制单人名称'); CALL INSERTI18N('T_LIMS_COMPARISON.CREATEDTIME', '对比计划表的制单时间', '制单时间', 'zh-CN', '制单时间'); CALL INSERTI18N('T_LIMS_COMPARISON.CREATEDBYORGID', '对比计划表的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码'); CALL INSERTI18N('T_LIMS_COMPARISON.CREATEDBYORGNAME', '对比计划表的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称'); CALL INSERTI18N('T_LIMS_COMPARISON.ORGID', '对比计划表的所属单位编码', '所属单位编码', 'zh-CN', '所属单位编码'); CALL INSERTI18N('T_LIMS_COMPARISON.ORGNAME', '对比计划表的所属单位名称', '所属单位名称', 'zh-CN', '所属单位名称'); CALL INSERTI18N('T_LIMS_COMPARISON_ITEM.SERVICE_NAME', '对比计划项目表', '对比计划项目表', 'zh-CN', '对比计划项目表'); CALL INSERTI18N('T_LIMS_COMPARISON_ITEM.ID', '对比计划项目表的主键', '主键', 'zh-CN', '主键'); CALL INSERTI18N('T_LIMS_COMPARISON_ITEM.PLANID', '对比计划项目表的计划ID', '计划ID', 'zh-CN', '计划ID'); CALL INSERTI18N('T_LIMS_COMPARISON_ITEM.COMPARISONITEM', '对比计划项目表的验证或比对项目', '验证或比对项目', 'zh-CN', '验证或比对项目'); CALL INSERTI18N('T_LIMS_COMPARISON_ITEM.TESTMETHOD', '对比计划项目表的检测方法', '检测方法', 'zh-CN', '检测方法'); CALL INSERTI18N('T_LIMS_COMPARISON_ITEM.TESTSAMPLE', '对比计划项目表的检测样品', '检测样品', 'zh-CN', '检测样品'); CALL INSERTI18N('T_LIMS_COMPARISON_ITEM.TESTEQUIPT', '对比计划项目表的检测仪器', '检测仪器', 'zh-CN', '检测仪器'); CALL INSERTI18N('T_LIMS_COMPARISON_ITEM.FINISHTIME', '对比计划项目表的完成期限', '完成期限', 'zh-CN', '完成期限'); CALL INSERTI18N('T_LIMS_COMPARISON_ITEM.IMPLPRINCIPAL', '对比计划项目表的实施负责人', '实施负责人', 'zh-CN', '实施负责人'); CALL INSERTI18N('T_LIMS_COMPARISON_ITEM.IMPLPRINCIPALID', '对比计划项目表的实施负责人ID', '实施负责人ID', 'zh-CN', '实施负责人ID'); CALL INSERTI18N('T_LIMS_COMPARISON_ITEM.ITEMNAME', '对比计划项目表的项目名称', '项目名称', 'zh-CN', '项目名称'); CALL INSERTI18N('T_LIMS_COMPARISON_ITEM.GOAL', '对比计划项目表的目的', '目的', 'zh-CN', '目的'); CALL INSERTI18N('T_LIMS_COMPARISON_ITEM.ITEM', '对比计划项目表的比对项目', '比对项目', 'zh-CN', '比对项目'); CALL INSERTI18N('T_LIMS_COMPARISON_ITEM.IMPLTIME', '对比计划项目表的实施日期', '实施日期', 'zh-CN', '实施日期'); CALL INSERTI18N('T_LIMS_COMPARISON_ITEM.PROPOSEUSER', '对比计划项目表的提出人', '提出人', 'zh-CN', '提出人'); CALL INSERTI18N('T_LIMS_COMPARISON_ITEM.PROPOSEUSERID', '对比计划项目表的提出人ID', '提出人ID', 'zh-CN', '提出人ID'); CALL INSERTI18N('T_LIMS_COMPARISON_ITEM.PROPOSETIME', '对比计划项目表的提出日期', '提出日期', 'zh-CN', '提出日期'); CALL INSERTI18N('T_LIMS_COMPARISON_ITEM.ORGANIZER', '对比计划项目表的组织人', '组织人', 'zh-CN', '组织人'); CALL INSERTI18N('T_LIMS_COMPARISON_ITEM.ORGANIZERID', '对比计划项目表的组织人ID', '组织人ID', 'zh-CN', '组织人ID'); CALL INSERTI18N('T_LIMS_COMPARISON_ITEM.IMPLUSER', '对比计划项目表的实施人', '实施人', 'zh-CN', '实施人'); CALL INSERTI18N('T_LIMS_COMPARISON_ITEM.IMPLUSERID', '对比计划项目表的实施人ID', '实施人ID', 'zh-CN', '实施人ID'); CALL INSERTI18N('T_LIMS_COMPARISON_ITEM.ITEMUSER', '对比计划项目表的项目小组成员', '项目小组成员', 'zh-CN', '项目小组成员'); CALL INSERTI18N('T_LIMS_COMPARISON_ITEM.ITEMUSERID', '对比计划项目表的项目小组成员ID', '项目小组成员ID', 'zh-CN', '项目小组成员ID'); CALL INSERTI18N('T_LIMS_COMPARISON_ITEM.SITUATIONG', '对比计划项目表的参加实验室情况', '参加实验室情况', 'zh-CN', '参加实验室情况'); CALL INSERTI18N('T_LIMS_COMPARISON_ITEM.GOODSDESC', '对比计划项目表的被测物品说明', '被测物品说明', 'zh-CN', '被测物品说明'); CALL INSERTI18N('T_LIMS_COMPARISON_ITEM.CRITERION', '对比计划项目表的判定原则', '判定原则', 'zh-CN', '判定原则'); CALL INSERTI18N('T_LIMS_COMPARISON_ITEM.DEVIATION', '对比计划项目表的有无偏离情况', '有无偏离情况', 'zh-CN', '有无偏离情况'); CALL INSERTI18N('T_LIMS_COMPARISON_ITEM.TESTRESULT', '对比计划项目表的检测结果', '检测结果', 'zh-CN', '检测结果'); CALL INSERTI18N('T_LIMS_COMPARISON_ITEM.TESTCONCLUSION', '对比计划项目表的检测结论', '检测结论', 'zh-CN', '检测结论'); CALL INSERTI18N('T_LIMS_COMPARISON_ITEM.REASON', '对比计划项目表的原因分析', '原因分析', 'zh-CN', '原因分析'); CALL INSERTI18N('T_LIMS_COMPARISON_ITEM.MEASURE', '对比计划项目表的改进措施', '改进措施', 'zh-CN', '改进措施'); CALL INSERTI18N('T_LIMS_COMPARISON_ITEM.PROCESSSTATUS', '对比计划项目表的流程状态', '流程状态', 'zh-CN', '流程状态'); CALL INSERTI18N('T_LIMS_COMPARISON_ITEM.CREATEDBYID', '对比计划项目表的制单人编码', '制单人编码', 'zh-CN', '制单人编码'); CALL INSERTI18N('T_LIMS_COMPARISON_ITEM.CREATEDBYNAME', '对比计划项目表的制单人名称', '制单人名称', 'zh-CN', '制单人名称'); CALL INSERTI18N('T_LIMS_COMPARISON_ITEM.CREATEDTIME', '对比计划项目表的制单时间', '制单时间', 'zh-CN', '制单时间'); CALL INSERTI18N('T_LIMS_COMPARISON_ITEM.CREATEDBYORGID', '对比计划项目表的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码'); CALL INSERTI18N('T_LIMS_COMPARISON_ITEM.CREATEDBYORGNAME', '对比计划项目表的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称'); CALL INSERTI18N('T_LIMS_COMPARISON_ITEM.ORGID', '对比计划项目表的所属单位编码', '所属单位编码', 'zh-CN', '所属单位编码'); CALL INSERTI18N('T_LIMS_COMPARISON_ITEM.ORGNAME', '对比计划项目表的所属单位名称', '所属单位名称', 'zh-CN', '所属单位名称'); CALL INSERTI18N('BASEMODULE.QMS.QUALITYCONTROLS.MODAL.ADD', '新增', '新增', 'zh-CN', '新增'); CALL INSERTI18N('BASEMODULE.QMS.QUALITYCONTROLS.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息'); CALL INSERTI18N('BASEMODULE.QMS.QUALITYCONTROLS.TAB.ITEM', '对比计划项目表', '对比计划项目表', 'zh-CN', '对比计划项目表'); CALL INSERTI18N('BASEMODULE.QMS.QUALITYCONTROLS.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮'); CALL INSERTI18N('BASEMODULE.QMS.QUALITYCONTROLS.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框'); CALL INSERTI18N('BASEMODULE.QMS.QUALITYCONTROLS.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框'); -- 创建菜单语句 INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME) VALUES ('700108', '比对及验证计划', '/secure/basemodule/qms/comparisons/page/edit-list', '7001', '700108', '', '比对及验证计划'); INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME) VALUES ('700109', '比对及验证计划批准', '/secure/basemodule/qms/comparisons/page/audit-list?bpmn_statusCode=Adiut', '7001', '700109', '', '比对及验证计划批准'); INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME) VALUES ('700110', '比对及验证实施', '/secure/basemodule/qms/comparisons/page/audit-list?bpmn_statusCode=Implement', '7001', '700110', '', '比对及验证实施'); INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME) VALUES ('700111', '比对报告审批', '/secure/basemodule/qms/comparisons/page/audit-list?bpmn_statusCode=ReportAdiut', '7001', '700111', '', '比对报告审批'); INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME) VALUES ('700112', '比对及验证查询', '/secure/basemodule/qms/comparisons/page/search-list', '7001', '700112', '', '比对及验证查询'); INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT) VALUES ('T_LIMS_COMPARISON', '1', '0'); INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT) VALUES ('T_LIMS_COMPARISON_ITEM', '0', '0'); INSERT INTO T_CORE_TABLE_HIERARCHY (ID, TABLENAME, MASTERTABLENAME, REFERCOLUMN) VALUES ('70010801','T_LIMS_COMPARISON_ITEM', 'T_LIMS_COMPARISON', 'PLANID'); INSERT INTO T_CORE_MENU_EXT (ID, SERVICENAME, TABLENAME, TYPE, ENABLE) VALUES ('70010801', '比对及验证', 'T_LIMS_COMPARISON', 'audit_def', '1'); COMMIT; -- ----------------------------- 2022-10-11 add by qiuyf------------end