163 lines
12 KiB
Plaintext
163 lines
12 KiB
Plaintext
|
|
-- ----------------------------- 2022-09-21 add by qiuyf--------------begin
|
|
|
|
-- 建表语句
|
|
CREATE TABLE T_LIMS_FAIR_PLAN(
|
|
ID NUMBER NOT NULL,
|
|
CHECKTIME DATE NULL,
|
|
CHECKORG VARCHAR2(270) NULL,
|
|
CHECKORGID VARCHAR2(36) NULL,
|
|
REMINDTIME DATE NULL,
|
|
SUPERVISOR VARCHAR2(270) NULL,
|
|
SUPERVISORID 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_FAIR_PLAN IS '公正性计划';
|
|
COMMENT ON COLUMN T_LIMS_FAIR_PLAN.ID IS '主键';
|
|
COMMENT ON COLUMN T_LIMS_FAIR_PLAN.CHECKTIME IS '计划检查日期';
|
|
COMMENT ON COLUMN T_LIMS_FAIR_PLAN.CHECKORG IS '计划检查部门';
|
|
COMMENT ON COLUMN T_LIMS_FAIR_PLAN.CHECKORGID IS '计划检查部门ID';
|
|
COMMENT ON COLUMN T_LIMS_FAIR_PLAN.REMINDTIME IS '提醒日期';
|
|
COMMENT ON COLUMN T_LIMS_FAIR_PLAN.SUPERVISOR IS '监督员';
|
|
COMMENT ON COLUMN T_LIMS_FAIR_PLAN.SUPERVISORID IS '监督员ID';
|
|
COMMENT ON COLUMN T_LIMS_FAIR_PLAN.PROCESSSTATUS IS '流程状态';
|
|
COMMENT ON COLUMN T_LIMS_FAIR_PLAN.CREATEDBYID IS '制单人编码';
|
|
COMMENT ON COLUMN T_LIMS_FAIR_PLAN.CREATEDBYNAME IS '制单人名称';
|
|
COMMENT ON COLUMN T_LIMS_FAIR_PLAN.CREATEDTIME IS '制单时间';
|
|
COMMENT ON COLUMN T_LIMS_FAIR_PLAN.CREATEDBYORGID IS '制单人单位编码';
|
|
COMMENT ON COLUMN T_LIMS_FAIR_PLAN.CREATEDBYORGNAME IS '制单人单位名称';
|
|
COMMENT ON COLUMN T_LIMS_FAIR_PLAN.ORGID IS '所属单位编码';
|
|
COMMENT ON COLUMN T_LIMS_FAIR_PLAN.ORGNAME IS '所属单位名称';
|
|
|
|
ALTER TABLE T_LIMS_FAIR_PLAN ADD CONSTRAINT PK_LIMS_FAIR_PLAN PRIMARY KEY (ID);
|
|
|
|
CREATE TABLE T_LIMS_FAIR_RECORD(
|
|
ID NUMBER NOT NULL,
|
|
PLANID NUMBER NULL,
|
|
CHECKTIME DATE NULL,
|
|
CHECKORG VARCHAR2(270) NULL,
|
|
CHECKORGID VARCHAR2(36) NULL,
|
|
CHECKCONTENT VARCHAR2(270) NULL,
|
|
CHECKRESULT VARCHAR2(270) NULL,
|
|
CHECKPROBLEM VARCHAR2(270) NULL,
|
|
SUPERVISOR VARCHAR2(270) NULL,
|
|
SUPERVISORID 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_FAIR_RECORD IS '公正性实施记录';
|
|
COMMENT ON COLUMN T_LIMS_FAIR_RECORD.ID IS '主键';
|
|
COMMENT ON COLUMN T_LIMS_FAIR_RECORD.PLANID IS '计划ID';
|
|
COMMENT ON COLUMN T_LIMS_FAIR_RECORD.CHECKTIME IS '检查日期';
|
|
COMMENT ON COLUMN T_LIMS_FAIR_RECORD.CHECKORG IS '检查部门';
|
|
COMMENT ON COLUMN T_LIMS_FAIR_RECORD.CHECKORGID IS '检查部门ID';
|
|
COMMENT ON COLUMN T_LIMS_FAIR_RECORD.CHECKCONTENT IS '检查内容';
|
|
COMMENT ON COLUMN T_LIMS_FAIR_RECORD.CHECKRESULT IS '检查结果';
|
|
COMMENT ON COLUMN T_LIMS_FAIR_RECORD.CHECKPROBLEM IS '检查问题';
|
|
COMMENT ON COLUMN T_LIMS_FAIR_RECORD.SUPERVISOR IS '监督员';
|
|
COMMENT ON COLUMN T_LIMS_FAIR_RECORD.SUPERVISORID IS '监督员ID';
|
|
COMMENT ON COLUMN T_LIMS_FAIR_RECORD.PROCESSSTATUS IS '流程状态';
|
|
COMMENT ON COLUMN T_LIMS_FAIR_RECORD.CREATEDBYID IS '制单人编码';
|
|
COMMENT ON COLUMN T_LIMS_FAIR_RECORD.CREATEDBYNAME IS '制单人名称';
|
|
COMMENT ON COLUMN T_LIMS_FAIR_RECORD.CREATEDTIME IS '制单时间';
|
|
COMMENT ON COLUMN T_LIMS_FAIR_RECORD.CREATEDBYORGID IS '制单人单位编码';
|
|
COMMENT ON COLUMN T_LIMS_FAIR_RECORD.CREATEDBYORGNAME IS '制单人单位名称';
|
|
COMMENT ON COLUMN T_LIMS_FAIR_RECORD.ORGID IS '所属单位编码';
|
|
COMMENT ON COLUMN T_LIMS_FAIR_RECORD.ORGNAME IS '所属单位名称';
|
|
|
|
ALTER TABLE T_LIMS_FAIR_RECORD ADD CONSTRAINT PK_LIMS_FAIR_RECORD PRIMARY KEY (ID);
|
|
CREATE INDEX IDX_LIMS_FAIR_RECORD_PLANID ON T_LIMS_FAIR_RECORD (PLANID);
|
|
|
|
CALL INSERTI18N('T_LIMS_FAIR_PLAN.SERVICE_NAME', '公正性计划', '公正性计划', 'zh-CN', '公正性计划');
|
|
CALL INSERTI18N('T_LIMS_FAIR_PLAN.ID', '公正性计划的主键', '主键', 'zh-CN', '主键');
|
|
CALL INSERTI18N('T_LIMS_FAIR_PLAN.CHECKTIME', '公正性计划的计划检查日期', '计划检查日期', 'zh-CN', '计划检查日期');
|
|
CALL INSERTI18N('T_LIMS_FAIR_PLAN.CHECKORG', '公正性计划的计划检查部门', '计划检查部门', 'zh-CN', '计划检查部门');
|
|
CALL INSERTI18N('T_LIMS_FAIR_PLAN.CHECKORGID', '公正性计划的计划检查部门ID', '计划检查部门ID', 'zh-CN', '计划检查部门ID');
|
|
CALL INSERTI18N('T_LIMS_FAIR_PLAN.REMINDTIME', '公正性计划的提醒日期', '提醒日期', 'zh-CN', '提醒日期');
|
|
CALL INSERTI18N('T_LIMS_FAIR_PLAN.SUPERVISOR', '公正性计划的监督员', '监督员', 'zh-CN', '监督员');
|
|
CALL INSERTI18N('T_LIMS_FAIR_PLAN.SUPERVISORID', '公正性计划的监督员ID', '监督员ID', 'zh-CN', '监督员ID');
|
|
CALL INSERTI18N('T_LIMS_FAIR_PLAN.PROCESSSTATUS', '公正性计划的流程状态', '流程状态', 'zh-CN', '流程状态');
|
|
CALL INSERTI18N('T_LIMS_FAIR_PLAN.CREATEDBYID', '公正性计划的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
|
|
CALL INSERTI18N('T_LIMS_FAIR_PLAN.CREATEDBYNAME', '公正性计划的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
|
|
CALL INSERTI18N('T_LIMS_FAIR_PLAN.CREATEDTIME', '公正性计划的制单时间', '制单时间', 'zh-CN', '制单时间');
|
|
CALL INSERTI18N('T_LIMS_FAIR_PLAN.CREATEDBYORGID', '公正性计划的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
|
|
CALL INSERTI18N('T_LIMS_FAIR_PLAN.CREATEDBYORGNAME', '公正性计划的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
|
|
CALL INSERTI18N('T_LIMS_FAIR_PLAN.ORGID', '公正性计划的所属单位编码', '所属单位编码', 'zh-CN', '所属单位编码');
|
|
CALL INSERTI18N('T_LIMS_FAIR_PLAN.ORGNAME', '公正性计划的所属单位名称', '所属单位名称', 'zh-CN', '所属单位名称');
|
|
CALL INSERTI18N('T_LIMS_FAIR_RECORD.SERVICE_NAME', '公正性实施记录', '公正性实施记录', 'zh-CN', '公正性实施记录');
|
|
CALL INSERTI18N('T_LIMS_FAIR_RECORD.ID', '公正性实施记录的主键', '主键', 'zh-CN', '主键');
|
|
CALL INSERTI18N('T_LIMS_FAIR_RECORD.PLANID', '公正性实施记录的计划ID', '计划ID', 'zh-CN', '计划ID');
|
|
CALL INSERTI18N('T_LIMS_FAIR_RECORD.CHECKTIME', '公正性实施记录的检查日期', '检查日期', 'zh-CN', '检查日期');
|
|
CALL INSERTI18N('T_LIMS_FAIR_RECORD.CHECKORG', '公正性实施记录的检查部门', '检查部门', 'zh-CN', '检查部门');
|
|
CALL INSERTI18N('T_LIMS_FAIR_RECORD.CHECKORGID', '公正性实施记录的检查部门ID', '检查部门ID', 'zh-CN', '检查部门ID');
|
|
CALL INSERTI18N('T_LIMS_FAIR_RECORD.CHECKCONTENT', '公正性实施记录的检查内容', '检查内容', 'zh-CN', '检查内容');
|
|
CALL INSERTI18N('T_LIMS_FAIR_RECORD.CHECKRESULT', '公正性实施记录的检查结果', '检查结果', 'zh-CN', '检查结果');
|
|
CALL INSERTI18N('T_LIMS_FAIR_RECORD.CHECKPROBLEM', '公正性实施记录的检查问题', '检查问题', 'zh-CN', '检查问题');
|
|
CALL INSERTI18N('T_LIMS_FAIR_RECORD.SUPERVISOR', '公正性实施记录的监督员', '监督员', 'zh-CN', '监督员');
|
|
CALL INSERTI18N('T_LIMS_FAIR_RECORD.SUPERVISORID', '公正性实施记录的监督员ID', '监督员ID', 'zh-CN', '监督员ID');
|
|
CALL INSERTI18N('T_LIMS_FAIR_RECORD.PROCESSSTATUS', '公正性实施记录的流程状态', '流程状态', 'zh-CN', '流程状态');
|
|
CALL INSERTI18N('T_LIMS_FAIR_RECORD.CREATEDBYID', '公正性实施记录的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
|
|
CALL INSERTI18N('T_LIMS_FAIR_RECORD.CREATEDBYNAME', '公正性实施记录的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
|
|
CALL INSERTI18N('T_LIMS_FAIR_RECORD.CREATEDTIME', '公正性实施记录的制单时间', '制单时间', 'zh-CN', '制单时间');
|
|
CALL INSERTI18N('T_LIMS_FAIR_RECORD.CREATEDBYORGID', '公正性实施记录的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
|
|
CALL INSERTI18N('T_LIMS_FAIR_RECORD.CREATEDBYORGNAME', '公正性实施记录的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
|
|
CALL INSERTI18N('T_LIMS_FAIR_RECORD.ORGID', '公正性实施记录的所属单位编码', '所属单位编码', 'zh-CN', '所属单位编码');
|
|
CALL INSERTI18N('T_LIMS_FAIR_RECORD.ORGNAME', '公正性实施记录的所属单位名称', '所属单位名称', 'zh-CN', '所属单位名称');
|
|
CALL INSERTI18N('BASEMODULE.QMS.FAIRS.MODAL.ADD', '新增', '新增', 'zh-CN', '新增');
|
|
CALL INSERTI18N('BASEMODULE.QMS.FAIRS.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息');
|
|
CALL INSERTI18N('BASEMODULE.QMS.FAIRS.TAB.RECORD', '公正性实施记录', '公正性实施记录', 'zh-CN', '公正性实施记录');
|
|
CALL INSERTI18N('BASEMODULE.QMS.FAIRS.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮');
|
|
CALL INSERTI18N('BASEMODULE.QMS.FAIRS.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框');
|
|
CALL INSERTI18N('BASEMODULE.QMS.FAIRS.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框');
|
|
|
|
-- 创建菜单语句
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('7011', '公正性管理', '', '70', '7011', '025.svg', '公正性管理');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('701101', '公正性计划编制', '/secure/basemodule/qms/fair-plans/page/edit-list', '7011', '701101', '', '公正性计划编制');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('701102', '公正性计划审核', '/secure/basemodule/qms/fair-plans/page/audit-list?bpmn_statusCode=Audit', '7011', '701102', '', '公正性计划审核');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('701103', '公正性计划批准', '/secure/basemodule/qms/fair-plans/page/audit-list?bpmn_statusCode=Approve', '7011', '701103', '', '公正性计划批准');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('701104', '公正性检查记录', '/secure/basemodule/qms/fair-plans/page/record/edit-list', '7011', '701104', '', '公正性检查记录');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('701105', '公正性检查记录审核', '/secure/basemodule/qms/fair-plans/page/record/audit-list?bpmn_statusCode=Audit', '7011', '701105', '', '公正性检查记录审核');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('701106', '公正性检查记录批准', '/secure/basemodule/qms/fair-plans/page/record/audit-list?bpmn_statusCode=Approve', '7011', '701106', '', '公正性检查记录批准');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('701107', '公正性管理查询', '/secure/basemodule/qms/fair-plans/page/search-list', '7011', '701107', '', '公正性管理查询');
|
|
|
|
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
|
|
VALUES ('T_LIMS_FAIR_PLAN', '1', '0');
|
|
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
|
|
VALUES ('T_LIMS_FAIR_RECORD', '1', '0');
|
|
|
|
INSERT INTO T_CORE_TABLE_HIERARCHY (ID, TABLENAME, MASTERTABLENAME, REFERCOLUMN)
|
|
VALUES ('701101','T_LIMS_FAIR_RECORD', 'T_LIMS_FAIR_PLAN', 'PLANID');
|
|
|
|
INSERT INTO T_CORE_MENU_EXT (ID, SERVICENAME, TABLENAME, TYPE, ENABLE)
|
|
VALUES ('701101', '公正性计划', 'T_LIMS_FAIR_PLAN', 'audit_def', '1');
|
|
INSERT INTO T_CORE_MENU_EXT (ID, SERVICENAME, TABLENAME, TYPE, ENABLE)
|
|
VALUES ('701102', '公正性检查记录', 'T_LIMS_FAIR_RECORD', 'audit_def', '1');
|
|
|
|
CALL INSERTI18N('BASEMODULE.QMS.FAIRS.NOT_RECORD', '公正性实施记录未添加，不允许提交', '公正性实施记录未添加，不允许提交', 'zh-CN', '公正性实施记录未添加，不允许提交');
|
|
|
|
ALTER TABLE T_LIMS_FAIR_RECORD ADD STATUS VARCHAR2(36);
|
|
|
|
COMMIT;
|
|
|
|
-- ----------------------------- 2022-09-21 add by qiuyf------------end |