111 lines
8.1 KiB
Plaintext
111 lines
8.1 KiB
Plaintext
-- ----------------------------- 2022-09-29 add by qiuyf--------------begin
|
|
|
|
-- 建表语句
|
|
CREATE TABLE T_LIMS_COMPLAINT(
|
|
ID NUMBER NOT NULL,
|
|
COMPLAINTINITIATOR VARCHAR2(270) NULL,
|
|
COMPLAINTTIME DATE NULL,
|
|
CONTACT VARCHAR2(270) NULL,
|
|
DUTYORG VARCHAR2(270) NULL,
|
|
COMPLAINTCONTENT VARCHAR2(270) NULL,
|
|
DECIDE VARCHAR2(36) NULL,
|
|
SURVEYREASON VARCHAR2(270) NULL,
|
|
MEASURE VARCHAR2(270) NULL,
|
|
TRACE 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,
|
|
RESULTFLAG VARCHAR2(36) NULL,
|
|
RESULTCORRECT VARCHAR2(36) NULL,
|
|
DUTYORGID VARCHAR2(36) NULL
|
|
);
|
|
COMMENT ON TABLE T_LIMS_COMPLAINT IS '投诉管理';
|
|
COMMENT ON COLUMN T_LIMS_COMPLAINT.ID IS '主键';
|
|
COMMENT ON COLUMN T_LIMS_COMPLAINT.COMPLAINTINITIATOR IS '报检方名称';
|
|
COMMENT ON COLUMN T_LIMS_COMPLAINT.COMPLAINTTIME IS '投诉日期';
|
|
COMMENT ON COLUMN T_LIMS_COMPLAINT.CONTACT IS '联系方式';
|
|
COMMENT ON COLUMN T_LIMS_COMPLAINT.DUTYORG IS '责任部门';
|
|
COMMENT ON COLUMN T_LIMS_COMPLAINT.COMPLAINTCONTENT IS '投诉内容';
|
|
COMMENT ON COLUMN T_LIMS_COMPLAINT.DECIDE IS '投诉是否成立';
|
|
COMMENT ON COLUMN T_LIMS_COMPLAINT.SURVEYREASON IS '调查原因';
|
|
COMMENT ON COLUMN T_LIMS_COMPLAINT.MEASURE IS '采取措施';
|
|
COMMENT ON COLUMN T_LIMS_COMPLAINT.TRACE IS '结果追踪';
|
|
COMMENT ON COLUMN T_LIMS_COMPLAINT.PROCESSSTATUS IS '流程状态';
|
|
COMMENT ON COLUMN T_LIMS_COMPLAINT.CREATEDBYID IS '制单人编码';
|
|
COMMENT ON COLUMN T_LIMS_COMPLAINT.CREATEDBYNAME IS '制单人名称';
|
|
COMMENT ON COLUMN T_LIMS_COMPLAINT.CREATEDTIME IS '制单时间';
|
|
COMMENT ON COLUMN T_LIMS_COMPLAINT.CREATEDBYORGID IS '制单人单位编码';
|
|
COMMENT ON COLUMN T_LIMS_COMPLAINT.CREATEDBYORGNAME IS '制单人单位名称';
|
|
COMMENT ON COLUMN T_LIMS_COMPLAINT.ORGID IS '所属单位编码';
|
|
COMMENT ON COLUMN T_LIMS_COMPLAINT.ORGNAME IS '所属单位名称';
|
|
COMMENT ON COLUMN T_LIMS_COMPLAINT.RESULTFLAG IS '是否涉及结果';
|
|
COMMENT ON COLUMN T_LIMS_COMPLAINT.RESULTCORRECT IS '结果是否正确';
|
|
COMMENT ON COLUMN T_LIMS_COMPLAINT.DUTYORGID IS '责任部门编码';
|
|
|
|
ALTER TABLE T_LIMS_COMPLAINT ADD CONSTRAINT PK_LIMS_COMPLAINT PRIMARY KEY (ID);
|
|
|
|
CALL INSERTI18N('T_LIMS_COMPLAINT.SERVICE_NAME', '投诉管理', '投诉管理', 'zh-CN', '投诉管理');
|
|
CALL INSERTI18N('T_LIMS_COMPLAINT.ID', '投诉管理的主键', '主键', 'zh-CN', '主键');
|
|
CALL INSERTI18N('T_LIMS_COMPLAINT.COMPLAINTINITIATOR', '投诉管理的报检方名称', '报检方名称', 'zh-CN', '报检方名称');
|
|
CALL INSERTI18N('T_LIMS_COMPLAINT.COMPLAINTTIME', '投诉管理的投诉日期', '投诉日期', 'zh-CN', '投诉日期');
|
|
CALL INSERTI18N('T_LIMS_COMPLAINT.CONTACT', '投诉管理的联系方式', '联系方式', 'zh-CN', '联系方式');
|
|
CALL INSERTI18N('T_LIMS_COMPLAINT.DUTYORG', '投诉管理的责任部门', '责任部门', 'zh-CN', '责任部门');
|
|
CALL INSERTI18N('T_LIMS_COMPLAINT.COMPLAINTCONTENT', '投诉管理的投诉内容', '投诉内容', 'zh-CN', '投诉内容');
|
|
CALL INSERTI18N('T_LIMS_COMPLAINT.DECIDE', '投诉管理的投诉是否成立', '投诉是否成立', 'zh-CN', '投诉是否成立');
|
|
CALL INSERTI18N('T_LIMS_COMPLAINT.SURVEYREASON', '投诉管理的调查原因', '调查原因', 'zh-CN', '调查原因');
|
|
CALL INSERTI18N('T_LIMS_COMPLAINT.MEASURE', '投诉管理的采取措施', '采取措施', 'zh-CN', '采取措施');
|
|
CALL INSERTI18N('T_LIMS_COMPLAINT.TRACE', '投诉管理的结果追踪', '结果追踪', 'zh-CN', '结果追踪');
|
|
CALL INSERTI18N('T_LIMS_COMPLAINT.PROCESSSTATUS', '投诉管理的流程状态', '流程状态', 'zh-CN', '流程状态');
|
|
CALL INSERTI18N('T_LIMS_COMPLAINT.CREATEDBYID', '投诉管理的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
|
|
CALL INSERTI18N('T_LIMS_COMPLAINT.CREATEDBYNAME', '投诉管理的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
|
|
CALL INSERTI18N('T_LIMS_COMPLAINT.CREATEDTIME', '投诉管理的制单时间', '制单时间', 'zh-CN', '制单时间');
|
|
CALL INSERTI18N('T_LIMS_COMPLAINT.CREATEDBYORGID', '投诉管理的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
|
|
CALL INSERTI18N('T_LIMS_COMPLAINT.CREATEDBYORGNAME', '投诉管理的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
|
|
CALL INSERTI18N('T_LIMS_COMPLAINT.ORGID', '投诉管理的所属单位编码', '所属单位编码', 'zh-CN', '所属单位编码');
|
|
CALL INSERTI18N('T_LIMS_COMPLAINT.ORGNAME', '投诉管理的所属单位名称', '所属单位名称', 'zh-CN', '所属单位名称');
|
|
CALL INSERTI18N('T_LIMS_COMPLAINT.RESULTFLAG', '投诉管理的是否涉及结果', '是否涉及结果', 'zh-CN', '是否涉及结果');
|
|
CALL INSERTI18N('T_LIMS_COMPLAINT.RESULTCORRECT', '投诉管理的结果是否正确', '结果是否正确', 'zh-CN', '结果是否正确');
|
|
CALL INSERTI18N('T_LIMS_COMPLAINT.DUTYORGID', '投诉管理的责任部门编码', '责任部门编码', 'zh-CN', '责任部门编码');
|
|
CALL INSERTI18N('BASEMODULE.QMS.COMPLAINTS.MODAL.ADD', '新增', '新增', 'zh-CN', '新增');
|
|
CALL INSERTI18N('BASEMODULE.QMS.COMPLAINTS.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息');
|
|
CALL INSERTI18N('BASEMODULE.QMS.COMPLAINTS.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮');
|
|
CALL INSERTI18N('BASEMODULE.QMS.COMPLAINTS.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框');
|
|
CALL INSERTI18N('BASEMODULE.QMS.COMPLAINTS.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框');
|
|
|
|
-- 创建菜单语句
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('7008', '投诉管理', '', '70', '7008', '005.svg', '投诉管理');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('700801', '投诉受理', '/secure/basemodule/qms/complaints/page/edit-list', '7008', '700801', '', '投诉受理');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('700802', '初步审查', '/secure/basemodule/qms/complaints/page/audit-list?bpmn_statusCode=Audit', '7008', '700802', '', '初步审查');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('700803', '投诉处理', '/secure/basemodule/qms/complaints/page/audit-list?bpmn_statusCode=Handle', '7008', '700803', '', '投诉处理');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('700804', '采取措施', '/secure/basemodule/qms/complaints/page/audit-list?bpmn_statusCode=Measures', '7008', '700804', '', '采取措施');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('700805', '措施审核', '/secure/basemodule/qms/complaints/page/audit-list?bpmn_statusCode=MeasuresAudit', '7008', '700805', '', '措施审核');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('700806', '复检结果', '/secure/basemodule/qms/complaints/page/audit-list?bpmn_statusCode=Result', '7008', '700806', '', '复检结果');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('700807', '复检结果审核', '/secure/basemodule/qms/complaints/page/audit-list?bpmn_statusCode=ResultAudit', '7008', '700807', '', '复检结果审核');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('700808', '调查反馈', '/secure/basemodule/qms/complaints/page/audit-list?bpmn_statusCode=Feedback', '7008', '700808', '', '调查反馈');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('700809', '投诉管理查询', '/secure/basemodule/qms/complaints/page/search-list', '7008', '700809', '', '投诉管理查询');
|
|
|
|
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
|
|
VALUES ('T_LIMS_COMPLAINT', '1', '0');
|
|
|
|
INSERT INTO T_CORE_MENU_EXT (ID, SERVICENAME, TABLENAME, TYPE, ENABLE)
|
|
VALUES ('7008', '投诉管理', 'T_LIMS_COMPLAINT', 'audit_def', '1');
|
|
|
|
|
|
COMMIT;
|
|
|
|
-- ----------------------------- 2022-09-29 add by qiuyf------------end |