598 lines
43 KiB
Plaintext
598 lines
43 KiB
Plaintext
-- ----------------------------- 2022-09-09 add by qiuyf--------------begin
|
|
INSERT INTO T_CORE_MENU (ID,MENUNAME,HREF,PARENTID,ORDERNO,MENUINITNAME,LASTUPDATEDBYID,LASTUPDATEDBYNAME,LASTUPDATEDTIME,ICON,TODOICON,I18NCODE) VALUES ('7002','内部审核管理',NULL,'70',7002,'内部审核管理',NULL,NULL,NULL,'005.svg',NULL,NULL);
|
|
INSERT INTO T_CORE_MENU (ID,MENUNAME,HREF,PARENTID,ORDERNO,MENUINITNAME,LASTUPDATEDBYID,LASTUPDATEDBYNAME,LASTUPDATEDTIME,ICON,TODOICON,I18NCODE) VALUES ('700201','内审核查内容','/secure/basemodule/qms/internalaudits/page/factor/edit-list','7002',1,'内审核查内容',NULL,NULL,NULL,'028.svg',NULL,NULL);
|
|
INSERT INTO T_CORE_MENU (ID,MENUNAME,HREF,PARENTID,ORDERNO,MENUINITNAME,LASTUPDATEDBYID,LASTUPDATEDBYNAME,LASTUPDATEDTIME,ICON,TODOICON,I18NCODE) VALUES ('700202','年度内审计划编制','/secure/basemodule/qms/internalaudits/page/edit-list','7002',2,'年度内审计划编制',NULL,NULL,NULL,'026.svg',NULL,NULL);
|
|
INSERT INTO T_CORE_MENU (ID,MENUNAME,HREF,PARENTID,ORDERNO,MENUINITNAME,LASTUPDATEDBYID,LASTUPDATEDBYNAME,LASTUPDATEDTIME,ICON,TODOICON,I18NCODE) VALUES ('700203','年度内审计划审批','/secure/basemodule/qms/internalaudits/page/audit-list','7002',3,'年度内审计划审批',NULL,NULL,NULL,'008.svg',NULL,NULL);
|
|
INSERT INTO T_CORE_MENU (ID,MENUNAME,HREF,PARENTID,ORDERNO,MENUINITNAME,LASTUPDATEDBYID,LASTUPDATEDBYNAME,LASTUPDATEDTIME,ICON,TODOICON,I18NCODE) VALUES ('700204','成立审核组','/secure/basemodule/qms/internalaudits/page/month/edit-list','7002',4,'成立审核组',NULL,NULL,NULL,'010.svg',NULL,NULL);
|
|
INSERT INTO T_CORE_MENU (ID,MENUNAME,HREF,PARENTID,ORDERNO,MENUINITNAME,LASTUPDATEDBYID,LASTUPDATEDBYNAME,LASTUPDATEDTIME,ICON,TODOICON,I18NCODE) VALUES ('700205','内审实施计划编制','/secure/basemodule/qms/internalaudits/page/month/impl-plan-edit-list?bpmn_statusCode=ImplePlanEdit','7002',5,'内审实施计划编制',NULL,NULL,NULL,'026.svg',NULL,NULL);
|
|
INSERT INTO T_CORE_MENU (ID,MENUNAME,HREF,PARENTID,ORDERNO,MENUINITNAME,LASTUPDATEDBYID,LASTUPDATEDBYNAME,LASTUPDATEDTIME,ICON,TODOICON,I18NCODE) VALUES ('700206','内审实施计划审批','/secure/basemodule/qms/internalaudits/page/month/impl-plan-audit-list?bpmn_statusCode=ImplePlanApprove','7002',6,'内审实施计划审批',NULL,NULL,NULL,'008.svg',NULL,NULL);
|
|
INSERT INTO T_CORE_MENU (ID,MENUNAME,HREF,PARENTID,ORDERNO,MENUINITNAME,LASTUPDATEDBYID,LASTUPDATEDBYNAME,LASTUPDATEDTIME,ICON,TODOICON,I18NCODE) VALUES ('700207','内审检查表审核发布','/secure/basemodule/qms/internalaudits/page/month/check-table-audit-list?bpmn_statusCode=CheckTableApprove','7002',7,'内审检查表审核发布',NULL,NULL,NULL,'008.svg',NULL,NULL);
|
|
INSERT INTO T_CORE_MENU (ID,MENUNAME,HREF,PARENTID,ORDERNO,MENUINITNAME,LASTUPDATEDBYID,LASTUPDATEDBYNAME,LASTUPDATEDTIME,ICON,TODOICON,I18NCODE) VALUES ('700208','内审首次会议','/secure/basemodule/qms/internalaudits/page/month/first-meeting-list?bpmn_statusCode=FirstMeet','7002',8,'内审首次会议',NULL,NULL,NULL,'010.svg',NULL,NULL);
|
|
INSERT INTO T_CORE_MENU (ID,MENUNAME,HREF,PARENTID,ORDERNO,MENUINITNAME,LASTUPDATEDBYID,LASTUPDATEDBYNAME,LASTUPDATEDTIME,ICON,TODOICON,I18NCODE) VALUES ('700209','内审实施','/secure/basemodule/qms/internalaudits/page/month/implement-list?bpmn_statusCode=Implement','7002',9,'内审实施',NULL,NULL,NULL,'022.svg',NULL,NULL);
|
|
INSERT INTO T_CORE_MENU (ID,MENUNAME,HREF,PARENTID,ORDERNO,MENUINITNAME,LASTUPDATEDBYID,LASTUPDATEDBYNAME,LASTUPDATEDTIME,ICON,TODOICON,I18NCODE) VALUES ('700210','内审末次会议','/secure/basemodule/qms/internalaudits/page/month/last-meeting-list?bpmn_statusCode=LastMeet','7002',10,'内审末次会议',NULL,NULL,NULL,'010.svg',NULL,NULL);
|
|
INSERT INTO T_CORE_MENU (ID,MENUNAME,HREF,PARENTID,ORDERNO,MENUINITNAME,LASTUPDATEDBYID,LASTUPDATEDBYNAME,LASTUPDATEDTIME,ICON,TODOICON,I18NCODE) VALUES ('700211','内审报告编制发布','/secure/basemodule/qms/internalaudits/page/month/report-edit-list?bpmn_statusCode=ReportEdit','7002',11,'内审报告编制',NULL,NULL,NULL,'026.svg',NULL,NULL);
|
|
INSERT INTO T_CORE_MENU (ID,MENUNAME,HREF,PARENTID,ORDERNO,MENUINITNAME,LASTUPDATEDBYID,LASTUPDATEDBYNAME,LASTUPDATEDTIME,ICON,TODOICON,I18NCODE) VALUES ('700212','内部审核查询','/secure/basemodule/qms/internalaudits/page/month/search-list','7002',12,'内审报告发布',NULL,NULL,NULL,'046.svg',NULL,NULL);
|
|
INSERT INTO T_CORE_MENU (ID,MENUNAME,HREF,PARENTID,ORDERNO,MENUINITNAME,LASTUPDATEDBYID,LASTUPDATEDBYNAME,LASTUPDATEDTIME,ICON,TODOICON,I18NCODE) VALUES ('700213','年度内审计划查询','/secure/basemodule/qms/internalaudits/page/search-list','7002',13,'年度内审计划查询',NULL,NULL,NULL,'077.svg',NULL,NULL);
|
|
|
|
|
|
-- 建表语句
|
|
CREATE TABLE T_LIMS_INTER_AUDIT_SIGN_RECORD(
|
|
ID NUMBER NOT NULL,
|
|
MEETID NUMBER NULL,
|
|
SIGNBYID VARCHAR2(36) NULL,
|
|
SIGNBYNAME VARCHAR2(60) NULL,
|
|
SIGNEDTIME DATE 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_INTER_AUDIT_SIGN_RECORD IS '年度内审签到记录';
|
|
COMMENT ON COLUMN T_LIMS_INTER_AUDIT_SIGN_RECORD.ID IS '主键';
|
|
COMMENT ON COLUMN T_LIMS_INTER_AUDIT_SIGN_RECORD.MEETID IS '会议id';
|
|
COMMENT ON COLUMN T_LIMS_INTER_AUDIT_SIGN_RECORD.SIGNBYID IS '签到人ID';
|
|
COMMENT ON COLUMN T_LIMS_INTER_AUDIT_SIGN_RECORD.SIGNBYNAME IS '签到人';
|
|
COMMENT ON COLUMN T_LIMS_INTER_AUDIT_SIGN_RECORD.SIGNEDTIME IS '签到时间';
|
|
COMMENT ON COLUMN T_LIMS_INTER_AUDIT_SIGN_RECORD.CREATEDBYID IS '制单人编码';
|
|
COMMENT ON COLUMN T_LIMS_INTER_AUDIT_SIGN_RECORD.CREATEDBYNAME IS '制单人名称';
|
|
COMMENT ON COLUMN T_LIMS_INTER_AUDIT_SIGN_RECORD.CREATEDTIME IS '制单时间';
|
|
COMMENT ON COLUMN T_LIMS_INTER_AUDIT_SIGN_RECORD.CREATEDBYORGID IS '制单人单位编码';
|
|
COMMENT ON COLUMN T_LIMS_INTER_AUDIT_SIGN_RECORD.CREATEDBYORGNAME IS '制单人单位名称';
|
|
|
|
ALTER TABLE T_LIMS_INTER_AUDIT_SIGN_RECORD ADD CONSTRAINT PK_INTER_AUDIT_SIGN_RECORD PRIMARY KEY (ID);
|
|
|
|
CALL INSERTI18N('T_LIMS_INTER_AUDIT_SIGN_RECORD.SERVICE_NAME', '年度内审签到记录', '年度内审签到记录', 'zh-CN', '年度内审签到记录');
|
|
CALL INSERTI18N('T_LIMS_INTER_AUDIT_SIGN_RECORD.ID', '年度内审签到记录的主键', '主键', 'zh-CN', '主键');
|
|
CALL INSERTI18N('T_LIMS_INTER_AUDIT_SIGN_RECORD.MEETID', '年度内审签到记录的会议id', '会议id', 'zh-CN', '会议id');
|
|
CALL INSERTI18N('T_LIMS_INTER_AUDIT_SIGN_RECORD.SIGNBYID', '年度内审签到记录的签到人ID', '签到人ID', 'zh-CN', '签到人ID');
|
|
CALL INSERTI18N('T_LIMS_INTER_AUDIT_SIGN_RECORD.SIGNBYNAME', '年度内审签到记录的签到人', '签到人', 'zh-CN', '签到人');
|
|
CALL INSERTI18N('T_LIMS_INTER_AUDIT_SIGN_RECORD.SIGNEDTIME', '年度内审签到记录的签到时间', '签到时间', 'zh-CN', '签到时间');
|
|
CALL INSERTI18N('T_LIMS_INTER_AUDIT_SIGN_RECORD.CREATEDBYID', '年度内审签到记录的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
|
|
CALL INSERTI18N('T_LIMS_INTER_AUDIT_SIGN_RECORD.CREATEDBYNAME', '年度内审签到记录的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
|
|
CALL INSERTI18N('T_LIMS_INTER_AUDIT_SIGN_RECORD.CREATEDTIME', '年度内审签到记录的制单时间', '制单时间', 'zh-CN', '制单时间');
|
|
CALL INSERTI18N('T_LIMS_INTER_AUDIT_SIGN_RECORD.CREATEDBYORGID', '年度内审签到记录的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
|
|
CALL INSERTI18N('T_LIMS_INTER_AUDIT_SIGN_RECORD.CREATEDBYORGNAME', '年度内审签到记录的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
|
|
CALL INSERTI18N('LIMS.QUALITY.INTERNALAUDITS.MODAL.ADD', '新增', '新增', 'zh-CN', '新增');
|
|
CALL INSERTI18N('LIMS.QUALITY.INTERNALAUDITS.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息');
|
|
CALL INSERTI18N('LIMS.QUALITY.INTERNALAUDITS.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮');
|
|
CALL INSERTI18N('LIMS.QUALITY.INTERNALAUDITS.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框');
|
|
CALL INSERTI18N('LIMS.QUALITY.INTERNALAUDITS.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框');
|
|
|
|
CALL INSERTI18N('T_LIMS_INTER_AUDIT_SIGN_RECORD.SIGN_RECORD', '签到记录', '签到记录', 'zh-CN', '签到记录');
|
|
|
|
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
|
|
VALUES ('T_LIMS_INTER_AUDIT_SIGN_RECORD', '0', '0');
|
|
|
|
|
|
/*内审检查表*/
|
|
CREATE TABLE T_LIMS_IN_AUDIT_CHECK_TABLE(
|
|
ID NUMBER NOT NULL,
|
|
CREATEDBYID VARCHAR2(36),
|
|
CREATEDBYNAME VARCHAR2(36),
|
|
CREATEDTIME DATE,
|
|
CREATEDBYORGID VARCHAR2(36),
|
|
CREATEDBYORGNAME VARCHAR2(300),
|
|
|
|
DETAILID NUMBER,
|
|
CONTENTID NUMBER,
|
|
SUBFACTORCODE VARCHAR2(36),
|
|
FACTORCONTENT VARCHAR2(360),
|
|
FILEINFO VARCHAR2(120),
|
|
REMARK VARCHAR2(360)
|
|
);
|
|
|
|
ALTER TABLE T_LIMS_IN_AUDIT_CHECK_TABLE ADD CONSTRAINT PK_LIMS_IN_AUDIT_CHECK_TABLE PRIMARY KEY (ID);
|
|
|
|
COMMENT ON COLUMN T_LIMS_IN_AUDIT_CHECK_TABLE.DETAILID IS '年度内审计划明细ID';
|
|
COMMENT ON COLUMN T_LIMS_IN_AUDIT_CHECK_TABLE.CONTENTID IS '核查内容ID';
|
|
COMMENT ON COLUMN T_LIMS_IN_AUDIT_CHECK_TABLE.SUBFACTORCODE IS '条款';
|
|
COMMENT ON COLUMN T_LIMS_IN_AUDIT_CHECK_TABLE.FACTORCONTENT IS '核查内容';
|
|
COMMENT ON COLUMN T_LIMS_IN_AUDIT_CHECK_TABLE.FILEINFO IS '对应的质量体系文件名称、编号、章节或条款号';
|
|
COMMENT ON COLUMN T_LIMS_IN_AUDIT_CHECK_TABLE.REMARK IS '备注';
|
|
|
|
/*年度内审计划详情*/
|
|
CREATE TABLE T_LIMS_INTERNAL_AUDIT_DETAIL(
|
|
ID NUMBER NOT NULL,
|
|
CREATEDBYID VARCHAR2(36),
|
|
CREATEDBYNAME VARCHAR2(36),
|
|
CREATEDTIME DATE,
|
|
CREATEDBYORGID VARCHAR2(36),
|
|
CREATEDBYORGNAME VARCHAR2(300),
|
|
|
|
PLANID NUMBER NOT NULL,
|
|
CLAUSENUM VARCHAR2(36),
|
|
ELEMENTNAME VARCHAR2(120),
|
|
JANUARY VARCHAR2(2),
|
|
FEBRUARY VARCHAR2(2),
|
|
MARCH VARCHAR2(2),
|
|
APRIL VARCHAR2(2),
|
|
MAY VARCHAR2(2),
|
|
JUNE VARCHAR2(2),
|
|
JULY VARCHAR2(2),
|
|
AUGUST VARCHAR2(2),
|
|
SEPTEMBER VARCHAR2(2),
|
|
OCTOBER VARCHAR2(2),
|
|
NOVEMBER VARCHAR2(2),
|
|
DECEMBER VARCHAR2(2),
|
|
REMARK VARCHAR2(360)
|
|
);
|
|
|
|
ALTER TABLE T_LIMS_INTERNAL_AUDIT_DETAIL ADD CONSTRAINT PK_T_INTERNAL_AUDIT_DETAIL PRIMARY KEY (ID);
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_DETAIL.PLANID IS '年度内审计划ID';
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_DETAIL.CLAUSENUM IS '条款号';
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_DETAIL.ELEMENTNAME IS '要素名称';
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_DETAIL.JANUARY IS '一月';
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_DETAIL.FEBRUARY IS '二月';
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_DETAIL.MARCH IS '三月';
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_DETAIL.APRIL IS '四月';
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_DETAIL.MAY IS '五月';
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_DETAIL.JUNE IS '六月';
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_DETAIL.JULY IS '七月';
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_DETAIL.AUGUST IS '八月';
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_DETAIL.SEPTEMBER IS '九月';
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_DETAIL.OCTOBER IS '十月';
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_DETAIL.NOVEMBER IS '十一月';
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_DETAIL.DECEMBER IS '十二月';
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_DETAIL.REMARK IS '备注';
|
|
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_DETAIL.SERVICE_NAME','年度内审计划详情','年度内审计划详情','zh-CN','年度内审计划详情');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_DETAIL.SERVICE_NAME','年度内审计划详情','年度内审计划详情','en-US','Details of annual internal audit plan');
|
|
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_DETAIL.CLAUSENUM','条款号','条款号','zh-CN','条款号');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_DETAIL.CLAUSENUM','条款号','条款号','en-US','Clause number');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_DETAIL.ELEMENTNAME','要素名称','要素名称','zh-CN','要素名称');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_DETAIL.ELEMENTNAME','要素名称','要素名称','en-US','Element name');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_DETAIL.REMARK','备注','备注','zh-CN','备注');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_DETAIL.REMARK','备注','备注','en-US','Remark');
|
|
|
|
|
|
/*内审检查表计划明细*/
|
|
CREATE TABLE T_LIMS_IN_AUDIT_FACTOR(
|
|
ID NUMBER NOT NULL,
|
|
CREATEDBYID VARCHAR2(36),
|
|
CREATEDBYNAME VARCHAR2(36),
|
|
CREATEDTIME DATE,
|
|
CREATEDBYORGID VARCHAR2(36),
|
|
CREATEDBYORGNAME VARCHAR2(300),
|
|
|
|
FACTORCODE VARCHAR2(36),
|
|
FACTORNAME VARCHAR2(36),
|
|
REMARK VARCHAR2(360)
|
|
);
|
|
|
|
ALTER TABLE T_LIMS_IN_AUDIT_FACTOR ADD CONSTRAINT PK_IN_AUDIT_FACTOR PRIMARY KEY (ID);
|
|
|
|
COMMENT ON COLUMN T_LIMS_IN_AUDIT_FACTOR.FACTORCODE IS '条款号';
|
|
COMMENT ON COLUMN T_LIMS_IN_AUDIT_FACTOR.FACTORNAME IS '要素名称';
|
|
COMMENT ON COLUMN T_LIMS_IN_AUDIT_FACTOR.REMARK IS '备注';
|
|
|
|
CALL INSERTI18N('T_LIMS_IN_AUDIT_FACTOR.FACTORCODE','条款号','条款号','zh-CN','条款号');
|
|
CALL INSERTI18N('T_LIMS_IN_AUDIT_FACTOR.FACTORCODE','条款号','条款号','en-US','Clause No');
|
|
CALL INSERTI18N('T_LIMS_IN_AUDIT_FACTOR.FACTORNAME','要素名称','要素名称','zh-CN','要素名称');
|
|
CALL INSERTI18N('T_LIMS_IN_AUDIT_FACTOR.FACTORNAME','要素名称','要素名称','en-US','Element Name');
|
|
CALL INSERTI18N('T_LIMS_IN_AUDIT_FACTOR.REMARK','备注','备注','zh-CN','备注');
|
|
CALL INSERTI18N('T_LIMS_IN_AUDIT_FACTOR.REMARK','备注','备注','en-US','Remark');
|
|
|
|
/*内审检查表计划核查内容*/
|
|
CREATE TABLE T_LIMS_IN_AUDIT_FACTOR_CONTENT(
|
|
ID NUMBER NOT NULL,
|
|
CREATEDBYID VARCHAR2(36),
|
|
CREATEDBYNAME VARCHAR2(36),
|
|
CREATEDTIME DATE,
|
|
CREATEDBYORGID VARCHAR2(36),
|
|
CREATEDBYORGNAME VARCHAR2(300),
|
|
|
|
FACTORID NUMBER,
|
|
SUBFACTORCODE VARCHAR2(36),
|
|
FACTORCONTENT VARCHAR2(360),
|
|
FILEINFO VARCHAR2(120),
|
|
REMARK VARCHAR2(360)
|
|
);
|
|
|
|
ALTER TABLE T_LIMS_IN_AUDIT_FACTOR_CONTENT ADD CONSTRAINT PK_IN_AUDIT_FACTOR_CONTENT PRIMARY KEY (ID);
|
|
|
|
COMMENT ON COLUMN T_LIMS_IN_AUDIT_FACTOR_CONTENT.FACTORID IS '条款ID';
|
|
COMMENT ON COLUMN T_LIMS_IN_AUDIT_FACTOR_CONTENT.SUBFACTORCODE IS '条款';
|
|
COMMENT ON COLUMN T_LIMS_IN_AUDIT_FACTOR_CONTENT.FACTORCONTENT IS '核查内容';
|
|
COMMENT ON COLUMN T_LIMS_IN_AUDIT_FACTOR_CONTENT.FILEINFO IS '对应的质量体系文件名称、编号、章节或条款号';
|
|
COMMENT ON COLUMN T_LIMS_IN_AUDIT_FACTOR_CONTENT.REMARK IS '备注';
|
|
|
|
CALL INSERTI18N('T_LIMS_IN_AUDIT_FACTOR_CONTENT.SUBFACTORCODE','条款','条款','zh-CN','条款');
|
|
CALL INSERTI18N('T_LIMS_IN_AUDIT_FACTOR_CONTENT.SUBFACTORCODE','条款','条款','en-US','Clause No');
|
|
CALL INSERTI18N('T_LIMS_IN_AUDIT_FACTOR_CONTENT.FACTORCONTENT','核查内容','核查内容','zh-CN','核查内容');
|
|
CALL INSERTI18N('T_LIMS_IN_AUDIT_FACTOR_CONTENT.FACTORCONTENT','核查内容','核查内容','en-US','Verification content');
|
|
CALL INSERTI18N('T_LIMS_IN_AUDIT_FACTOR_CONTENT.FILEINFO','对应的质量体系文件名称、编号、章节或条款号','对应的质量体系文件名称、编号、章节或条款号','zh-CN','对应的质量体系文件名称、编号、章节或条款号');
|
|
CALL INSERTI18N('T_LIMS_IN_AUDIT_FACTOR_CONTENT.FILEINFO','对应的质量体系文件名称、编号、章节或条款号','对应的质量体系文件名称、编号、章节或条款号','en-US','Corresponding quality system document name, number, chapter or clause number');
|
|
CALL INSERTI18N('T_LIMS_IN_AUDIT_FACTOR_CONTENT.REMARK','备注','备注','zh-CN','备注');
|
|
CALL INSERTI18N('T_LIMS_IN_AUDIT_FACTOR_CONTENT.REMARK','备注','备注','en-US','Remark');
|
|
|
|
CALL INSERTI18N('LIMS.QUALITY.INTERNAL.AUDIT.FACTOR.MODEL.ADD','添加内审核查条款','添加内审核查条款','zh-CN','添加内审核查条款');
|
|
CALL INSERTI18N('LIMS.QUALITY.INTERNAL.AUDIT.FACTOR.MODEL.ADD','添加内审核查条款','添加内审核查条款','en-US','Add internal audit terms');
|
|
CALL INSERTI18N('LIMS.QUALITY.INTERNAL.AUDIT.FACTOR.TAB.CONTENT','内审核查内容','内审核查内容','zh-CN','内审核查内容');
|
|
CALL INSERTI18N('LIMS.QUALITY.INTERNAL.AUDIT.FACTOR.TAB.CONTENT','内审核查内容','内审核查内容','en-US','Contents of internal audit');
|
|
|
|
/*年度内审计划详情*/
|
|
CREATE TABLE T_LIMS_INTERNAL_AUDIT_MONTH(
|
|
ID NUMBER NOT NULL,
|
|
CREATEDBYID VARCHAR2(36),
|
|
CREATEDBYNAME VARCHAR2(36),
|
|
CREATEDTIME DATE,
|
|
CREATEDBYORGID VARCHAR2(36),
|
|
CREATEDBYORGNAME VARCHAR2(300),
|
|
|
|
PLANID NUMBER NOT NULL,
|
|
MONTH VARCHAR2(36),
|
|
PROCESSSTATUS VARCHAR2(36),
|
|
REMARK VARCHAR2(360)
|
|
);
|
|
|
|
ALTER TABLE T_LIMS_INTERNAL_AUDIT_MONTH ADD CONSTRAINT PK_T_LIMS_INTERNAL_AUDIT_MONTH PRIMARY KEY (ID);
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_MONTH.PLANID IS '年度内审计划ID';
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_MONTH.MONTH IS '月份';
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_MONTH.PROCESSSTATUS IS '流程状态';
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_MONTH.REMARK IS '备注';
|
|
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.SERVICE_NAME','月度内审实施计划','月度内审实施计划','zh-CN','月度内审实施计划');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.SERVICE_NAME','月度内审实施计划','月度内审实施计划','en-US','Monthly internal audit implementation plan');
|
|
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.MONTH','月份','月份','zh-CN','月份');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.MONTH','月份','月份','en-US','Month');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.REMARK','备注','备注','zh-CN','备注');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.REMARK','备注','备注','en-US','Remark');
|
|
|
|
INSERT INTO T_CORE_TABLE(ID, AUDITABLE, ATTACHMENT) VALUES('T_LIMS_INTERNAL_AUDIT_MONTH', '0', '0');
|
|
INSERT INTO T_CORE_MENU_EXT(ID, SERVICENAME, TABLENAME, TYPE, ENABLE)
|
|
VALUES('2021070701', '月度内审实施计划', 'T_LIMS_INTERNAL_AUDIT_MONTH', 'audit_def', '1');
|
|
|
|
|
|
ALTER TABLE T_LIMS_INTERNAL_AUDIT_MONTH ADD TEAMLEADERID VARCHAR2(36);
|
|
ALTER TABLE T_LIMS_INTERNAL_AUDIT_MONTH ADD TEAMLEADERNAME VARCHAR2(36);
|
|
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_MONTH.TEAMLEADERID IS '审核组长';
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_MONTH.TEAMLEADERNAME IS '审核组长';
|
|
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.TEAMLEADERID','审核组长','审核组长','zh-CN','审核组长');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.TEAMLEADERID','审核组长','审核组长','en-US','Audit Team Leader Num');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.TEAMLEADERNAME','审核组长','审核组长','zh-CN','审核组长');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.TEAMLEADERNAME','审核组长','审核组长','en-US','Audit Team Leader Name');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.AUDITORS','审核组成员','审核组成员','zh-CN','审核组成员');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.AUDITORS','审核组成员','审核组成员','en-US','Audit team members');
|
|
|
|
ALTER TABLE T_LIMS_INTERNAL_AUDIT_MONTH ADD AUDITPURPOSE VARCHAR2(1200);
|
|
ALTER TABLE T_LIMS_INTERNAL_AUDIT_MONTH ADD AUDITSCOPE VARCHAR2(1200);
|
|
ALTER TABLE T_LIMS_INTERNAL_AUDIT_MONTH ADD AUDITBASIS VARCHAR2(1200);
|
|
ALTER TABLE T_LIMS_INTERNAL_AUDIT_MONTH ADD AUDITDATE DATE;
|
|
ALTER TABLE T_LIMS_INTERNAL_AUDIT_MONTH ADD REPORTDATESCOPE VARCHAR2(1200);
|
|
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_MONTH.AUDITPURPOSE IS '审核目的';
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_MONTH.AUDITSCOPE IS '审核范围';
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_MONTH.AUDITBASIS IS '审核依据';
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_MONTH.AUDITDATE IS '审核时间';
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_MONTH.REPORTDATESCOPE IS '审核报告发布日期和范围';
|
|
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.AUDITPURPOSE','审核目的','审核目的','zh-CN','审核目的');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.AUDITPURPOSE','审核目的','审核目的','en-US','Audit Purpose');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.AUDITSCOPE','审核范围','审核范围','zh-CN','审核范围');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.AUDITSCOPE','审核范围','审核范围','en-US','Audit Scope');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.AUDITBASIS','审核依据','审核依据','zh-CN','审核依据');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.AUDITBASIS','审核依据','审核依据','en-US','Audit Basis');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.AUDITDATE','审核时间','审核时间','zh-CN','审核时间');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.AUDITDATE','审核时间','审核时间','en-US','Audit Time');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.REPORTDATESCOPE','审核报告发布日期和范围','审核报告发布日期和范围','zh-CN','审核报告发布日期和范围');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.REPORTDATESCOPE','审核报告发布日期和范围','审核报告发布日期和范围','en-US','Release date and scope of audit report');
|
|
|
|
CALL INSERTI18N('LIMS.QUALITY.INTERNALAUDITPLAN.TAB.IMPLEMENT_PLAN','内审实施计划','内审实施计划','zh-CN','内审实施计划');
|
|
CALL INSERTI18N('LIMS.QUALITY.INTERNALAUDITPLAN.TAB.IMPLEMENT_PLAN','内审实施计划','内审实施计划','en-US','Internal audit implementation plan');
|
|
|
|
/*年度内审计划*/
|
|
CREATE TABLE T_LIMS_INTERNAL_AUDIT_PLAN(
|
|
ID NUMBER NOT NULL,
|
|
CREATEDBYID VARCHAR2(36),
|
|
CREATEDBYNAME VARCHAR2(36),
|
|
CREATEDTIME DATE,
|
|
CREATEDBYORGID VARCHAR2(36),
|
|
CREATEDBYORGNAME VARCHAR2(300),
|
|
|
|
YEARPLANID NUMBER NOT NULL,
|
|
PLANNAME VARCHAR2(36),
|
|
PROCESSSTATUS VARCHAR2(36),
|
|
REMARK VARCHAR2(360)
|
|
);
|
|
|
|
ALTER TABLE T_LIMS_INTERNAL_AUDIT_PLAN ADD CONSTRAINT PK_T_LIMS_INTERNAL_AUDIT_PLAN PRIMARY KEY (ID);
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_PLAN.YEARPLANID IS '年度质量工作计划ID';
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_PLAN.PLANNAME IS '年度内审计划名称';
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_PLAN.PROCESSSTATUS IS '流程状态';
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_PLAN.REMARK IS '备注';
|
|
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_PLAN.SERVICE_NAME','年度内审计划','年度内审计划','zh-CN','年度内审计划');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_PLAN.SERVICE_NAME','年度内审计划','年度内审计划','en-US','Annual Internal Audit Plan');
|
|
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_PLAN.PLANNAME','年度内审计划名称','年度内审计划名称','zh-CN','年度内审计划名称');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_PLAN.PLANNAME','年度内审计划名称','年度内审计划名称','en-US','Name of annual internal audit plan');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_PLAN.REMARK','备注','备注','zh-CN','备注');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_PLAN.REMARK','备注','备注','en-US','Remark');
|
|
|
|
INSERT INTO T_CORE_TABLE(ID, AUDITABLE, ATTACHMENT) VALUES('T_LIMS_INTERNAL_AUDIT_PLAN', '0', '0');
|
|
INSERT INTO T_CORE_MENU_EXT(ID, SERVICENAME, TABLENAME, TYPE, ENABLE)
|
|
VALUES('2021070502', '年度内审计划', 'T_LIMS_INTERNAL_AUDIT_PLAN', 'audit_def', '1');
|
|
|
|
ALTER TABLE T_LIMS_INTERNAL_AUDIT_PLAN ADD PLANCODE VARCHAR2(36);
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_PLAN.PLANCODE IS '内审编号';
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_PLAN.PLANCODE','内审编号','内审编号','zh-CN','内审编号');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_PLAN.PLANCODE','内审编号','内审编号','en-US','Internal audit No');
|
|
|
|
ALTER TABLE T_LIMS_INTERNAL_AUDIT_PLAN ADD ADDDATE DATE;
|
|
|
|
/*审核进程安排*/
|
|
CREATE TABLE T_LIMS_INTERNAL_AUDIT_PROCESS(
|
|
ID NUMBER NOT NULL,
|
|
CREATEDBYID VARCHAR2(36),
|
|
CREATEDBYNAME VARCHAR2(36),
|
|
CREATEDTIME DATE,
|
|
CREATEDBYORGID VARCHAR2(36),
|
|
CREATEDBYORGNAME VARCHAR2(300),
|
|
|
|
MONTHPLANID NUMBER NOT NULL,
|
|
PROCESSDATE DATE,
|
|
AUDITEDDEPT VARCHAR2(120),
|
|
CHARGE VARCHAR2(36),
|
|
AUDITOR VARCHAR2(36),
|
|
AUDITCONTENT VARCHAR2(360)
|
|
);
|
|
ALTER TABLE T_LIMS_INTERNAL_AUDIT_PROCESS ADD CONSTRAINT PK_T_INTERNAL_AUDIT_PROCESS PRIMARY KEY (ID);
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_PROCESS.MONTHPLANID IS '月度内审计划ID';
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_PROCESS.PROCESSDATE IS '时间';
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_PROCESS.AUDITEDDEPT IS '受审核部门';
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_PROCESS.CHARGE IS '责任人';
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_PROCESS.AUDITOR IS '内审员';
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_PROCESS.AUDITCONTENT IS '审核内容';
|
|
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_PROCESS.SERVICE_NAME','审核进程安排','审核进程安排','zh-CN','审核进程安排');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_PROCESS.SERVICE_NAME','审核进程安排','审核进程安排','en-US','Audit Process Arrangement');
|
|
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_PROCESS.PROCESSDATE','时间','时间','zh-CN','时间');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_PROCESS.PROCESSDATE','时间','时间','en-US','Time');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_PROCESS.AUDITEDDEPT','受审核部门','受审核部门','zh-CN','受审核部门');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_PROCESS.AUDITEDDEPT','受审核部门','受审核部门','en-US','Audited Department');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_PROCESS.CHARGE','责任人','责任人','zh-CN','责任人');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_PROCESS.CHARGE','责任人','责任人','en-US','Person Liable');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_PROCESS.AUDITOR','内审员','内审员','zh-CN','内审员');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_PROCESS.AUDITOR','内审员','内审员','en-US','Internal Auditor');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_PROCESS.AUDITCONTENT','审核内容','审核内容','zh-CN','审核内容');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_PROCESS.AUDITCONTENT','审核内容','审核内容','en-US','Audit Content');
|
|
|
|
ALTER TABLE T_LIMS_INTERNAL_AUDIT_PROCESS ADD AUDITORID VARCHAR2(36);
|
|
|
|
/*内审审核组*/
|
|
CREATE TABLE T_LIMS_INTERNAL_AUDIT_TEAM(
|
|
ID NUMBER NOT NULL,
|
|
CREATEDBYID VARCHAR2(36),
|
|
CREATEDBYNAME VARCHAR2(36),
|
|
CREATEDTIME DATE,
|
|
CREATEDBYORGID VARCHAR2(36),
|
|
CREATEDBYORGNAME VARCHAR2(300),
|
|
|
|
MONTHPLANID NUMBER NOT NULL,
|
|
REVIEWERID VARCHAR2(36),
|
|
REVIEWERNAME VARCHAR2(36),
|
|
LEADERFLAG VARCHAR2(2),
|
|
REMARK VARCHAR2(360)
|
|
);
|
|
|
|
ALTER TABLE T_LIMS_INTERNAL_AUDIT_TEAM ADD CONSTRAINT PK_T_LIMS_INTERNAL_AUDIT_TEAM PRIMARY KEY (ID);
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_TEAM.MONTHPLANID IS '月度内审计划ID';
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_TEAM.REVIEWERID IS '内审人员账号';
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_TEAM.REVIEWERNAME IS '内审人员姓名';
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_TEAM.LEADERFLAG IS '是否审核组长';
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_TEAM.REMARK IS '备注';
|
|
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_TEAM.SERVICE_NAME','内审审核组','内审审核组','zh-CN','内审审核组');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_TEAM.SERVICE_NAME','内审审核组','内审审核组','en-US','Internal audit team');
|
|
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_TEAM.REVIEWERID','内审人员账号','内审人员账号','zh-CN','内审人员账号');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_TEAM.REVIEWERID','内审人员账号','内审人员账号','en-US','Internal auditor account number');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_TEAM.REVIEWERNAME','内审人员姓名','内审人员姓名','zh-CN','内审人员姓名');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_TEAM.REVIEWERNAME','内审人员姓名','内审人员姓名','en-US','Name of internal auditor');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_TEAM.LEADERFLAG','是否审核组长','是否审核组长','zh-CN','是否审核组长');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_TEAM.LEADERFLAG','是否审核组长','是否审核组长','en-US','Audit team leader');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_TEAM.REMARK','备注','备注','zh-CN','备注');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_TEAM.REMARK','备注','备注','en-US','Remark');
|
|
|
|
CALL INSERTI18N('LIMS.QUALITY.INTERNALAUDITPLAN.TAB.DETAILLIST','年度内审计划明细','年度内审计划明细','zh-CN','年度内审计划明细');
|
|
CALL INSERTI18N('LIMS.QUALITY.INTERNALAUDITPLAN.TAB.DETAILLIST','年度内审计划明细','年度内审计划明细','en-US','Details of annual internal audit plan');
|
|
CALL INSERTI18N('LIMS.QUALITY.INTERNALAUDITPLAN.DETAIL.MODEL.ADD','年度内审计划明细添加','年度内审计划明细添加','zh-CN','年度内审计划明细添加');
|
|
CALL INSERTI18N('LIMS.QUALITY.INTERNALAUDITPLAN.DETAIL.MODEL.ADD','年度内审计划明细添加','年度内审计划明细添加','en-US','Add details of annual internal audit plan');
|
|
CALL INSERTI18N('LIMS.QUALITY.INTERNALAUDITPLAN.TAB.ATTACHMENT','附件','附件','zh-CN','附件');
|
|
CALL INSERTI18N('LIMS.QUALITY.INTERNALAUDITPLAN.TAB.ATTACHMENT','附件','附件','en-US','Attachment');
|
|
CALL INSERTI18N('LIMS.QUALITY.INTERNALAUDITPLAN.TAB.DETAILLIST','年度内审计划明细','年度内审计划明细','zh-CN','年度内审计划明细');
|
|
CALL INSERTI18N('LIMS.QUALITY.INTERNALAUDITPLAN.TAB.DETAILLIST','年度内审计划明细','年度内审计划明细','en-US','Details of annual internal audit plan');
|
|
CALL INSERTI18N('LIMS.QUALITY.INTERNALAUDITPLAN.DETAIL.MODEL.ADD','年度内审计划明细添加','年度内审计划明细添加','zh-CN','年度内审计划明细添加');
|
|
CALL INSERTI18N('LIMS.QUALITY.INTERNALAUDITPLAN.DETAIL.MODEL.ADD','年度内审计划明细添加','年度内审计划明细添加','en-US','Add details of annual internal audit plan');
|
|
CALL INSERTI18N('LIMS.QUALITY.INTERNALAUDITPLAN.TAB.ATTACHMENT','附件','附件','zh-CN','附件');
|
|
CALL INSERTI18N('LIMS.QUALITY.INTERNALAUDITPLAN.TAB.ATTACHMENT','附件','附件','en-US','Attachment');
|
|
|
|
ALTER TABLE T_LIMS_IN_AUDIT_FACTOR ADD LABORATORYID VARCHAR2(36);
|
|
ALTER TABLE T_LIMS_IN_AUDIT_FACTOR ADD LABORATORYNAME VARCHAR2(36);
|
|
CALL INSERTI18N('T_LIMS_IN_AUDIT_FACTOR.LABORATORYNAME', '实验室', '实验室', 'zh-CN', '实验室');
|
|
CALL INSERTI18N('T_LIMS_IN_AUDIT_FACTOR.LABORATORYNAME', '实验室', '实验室', 'en-US', 'Laboratory');
|
|
ALTER TABLE T_LIMS_IN_AUDIT_FACTOR_CONTENT ADD SORTER NUMBER;
|
|
CALL INSERTI18N('T_LIMS_IN_AUDIT_FACTOR.SORTER','样品的序号','序号','zh-CN','序号');
|
|
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT.CHECK.TABLE.SERVICE_NAME','内审检查表','内审检查表','zh-CN','内审检查表');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT.CHECK.TABLE.SERVICE_NAME','内审检查表','内审检查表','en-US','Internal Audit CheckList');
|
|
ALTER TABLE T_LIMS_INTERNAL_AUDIT_MONTH ADD MONTHPLANCODE VARCHAR2(36);
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_MONTH.MONTHPLANCODE IS '月度内审编号';
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.MONTHPLANCODE','月度内审编号','月度内审编号','zh-CN','月度内审编号');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.MONTHPLANCODE','月度内审编号','月度内审编号','en-US','Monthly internal audit No');
|
|
|
|
ALTER TABLE T_LIMS_INTERNAL_AUDIT_MONTH ADD REPORTDATE DATE;
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_MONTH.REPORTDATE IS '报告发布日期';
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.REPORTDATE','报告发布日期','报告发布日期','zh-CN','报告发布日期');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.REPORTDATE','报告发布日期','报告发布日期','en-US','Report release date');
|
|
ALTER TABLE T_LIMS_INTERNAL_AUDIT_MONTH ADD REPORTSCOPE VARCHAR2(120);
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_MONTH.REPORTSCOPE IS '报告发布范围';
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.REPORTSCOPE','报告发布范围','报告发布范围','zh-CN','报告发布范围');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.REPORTSCOPE','报告发布范围','报告发布范围','en-US','Report release scope');
|
|
ALTER TABLE T_LIMS_INTERNAL_AUDIT_MONTH ADD REPORTSCOPEIDS VARCHAR2(120);
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_MONTH.REPORTSCOPEIDS IS '报告发布范围';
|
|
|
|
|
|
|
|
|
|
/*内审首次会议*/
|
|
ALTER TABLE T_LIMS_INTERNAL_AUDIT_MONTH ADD FIRSTMEETID NUMBER;
|
|
ALTER TABLE T_LIMS_INTERNAL_AUDIT_MONTH ADD FIRSTMEETTIME DATE;
|
|
ALTER TABLE T_LIMS_INTERNAL_AUDIT_MONTH ADD FIRSTMEETLOC VARCHAR2(300);
|
|
ALTER TABLE T_LIMS_INTERNAL_AUDIT_MONTH ADD FIRSTMEETPERSON VARCHAR2(300);
|
|
ALTER TABLE T_LIMS_INTERNAL_AUDIT_MONTH ADD FIRSTMEETCONTENT VARCHAR2(1200);
|
|
/*内审末次会议*/
|
|
ALTER TABLE T_LIMS_INTERNAL_AUDIT_MONTH ADD LASTMEETID NUMBER;
|
|
ALTER TABLE T_LIMS_INTERNAL_AUDIT_MONTH ADD LASTMEETTIME DATE;
|
|
ALTER TABLE T_LIMS_INTERNAL_AUDIT_MONTH ADD LASTMEETLOC VARCHAR2(300);
|
|
ALTER TABLE T_LIMS_INTERNAL_AUDIT_MONTH ADD LASTMEETPERSON VARCHAR2(300);
|
|
ALTER TABLE T_LIMS_INTERNAL_AUDIT_MONTH ADD LASTMEETCONTENT VARCHAR2(1200);
|
|
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_MONTH.FIRSTMEETID IS '首次会议ID';
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_MONTH.FIRSTMEETTIME IS '首次会议时间';
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_MONTH.FIRSTMEETLOC IS '首次会议地点';
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_MONTH.FIRSTMEETPERSON IS '首次会议人员';
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_MONTH.FIRSTMEETCONTENT IS '首次会议内容';
|
|
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_MONTH.LASTMEETID IS '末次会议ID';
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_MONTH.LASTMEETTIME IS '末次会议时间';
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_MONTH.LASTMEETLOC IS '末次会议地点';
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_MONTH.LASTMEETPERSON IS '末次会议人员';
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_MONTH.LASTMEETCONTENT IS '末次会议内容';
|
|
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.FIRSTMEETID','首次会议ID','首次会议ID','zh-CN','首次会议ID');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.FIRSTMEETID','首次会议ID','首次会议ID','en-US','First Meeting ID');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.FIRSTMEETTIME','首次会议时间','首次会议时间','zh-CN','首次会议时间');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.FIRSTMEETTIME','首次会议时间','首次会议时间','en-US','First Meeting Timre');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.FIRSTMEETLOC','首次会议地点','首次会议地点','zh-CN','首次会议地点');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.FIRSTMEETLOC','首次会议地点','首次会议地点','en-US','First Meeting Location');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.FIRSTMEETPERSON','首次会议人员','首次会议人员','zh-CN','首次会议人员');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.FIRSTMEETPERSON','首次会议人员','首次会议人员','en-US','First Meeting Person');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.FIRSTMEETCONTENT','首次会议内容','首次会议内容','zh-CN','首次会议内容');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.FIRSTMEETCONTENT','首次会议内容','首次会议内容','en-US','First Meeting Content');
|
|
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.LASTMEETID','末次会议ID','末次会议ID','zh-CN','末次会议ID');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.LASTMEETID','末次会议ID','末次会议ID','en-US','Last Meeting ID');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.LASTMEETTIME','末次会议时间','末次会议时间','zh-CN','末次会议时间');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.LASTMEETTIME','末次会议时间','末次会议时间','en-US','Last Meeting Timre');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.LASTMEETLOC','末次会议地点','末次会议地点','zh-CN','末次会议地点');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.LASTMEETLOC','末次会议地点','末次会议地点','en-US','Last Meeting Location');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.LASTMEETPERSON','末次会议人员','末次会议人员','zh-CN','末次会议人员');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.LASTMEETPERSON','末次会议人员','末次会议人员','en-US','Last Meeting Person');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.LASTMEETCONTENT','末次会议内容','末次会议内容','zh-CN','末次会议内容');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.LASTMEETCONTENT','末次会议内容','末次会议内容','en-US','Last Meeting Content');
|
|
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT.FIRST_MEETING.SERVICE_NAME','首次会议','首次会议','zh-CN','首次会议');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT.FIRST_MEETING.SERVICE_NAME','首次会议','首次会议','en-US','First Meeting');
|
|
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT.LAST_MEETING.SERVICE_NAME','末次会议','末次会议','zh-CN','末次会议');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT.LAST_MEETING.SERVICE_NAME','末次会议','末次会议','en-US','Last Meeting');
|
|
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT.IMPLEMENT.SERVICE_NAME','内审实施记录','内审实施记录','zh-CN','内审实施记录');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT.IMPLEMENT.SERVICE_NAME','内审实施记录','内审实施记录','en-US','Internal Audit Implementation Record');
|
|
|
|
ALTER TABLE T_LIMS_INTERNAL_AUDIT_MONTH ADD PARTICIPANTS VARCHAR2(300);
|
|
ALTER TABLE T_LIMS_INTERNAL_AUDIT_MONTH ADD ACTUALAUDITDATE DATE;
|
|
ALTER TABLE T_LIMS_INTERNAL_AUDIT_MONTH ADD AUDITREVIEW VARCHAR2(1200);
|
|
ALTER TABLE T_LIMS_INTERNAL_AUDIT_MONTH ADD AUDITRESULT VARCHAR2(1200);
|
|
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_MONTH.PARTICIPANTS IS '受审核部门参与人员';
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_MONTH.ACTUALAUDITDATE IS '实际审核日期';
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_MONTH.AUDITREVIEW IS '审核综述';
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_MONTH.AUDITRESULT IS '审核结论';
|
|
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.PARTICIPANTS','受审核部门参与人员','受审核部门参与人员','zh-CN','受审核部门参与人员');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.PARTICIPANTS','受审核部门参与人员','受审核部门参与人员','en-US','Participants of Audited Department');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.ACTUALAUDITDATE','实际审核日期','实际审核日期','zh-CN','实际审核日期');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.ACTUALAUDITDATE','实际审核日期','实际审核日期','en-US','Actual Audit Date');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.AUDITREVIEW','审核综述','审核综述','zh-CN','审核综述');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.AUDITREVIEW','审核综述','审核综述','en-US','Review of Audit');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.AUDITRESULT','审核结论','审核结论','zh-CN','审核结论');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.AUDITRESULT','审核结论','审核结论','en-US','Audit Conclusion');
|
|
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT.REPORT.SERVICE_NAME','内审报告','内审报告','zh-CN','内审报告');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT.REPORT.SERVICE_NAME','内审报告','内审报告','en-US','Internal Audit Report');
|
|
CALL INSERTI18N('GIKAM.BUTTON.QRCODE', '二维码', '二维码', 'zh-CN', '二维码');
|
|
|
|
INSERT INTO T_CORE_ADMIN_CHOOSE_CONFIG (ID,NAME,TITLE,CATEGORY,URL,WIDTH) VALUES (775065969303232,'内审核查明细选择','内审核查明细选择','internalAuditFactors','/secure/basemodule/qms/internalaudits/page/factor/choose-list','50%');
|
|
INSERT INTO T_CORE_ADMIN_CHOOSE_CONFIG (ID,NAME,TITLE,CATEGORY,URL,WIDTH) VALUES (775233209553280,'内审员选择','内审员选择','internalAuditTeam','/secure/basemodule/qms/internalaudits/page/checkteam/choose-list',NULL);
|
|
|
|
ALTER TABLE T_LIMS_INTERNAL_AUDIT_MONTH ADD ACTUALAUDITENDDATE DATE;
|
|
COMMENT ON COLUMN T_LIMS_INTERNAL_AUDIT_MONTH.ACTUALAUDITENDDATE IS '实际审核结束时间';
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.ACTUALAUDITENDDATE','实际审核结束时间','实际审核结束时间','zh-CN','实际审核结束时间');
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_MONTH.ACTUALAUDITENDDATE','实际审核结束时间','实际审核结束时间','en-US','Actual Audit End Time');
|
|
CALL UPDATEI18N('T_LIMS_INTERNAL_AUDIT_MONTH.ACTUALAUDITDATE', 'zh-CN','实际审核开始时间');
|
|
CALL UPDATEI18N('T_LIMS_INTERNAL_AUDIT_MONTH.ACTUALAUDITDATE', 'en-US','Actual Audit Start Time');
|
|
|
|
ALTER TABLE T_LIMS_IN_AUDIT_FACTOR MODIFY LABORATORYNAME VARCHAR2(270);
|
|
CALL INSERTI18N('PLEASE.CHOOSE.CURRENT.MONTH.TIME','请选择内审计划月份内的日期','请选择内审计划月份内的日期','zh-CN','请选择内审计划月份内的日期');
|
|
|
|
COMMIT;
|
|
-- ----------------------------- 2022-09-09 add by qiuyf--------------end
|
|
|
|
|
|
-- ----------------------------- 2022-10-17 add by wangyuwei--------------begin
|
|
|
|
ALTER TABLE T_LIMS_INTERNAL_AUDIT_PLAN ADD AUDITPURPOSE varchar2(270);
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_PLAN.AUDITPURPOSE', '审核目的', '审核目的', 'zh-CN', '审核目的');
|
|
ALTER TABLE T_LIMS_INTERNAL_AUDIT_PLAN ADD AUDITRANGE varchar2(270);
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_PLAN.AUDITRANGE', '审核范围', '审核范围', 'zh-CN', '审核范围');
|
|
ALTER TABLE T_LIMS_INTERNAL_AUDIT_PLAN ADD AUDITBASIS varchar2(270);
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_PLAN.AUDITBASIS', '审核依据', '审核依据', 'zh-CN', '审核依据');
|
|
ALTER TABLE T_LIMS_INTERNAL_AUDIT_PLAN ADD EXECUTINGUNIT varchar2(270);
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_PLAN.EXECUTINGUNIT', '执行单位', '执行单位', 'zh-CN', '执行单位');
|
|
|
|
ALTER TABLE T_LIMS_IN_AUDIT_FACTOR_CONTENT ADD CHECKMODE varchar2(36);
|
|
CALL INSERTI18N('T_LIMS_IN_AUDIT_FACTOR_CONTENT.CHECKMODE', '审核方式', '审核方式', 'zh-CN', '审核方式');
|
|
ALTER TABLE T_LIMS_IN_AUDIT_FACTOR_CONTENT ADD CHECKRESULT varchar2(36);
|
|
CALL INSERTI18N('T_LIMS_IN_AUDIT_FACTOR_CONTENT.CHECKRESULT', '审核结果', '审核结果', 'zh-CN', '审核结果');
|
|
ALTER TABLE T_LIMS_IN_AUDIT_FACTOR_CONTENT ADD CHECKCONCLUSION varchar2(36);
|
|
CALL INSERTI18N('T_LIMS_IN_AUDIT_FACTOR_CONTENT.CHECKCONCLUSION', '检查结论', '检查结论', 'zh-CN', '检查结论');
|
|
|
|
|
|
ALTER TABLE T_LIMS_INTERNAL_AUDIT_DETAIL ADD FREQUENCY varchar2(36);
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_DETAIL.FREQUENCY', '次数', '次数', 'zh-CN', '次数');
|
|
ALTER TABLE T_LIMS_INTERNAL_AUDIT_DETAIL ADD TIME varchar2(36);
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_DETAIL.TIME', '时间', '时间', 'zh-CN', '时间');
|
|
ALTER TABLE T_LIMS_INTERNAL_AUDIT_DETAIL ADD AUDITITEMS varchar2(36);
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_DETAIL.AUDITITEMS', '审核要项', '审核要项', 'zh-CN', '审核要项');
|
|
ALTER TABLE T_LIMS_INTERNAL_AUDIT_DETAIL ADD AUDITEE varchar2(36);
|
|
CALL INSERTI18N('T_LIMS_INTERNAL_AUDIT_DETAIL.AUDITEE', '受审对象', '受审对象', 'zh-CN', '受审对象');
|
|
-- ----------------------------- 2022-10-17 add by wangyuwei--------------end
|
|
|
|
|
|
|
|
-- ----------------------------- 2022-10-18 add by wangyuwei--------------begin
|
|
|
|
ALTER TABLE T_LIMS_INTERNAL_AUDIT_DETAIL MODIFY frequency varchar2(36)
|
|
|
|
ALTER TABLE T_LIMS_INTERNAL_AUDIT_DETAIL MODIFY time DATE
|
|
|
|
-- ----------------------------- 2022-10-18 add by wangyuwei--------------end
|
|
|
|
-- ----------------------------- 2022-10-19 add by wangyuwei--------------begin
|
|
|
|
INSERT INTO T_CORE_ADMIN_CHOOSE_CONFIG (ID,NAME,TITLE,CATEGORY,URL,WIDTH) VALUES
|
|
(202210191355,'年度内审计划选择列表页面','年度内审计划选择列表页面','internalAuditPlanChoose','/secure/basemodule/qms/internalaudits/page/choose-list','80%');
|
|
|
|
-- ----------------------------- 2022-10-19 add by wangyuwei--------------end
|
|
|
|
|
|
-- ----------------------------- 2022-10-20 add by wangyuwei--------------begin
|
|
|
|
ALTER TABLE T_LIMS_IN_AUDIT_CHECK_TABLE ADD CHECKMODE varchar2(36);
|
|
CALL INSERTI18N('T_LIMS_IN_AUDIT_CHECK_TABLE.CHECKMODE', '审核方式', '审核方式', 'zh-CN', '审核方式');
|
|
ALTER TABLE T_LIMS_IN_AUDIT_CHECK_TABLE ADD CHECKRESULT varchar2(36);
|
|
CALL INSERTI18N('T_LIMS_IN_AUDIT_CHECK_TABLE.CHECKRESULT', '审核结果', '审核结果', 'zh-CN', '审核结果');
|
|
ALTER TABLE T_LIMS_IN_AUDIT_CHECK_TABLE ADD CHECKCONCLUSION varchar2(36);
|
|
CALL INSERTI18N('T_LIMS_IN_AUDIT_CHECK_TABLE.CHECKCONCLUSION', '检查结论', '检查结论', 'zh-CN', '检查结论');
|
|
CALL INSERTI18N('T_LIMS_IN_AUDIT_CHECK_TABLE.SUBFACTORCODE', '条款', '条款', 'zh-CN', '条款');
|
|
CALL INSERTI18N('T_LIMS_IN_AUDIT_CHECK_TABLE.FACTORCONTENT', '核查内容', '核查内容', 'zh-CN', '核查内容');
|
|
|
|
-- ----------------------------- 2022-10-20 add by wangyuwei--------------begin |