92 lines
6.3 KiB
Plaintext
92 lines
6.3 KiB
Plaintext
-- ----------------------------- 2022-09-29 add by qiuyf--------------begin
|
|
|
|
-- 建表语句
|
|
CREATE TABLE T_LIMS_UNCERTAIN(
|
|
ID NUMBER NOT NULL,
|
|
EVALUATEPROJECT VARCHAR2(270) NULL,
|
|
EVALUATOR VARCHAR2(270) NULL,
|
|
EVALUATORID VARCHAR2(36) NULL,
|
|
AUDITUSER VARCHAR2(270) NULL,
|
|
AUDITUSERID VARCHAR2(36) NULL,
|
|
APPROVEUSER VARCHAR2(270) NULL,
|
|
APPROVEUSERID VARCHAR2(36) NULL,
|
|
GOAL VARCHAR2(270) NULL,
|
|
EVALUATERESULT 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_UNCERTAIN IS '不确定度';
|
|
COMMENT ON COLUMN T_LIMS_UNCERTAIN.ID IS '主键';
|
|
COMMENT ON COLUMN T_LIMS_UNCERTAIN.EVALUATEPROJECT IS '评估项目';
|
|
COMMENT ON COLUMN T_LIMS_UNCERTAIN.EVALUATOR IS '评估人';
|
|
COMMENT ON COLUMN T_LIMS_UNCERTAIN.EVALUATORID IS '评估人ID';
|
|
COMMENT ON COLUMN T_LIMS_UNCERTAIN.AUDITUSER IS '审核人';
|
|
COMMENT ON COLUMN T_LIMS_UNCERTAIN.AUDITUSERID IS '审核人ID';
|
|
COMMENT ON COLUMN T_LIMS_UNCERTAIN.APPROVEUSER IS '批准人';
|
|
COMMENT ON COLUMN T_LIMS_UNCERTAIN.APPROVEUSERID IS '批准人ID';
|
|
COMMENT ON COLUMN T_LIMS_UNCERTAIN.GOAL IS '目的';
|
|
COMMENT ON COLUMN T_LIMS_UNCERTAIN.EVALUATERESULT IS '不确定度评估';
|
|
COMMENT ON COLUMN T_LIMS_UNCERTAIN.PROCESSSTATUS IS '流程状态';
|
|
COMMENT ON COLUMN T_LIMS_UNCERTAIN.CREATEDBYID IS '制单人编码';
|
|
COMMENT ON COLUMN T_LIMS_UNCERTAIN.CREATEDBYNAME IS '制单人名称';
|
|
COMMENT ON COLUMN T_LIMS_UNCERTAIN.CREATEDTIME IS '制单时间';
|
|
COMMENT ON COLUMN T_LIMS_UNCERTAIN.CREATEDBYORGID IS '制单人单位编码';
|
|
COMMENT ON COLUMN T_LIMS_UNCERTAIN.CREATEDBYORGNAME IS '制单人单位名称';
|
|
COMMENT ON COLUMN T_LIMS_UNCERTAIN.ORGID IS '所属单位编码';
|
|
COMMENT ON COLUMN T_LIMS_UNCERTAIN.ORGNAME IS '所属单位名称';
|
|
|
|
ALTER TABLE T_LIMS_UNCERTAIN ADD CONSTRAINT PK_LIMS_UNCERTAIN PRIMARY KEY (ID);
|
|
|
|
CALL INSERTI18N('T_LIMS_UNCERTAIN.SERVICE_NAME', '不确定度', '不确定度', 'zh-CN', '不确定度');
|
|
CALL INSERTI18N('T_LIMS_UNCERTAIN.ID', '不确定度的主键', '主键', 'zh-CN', '主键');
|
|
CALL INSERTI18N('T_LIMS_UNCERTAIN.EVALUATEPROJECT', '不确定度的评估项目', '评估项目', 'zh-CN', '评估项目');
|
|
CALL INSERTI18N('T_LIMS_UNCERTAIN.EVALUATOR', '不确定度的评估人', '评估人', 'zh-CN', '评估人');
|
|
CALL INSERTI18N('T_LIMS_UNCERTAIN.EVALUATORID', '不确定度的评估人ID', '评估人ID', 'zh-CN', '评估人ID');
|
|
CALL INSERTI18N('T_LIMS_UNCERTAIN.AUDITUSER', '不确定度的审核人', '审核人', 'zh-CN', '审核人');
|
|
CALL INSERTI18N('T_LIMS_UNCERTAIN.AUDITUSERID', '不确定度的审核人ID', '审核人ID', 'zh-CN', '审核人ID');
|
|
CALL INSERTI18N('T_LIMS_UNCERTAIN.APPROVEUSER', '不确定度的批准人', '批准人', 'zh-CN', '批准人');
|
|
CALL INSERTI18N('T_LIMS_UNCERTAIN.APPROVEUSERID', '不确定度的批准人ID', '批准人ID', 'zh-CN', '批准人ID');
|
|
CALL INSERTI18N('T_LIMS_UNCERTAIN.GOAL', '不确定度的目的', '目的', 'zh-CN', '目的');
|
|
CALL INSERTI18N('T_LIMS_UNCERTAIN.EVALUATERESULT', '不确定度的不确定度评估', '不确定度评估', 'zh-CN', '不确定度评估');
|
|
CALL INSERTI18N('T_LIMS_UNCERTAIN.PROCESSSTATUS', '不确定度的流程状态', '流程状态', 'zh-CN', '流程状态');
|
|
CALL INSERTI18N('T_LIMS_UNCERTAIN.CREATEDBYID', '不确定度的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
|
|
CALL INSERTI18N('T_LIMS_UNCERTAIN.CREATEDBYNAME', '不确定度的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
|
|
CALL INSERTI18N('T_LIMS_UNCERTAIN.CREATEDTIME', '不确定度的制单时间', '制单时间', 'zh-CN', '制单时间');
|
|
CALL INSERTI18N('T_LIMS_UNCERTAIN.CREATEDBYORGID', '不确定度的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
|
|
CALL INSERTI18N('T_LIMS_UNCERTAIN.CREATEDBYORGNAME', '不确定度的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
|
|
CALL INSERTI18N('T_LIMS_UNCERTAIN.ORGID', '不确定度的所属单位编码', '所属单位编码', 'zh-CN', '所属单位编码');
|
|
CALL INSERTI18N('T_LIMS_UNCERTAIN.ORGNAME', '不确定度的所属单位名称', '所属单位名称', 'zh-CN', '所属单位名称');
|
|
CALL INSERTI18N('BASEMODULE.QMS.UNCERTAINS.MODAL.ADD', '新增', '新增', 'zh-CN', '新增');
|
|
CALL INSERTI18N('BASEMODULE.QMS.UNCERTAINS.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息');
|
|
CALL INSERTI18N('BASEMODULE.QMS.UNCERTAINS.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮');
|
|
CALL INSERTI18N('BASEMODULE.QMS.UNCERTAINS.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框');
|
|
CALL INSERTI18N('BASEMODULE.QMS.UNCERTAINS.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框');
|
|
|
|
-- 创建菜单语句
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('7006', '不确定度管理', '/secure/basemodule/qms/uncertains/page/edit-list', '70', '7006', '005.svg', '不确定度管理');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('700601', '不确定度报告评估', '/secure/basemodule/qms/uncertains/page/edit-list', '7006', '700601', '', '不确定度报告评估');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('700602', '不确定度报告审核', '/secure/basemodule/qms/uncertains/page/audit-list?bpmn_statusCode=Audit', '7006', '700602', '', '不确定度报告审核');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('700603', '不确定度报告批准', '/secure/basemodule/qms/uncertains/page/audit-list?bpmn_statusCode=Approve', '7006', '700603', '', '不确定度报告批准');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('700604', '不确定度管理查询', '/secure/basemodule/qms/uncertains/page/search-list', '7006', '700604', '', '不确定度管理查询');
|
|
|
|
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
|
|
VALUES ('T_LIMS_UNCERTAIN', '1', '0');
|
|
|
|
INSERT INTO T_CORE_MENU_EXT (ID, SERVICENAME, TABLENAME, TYPE, ENABLE)
|
|
VALUES ('7006', '不确定度管理', 'T_LIMS_UNCERTAIN', 'audit_def', '1');
|
|
|
|
|
|
COMMIT;
|
|
|
|
-- ----------------------------- 2022-09-29 add by qiuyf------------end |