113 lines
8.7 KiB
Plaintext
113 lines
8.7 KiB
Plaintext
-- ----------------------------- 2022-09-26 add by qiuyf--------------begin
|
|
|
|
-- 建表语句
|
|
CREATE TABLE T_LIMS_IMPROVE(
|
|
ID NUMBER NOT NULL,
|
|
IMPROVETYPE VARCHAR2(270) NULL,
|
|
IMPROVEPROJECT VARCHAR2(270) NULL,
|
|
SITUATION VARCHAR2(270) NULL,
|
|
FEASIBILITY VARCHAR2(270) NULL,
|
|
IMPROVEGOAL VARCHAR2(270) NULL,
|
|
IMPROVETARGET VARCHAR2(270) NULL,
|
|
IMPROVECONTENT VARCHAR2(270) NULL,
|
|
IMPROVESCHEME VARCHAR2(270) NULL,
|
|
PREDICTFINISHTIME DATE NULL,
|
|
DUTYORG VARCHAR2(270) NULL,
|
|
DUTYORGID VARCHAR2(36) NULL,
|
|
PRINCIPAL VARCHAR2(270) NULL,
|
|
PRINCIPALID VARCHAR2(36) NULL,
|
|
PROCESSSTATUS VARCHAR2(36) NULL,
|
|
ORGID VARCHAR2(36) NULL,
|
|
ORGNAME VARCHAR2(270) NULL,
|
|
CREATEDBYID VARCHAR2(36) NULL,
|
|
CREATEDBYNAME VARCHAR2(60) NULL,
|
|
CREATEDTIME DATE NULL,
|
|
CREATEDBYORGID VARCHAR2(36) NULL,
|
|
CREATEDBYORGNAME VARCHAR2(270) NULL
|
|
);
|
|
COMMENT ON TABLE T_LIMS_IMPROVE IS '改进表';
|
|
COMMENT ON COLUMN T_LIMS_IMPROVE.ID IS '主键';
|
|
COMMENT ON COLUMN T_LIMS_IMPROVE.IMPROVETYPE IS '持续改进类别';
|
|
COMMENT ON COLUMN T_LIMS_IMPROVE.IMPROVEPROJECT IS '确定的改进项目';
|
|
COMMENT ON COLUMN T_LIMS_IMPROVE.SITUATION IS '申请项目的现状描述';
|
|
COMMENT ON COLUMN T_LIMS_IMPROVE.FEASIBILITY IS '申请项目的可行性分析';
|
|
COMMENT ON COLUMN T_LIMS_IMPROVE.IMPROVEGOAL IS '改进的目的说明';
|
|
COMMENT ON COLUMN T_LIMS_IMPROVE.IMPROVETARGET IS '改进期望达到的目标';
|
|
COMMENT ON COLUMN T_LIMS_IMPROVE.IMPROVECONTENT IS '改进要落实问题和内容';
|
|
COMMENT ON COLUMN T_LIMS_IMPROVE.IMPROVESCHEME IS '使用持续改进方案';
|
|
COMMENT ON COLUMN T_LIMS_IMPROVE.PREDICTFINISHTIME IS '预计完成日期';
|
|
COMMENT ON COLUMN T_LIMS_IMPROVE.DUTYORG IS '责任部门';
|
|
COMMENT ON COLUMN T_LIMS_IMPROVE.DUTYORGID IS '责任部门ID';
|
|
COMMENT ON COLUMN T_LIMS_IMPROVE.PRINCIPAL IS '责任人';
|
|
COMMENT ON COLUMN T_LIMS_IMPROVE.PRINCIPALID IS '责任人ID';
|
|
COMMENT ON COLUMN T_LIMS_IMPROVE.PROCESSSTATUS IS '流程状态';
|
|
COMMENT ON COLUMN T_LIMS_IMPROVE.ORGID IS '所属单位编码';
|
|
COMMENT ON COLUMN T_LIMS_IMPROVE.ORGNAME IS '所属单位名称';
|
|
COMMENT ON COLUMN T_LIMS_IMPROVE.CREATEDBYID IS '制单人编码';
|
|
COMMENT ON COLUMN T_LIMS_IMPROVE.CREATEDBYNAME IS '制单人名称';
|
|
COMMENT ON COLUMN T_LIMS_IMPROVE.CREATEDTIME IS '制单时间';
|
|
COMMENT ON COLUMN T_LIMS_IMPROVE.CREATEDBYORGID IS '制单人单位编码';
|
|
COMMENT ON COLUMN T_LIMS_IMPROVE.CREATEDBYORGNAME IS '制单人单位名称';
|
|
|
|
ALTER TABLE T_LIMS_IMPROVE ADD CONSTRAINT PK_LIMS_IMPROVE PRIMARY KEY (ID);
|
|
|
|
CALL INSERTI18N('T_LIMS_IMPROVE.SERVICE_NAME', '改进表', '改进表', 'zh-CN', '改进表');
|
|
CALL INSERTI18N('T_LIMS_IMPROVE.ID', '改进表的主键', '主键', 'zh-CN', '主键');
|
|
CALL INSERTI18N('T_LIMS_IMPROVE.IMPROVETYPE', '改进表的持续改进类别', '持续改进类别', 'zh-CN', '持续改进类别');
|
|
CALL INSERTI18N('T_LIMS_IMPROVE.IMPROVEPROJECT', '改进表的确定的改进项目', '确定的改进项目', 'zh-CN', '确定的改进项目');
|
|
CALL INSERTI18N('T_LIMS_IMPROVE.SITUATION', '改进表的申请项目的现状描述', '申请项目的现状描述', 'zh-CN', '申请项目的现状描述');
|
|
CALL INSERTI18N('T_LIMS_IMPROVE.FEASIBILITY', '改进表的申请项目的可行性分析', '申请项目的可行性分析', 'zh-CN', '申请项目的可行性分析');
|
|
CALL INSERTI18N('T_LIMS_IMPROVE.IMPROVEGOAL', '改进表的改进的目的说明', '改进的目的说明', 'zh-CN', '改进的目的说明');
|
|
CALL INSERTI18N('T_LIMS_IMPROVE.IMPROVETARGET', '改进表的改进期望达到的目标', '改进期望达到的目标', 'zh-CN', '改进期望达到的目标');
|
|
CALL INSERTI18N('T_LIMS_IMPROVE.IMPROVECONTENT', '改进表的改进要落实问题和内容', '改进要落实问题和内容', 'zh-CN', '改进要落实问题和内容');
|
|
CALL INSERTI18N('T_LIMS_IMPROVE.IMPROVESCHEME', '改进表的使用持续改进方案', '使用持续改进方案', 'zh-CN', '使用持续改进方案');
|
|
CALL INSERTI18N('T_LIMS_IMPROVE.PREDICTFINISHTIME', '改进表的预计完成日期', '预计完成日期', 'zh-CN', '预计完成日期');
|
|
CALL INSERTI18N('T_LIMS_IMPROVE.DUTYORG', '改进表的责任部门', '责任部门', 'zh-CN', '责任部门');
|
|
CALL INSERTI18N('T_LIMS_IMPROVE.DUTYORGID', '改进表的责任部门ID', '责任部门ID', 'zh-CN', '责任部门ID');
|
|
CALL INSERTI18N('T_LIMS_IMPROVE.PRINCIPAL', '改进表的责任人', '责任人', 'zh-CN', '责任人');
|
|
CALL INSERTI18N('T_LIMS_IMPROVE.PRINCIPALID', '改进表的责任人ID', '责任人ID', 'zh-CN', '责任人ID');
|
|
CALL INSERTI18N('T_LIMS_IMPROVE.PROCESSSTATUS', '改进表的流程状态', '流程状态', 'zh-CN', '流程状态');
|
|
CALL INSERTI18N('T_LIMS_IMPROVE.ORGID', '改进表的所属单位编码', '所属单位编码', 'zh-CN', '所属单位编码');
|
|
CALL INSERTI18N('T_LIMS_IMPROVE.ORGNAME', '改进表的所属单位名称', '所属单位名称', 'zh-CN', '所属单位名称');
|
|
CALL INSERTI18N('T_LIMS_IMPROVE.CREATEDBYID', '改进表的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
|
|
CALL INSERTI18N('T_LIMS_IMPROVE.CREATEDBYNAME', '改进表的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
|
|
CALL INSERTI18N('T_LIMS_IMPROVE.CREATEDTIME', '改进表的制单时间', '制单时间', 'zh-CN', '制单时间');
|
|
CALL INSERTI18N('T_LIMS_IMPROVE.CREATEDBYORGID', '改进表的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
|
|
CALL INSERTI18N('T_LIMS_IMPROVE.CREATEDBYORGNAME', '改进表的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
|
|
CALL INSERTI18N('BASEMODULE.QMS.IMPROVES.MODAL.ADD', '新增', '新增', 'zh-CN', '新增');
|
|
CALL INSERTI18N('BASEMODULE.QMS.IMPROVES.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息');
|
|
CALL INSERTI18N('BASEMODULE.QMS.IMPROVES.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮');
|
|
CALL INSERTI18N('BASEMODULE.QMS.IMPROVES.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框');
|
|
CALL INSERTI18N('BASEMODULE.QMS.IMPROVES.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框');
|
|
|
|
|
|
-- 创建菜单语句
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('7017', '改进管理', '', '70', '7017', '006.svg', '改进管理');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('701701', '改进机会识别', '/secure/basemodule/qms/improves/page/edit-list', '7017', '701701', '', '改进机会识别');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('701702', '改进方案制定', '/secure/basemodule/qms/improves/page/audit-list?bpmn_statusCode=Formulate', '7017', '701702', '', '改进方案制定');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('701703', '改进方案批准', '/secure/basemodule/qms/improves/page/audit-list?bpmn_statusCode=Approve', '7017', '701703', '', '改进方案批准');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('701704', '改进措施落实', '/secure/basemodule/qms/improves/page/audit-list?bpmn_statusCode=Implement', '7017', '701704', '', '改进措施落实');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('701705', '改进措施评估', '/secure/basemodule/qms/improves/page/audit-list?bpmn_statusCode=Assessment', '7017', '701705', '', '改进措施评估');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('701706', '改进管理查询', '/secure/basemodule/qms/improves/page/search-list', '7017', '701706', '', '改进管理查询');
|
|
|
|
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
|
|
VALUES ('T_LIMS_IMPROVE', '1', '0');
|
|
|
|
INSERT INTO T_CORE_MENU_EXT (ID, SERVICENAME, TABLENAME, TYPE, ENABLE)
|
|
VALUES ('7017', '改进管理', 'T_LIMS_IMPROVE', 'audit_def', '1');
|
|
|
|
INSERT INTO T_CORE_CODE_CATEGORY (ID,CODECATEGORYNAME,CODECLASSID,REMARK,ORDERNO,VERSION,CREATEDBYID,CREATEDBYNAME,CREATEDTIME) VALUES ('improveType','持续改进类别','biz',NULL,100,NULL,NULL,NULL,NULL);
|
|
INSERT INTO T_CORE_CODE (ID,CODENAME,CODECATEGORYID,REMARK,ORDERNO,VERSION,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,LASTSUSPENDEDFLAG,LASTSUSPENDEDBYID,LASTSUSPENDEDBYNAME,LASTSUSPENDEDTIME,CODE) VALUES (2022092601,'同一部门','improveType',NULL,1,0,'admin','系统管理员',NULL,'0',NULL,NULL,NULL,'sameOrg');
|
|
INSERT INTO T_CORE_CODE (ID,CODENAME,CODECATEGORYID,REMARK,ORDERNO,VERSION,CREATEDBYID,CREATEDBYNAME,CREATEDTIME,LASTSUSPENDEDFLAG,LASTSUSPENDEDBYID,LASTSUSPENDEDBYNAME,LASTSUSPENDEDTIME,CODE) VALUES (2022092602,'不同部门','improveType',NULL,2,0,'admin','系统管理员',NULL,'0',NULL,NULL,NULL,'diffOrg');
|
|
|
|
|
|
COMMIT;
|
|
|
|
-- ----------------------------- 2022-09-26 add by qiuyf------------end |