1350 lines
103 KiB
Plaintext
1350 lines
103 KiB
Plaintext
-- ----------------------------- 2022-08-31 add by lijiaxing--------------begin
|
|
|
|
-- 建表语句
|
|
CREATE TABLE T_LIMS_EQUIPT_CHANNEL(
|
|
ID NUMBER NOT NULL,
|
|
CREATEDBYID VARCHAR2(36) NULL,
|
|
CREATEDBYNAME VARCHAR2(60) NULL,
|
|
CREATEDTIME DATE NULL,
|
|
CREATEDBYORGID VARCHAR2(36) NULL,
|
|
CREATEDBYORGNAME VARCHAR2(270) NULL,
|
|
EQUIPTID NUMBER NULL,
|
|
UNITCODE VARCHAR2(36) NULL,
|
|
CHANNELCODE VARCHAR2(36) NULL,
|
|
CHANNELNAME VARCHAR2(36) NULL,
|
|
CHANNELSTATUS VARCHAR2(36) NULL,
|
|
REMARKS VARCHAR2(360) NULL
|
|
);
|
|
COMMENT ON TABLE T_LIMS_EQUIPT_CHANNEL IS '设备通道表';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_CHANNEL.ID IS '主键';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_CHANNEL.CREATEDBYID IS '制单人编码';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_CHANNEL.CREATEDBYNAME IS '制单人名称';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_CHANNEL.CREATEDTIME IS '制单时间';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_CHANNEL.CREATEDBYORGID IS '制单人单位编码';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_CHANNEL.CREATEDBYORGNAME IS '制单人单位名称';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_CHANNEL.EQUIPTID IS '设备ID';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_CHANNEL.UNITCODE IS '单元编号';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_CHANNEL.CHANNELCODE IS '通道编号';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_CHANNEL.CHANNELNAME IS '通道名称';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_CHANNEL.CHANNELSTATUS IS '通道状态';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_CHANNEL.REMARKS IS '备注';
|
|
|
|
ALTER TABLE T_LIMS_EQUIPT_CHANNEL ADD CONSTRAINT PK_LIMS_EQUIPT_CHANNEL PRIMARY KEY (ID);
|
|
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_CHANNEL.SERVICE_NAME', '设备通道表', '设备通道表', 'zh-CN', '设备通道表');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_CHANNEL.ID', '设备通道表的主键', '主键', 'zh-CN', '主键');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_CHANNEL.CREATEDBYID', '设备通道表的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_CHANNEL.CREATEDBYNAME', '设备通道表的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_CHANNEL.CREATEDTIME', '设备通道表的制单时间', '制单时间', 'zh-CN', '制单时间');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_CHANNEL.CREATEDBYORGID', '设备通道表的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_CHANNEL.CREATEDBYORGNAME', '设备通道表的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_CHANNEL.EQUIPTID', '设备通道表的设备ID', '设备ID', 'zh-CN', '设备ID');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_CHANNEL.UNITCODE', '设备通道表的单元编号', '单元编号', 'zh-CN', '单元编号');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_CHANNEL.CHANNELCODE', '设备通道表的通道编号', '通道编号', 'zh-CN', '通道编号');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_CHANNEL.CHANNELNAME', '设备通道表的通道名称', '通道名称', 'zh-CN', '通道名称');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_CHANNEL.CHANNELSTATUS', '设备通道表的通道状态', '通道状态', 'zh-CN', '通道状态');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_CHANNEL.REMARKS', '设备通道表的备注', '备注', 'zh-CN', '备注');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.CHANNELS.MODAL.ADD', '新增', '新增', 'zh-CN', '新增');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.CHANNELS.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.CHANNELS.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.CHANNELS.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.CHANNELS.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框');
|
|
|
|
|
|
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
|
|
VALUES ('T_LIMS_EQUIPT_CHANNEL', '0', '0');
|
|
|
|
|
|
COMMIT;
|
|
|
|
-- ----------------------------- 2022-08-31 add by lijiaxing------------end
|
|
-- ----------------------------- 2022-09-01 add by lijiaxing--------------begin
|
|
|
|
-- 建表语句
|
|
CREATE TABLE T_LIMS_EQUIPT_AUXILIARY(
|
|
ID NUMBER NOT NULL,
|
|
CREATEDBYID VARCHAR2(36) NULL,
|
|
CREATEDBYNAME VARCHAR2(60) NULL,
|
|
CREATEDTIME DATE NULL,
|
|
CREATEDBYORGID VARCHAR2(36) NULL,
|
|
CREATEDBYORGNAME VARCHAR2(270) NULL,
|
|
EQUIPTID NUMBER NULL,
|
|
AUXILIARYID NUMBER NULL,
|
|
REMARKS VARCHAR2(360) NULL
|
|
);
|
|
COMMENT ON TABLE T_LIMS_EQUIPT_AUXILIARY IS '辅助设备表';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_AUXILIARY.ID IS '主键';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_AUXILIARY.CREATEDBYID IS '制单人编码';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_AUXILIARY.CREATEDBYNAME IS '制单人名称';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_AUXILIARY.CREATEDTIME IS '制单时间';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_AUXILIARY.CREATEDBYORGID IS '制单人单位编码';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_AUXILIARY.CREATEDBYORGNAME IS '制单人单位名称';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_AUXILIARY.EQUIPTID IS '设备ID';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_AUXILIARY.AUXILIARYID IS '辅助设备ID';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_AUXILIARY.REMARKS IS '备注';
|
|
|
|
ALTER TABLE T_LIMS_EQUIPT_AUXILIARY ADD CONSTRAINT PK_LIMS_EQUIPT_AUXILIARY PRIMARY KEY (ID);
|
|
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_AUXILIARY.SERVICE_NAME', '辅助设备表', '辅助设备表', 'zh-CN', '辅助设备表');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_AUXILIARY.ID', '辅助设备表的主键', '主键', 'zh-CN', '主键');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_AUXILIARY.CREATEDBYID', '辅助设备表的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_AUXILIARY.CREATEDBYNAME', '辅助设备表的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_AUXILIARY.CREATEDTIME', '辅助设备表的制单时间', '制单时间', 'zh-CN', '制单时间');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_AUXILIARY.CREATEDBYORGID', '辅助设备表的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_AUXILIARY.CREATEDBYORGNAME', '辅助设备表的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_AUXILIARY.EQUIPTID', '辅助设备表的设备ID', '设备ID', 'zh-CN', '设备ID');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_AUXILIARY.AUXILIARYID', '辅助设备表的辅助设备ID', '辅助设备ID', 'zh-CN', '辅助设备ID');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_AUXILIARY.REMARKS', '辅助设备表的备注', '备注', 'zh-CN', '备注');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.AUXILIARYS.MODAL.ADD', '新增', '新增', 'zh-CN', '新增');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.AUXILIARYS.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.AUXILIARYS.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.AUXILIARYS.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.AUXILIARYS.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框');
|
|
|
|
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
|
|
VALUES ('T_LIMS_EQUIPT_AUXILIARY', '0', '0');
|
|
|
|
|
|
COMMIT;
|
|
|
|
-- ----------------------------- 2022-09-01 add by lijiaxing------------end
|
|
-- ----------------------------- 2022-09-01 add by lijiaxing--------------begin
|
|
|
|
-- 建表语句
|
|
CREATE TABLE T_LIMS_EQUIPT_EVENT(
|
|
ID NUMBER NOT NULL,
|
|
CREATEDBYID VARCHAR2(36) NULL,
|
|
CREATEDBYNAME VARCHAR2(60) NULL,
|
|
CREATEDTIME DATE NULL,
|
|
CREATEDBYORGID VARCHAR2(36) NULL,
|
|
CREATEDBYORGNAME VARCHAR2(270) NULL,
|
|
EQUIPTID NUMBER NULL,
|
|
EVENTTYPE VARCHAR2(36) NULL,
|
|
EVENTFREQUENCY VARCHAR2(36) NULL,
|
|
EVENTDESC VARCHAR2(360) NULL,
|
|
PLANDATE DATE NULL,
|
|
REMINDDAYS NUMBER NULL,
|
|
REMARKS VARCHAR2(360) NULL
|
|
);
|
|
COMMENT ON TABLE T_LIMS_EQUIPT_EVENT IS '设备事件表';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_EVENT.ID IS '主键';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_EVENT.CREATEDBYID IS '制单人编码';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_EVENT.CREATEDBYNAME IS '制单人名称';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_EVENT.CREATEDTIME IS '制单时间';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_EVENT.CREATEDBYORGID IS '制单人单位编码';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_EVENT.CREATEDBYORGNAME IS '制单人单位名称';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_EVENT.EQUIPTID IS '设备ID';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_EVENT.EVENTTYPE IS '事件类型';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_EVENT.EVENTFREQUENCY IS '事件频率';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_EVENT.EVENTDESC IS '事件描述';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_EVENT.PLANDATE IS '计划日期';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_EVENT.REMINDDAYS IS '提醒天数';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_EVENT.REMARKS IS '备注';
|
|
|
|
ALTER TABLE T_LIMS_EQUIPT_EVENT ADD CONSTRAINT PK_LIMS_EQUIPT_EVENT PRIMARY KEY (ID);
|
|
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_EVENT.SERVICE_NAME', '设备事件表', '设备事件表', 'zh-CN', '设备事件表');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_EVENT.ID', '设备事件表的主键', '主键', 'zh-CN', '主键');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_EVENT.CREATEDBYID', '设备事件表的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_EVENT.CREATEDBYNAME', '设备事件表的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_EVENT.CREATEDTIME', '设备事件表的制单时间', '制单时间', 'zh-CN', '制单时间');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_EVENT.CREATEDBYORGID', '设备事件表的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_EVENT.CREATEDBYORGNAME', '设备事件表的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_EVENT.EQUIPTID', '设备事件表的设备ID', '设备ID', 'zh-CN', '设备ID');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_EVENT.EVENTTYPE', '设备事件表的事件类型', '事件类型', 'zh-CN', '事件类型');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_EVENT.EVENTFREQUENCY', '设备事件表的事件频率', '事件频率', 'zh-CN', '事件频率');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_EVENT.EVENTDESC', '设备事件表的事件描述', '事件描述', 'zh-CN', '事件描述');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_EVENT.PLANDATE', '设备事件表的计划日期', '计划日期', 'zh-CN', '计划日期');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_EVENT.REMINDDAYS', '设备事件表的提醒天数', '提醒天数', 'zh-CN', '提醒天数');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_EVENT.REMARKS', '设备事件表的备注', '备注', 'zh-CN', '备注');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.EVENTS.MODAL.ADD', '新增', '新增', 'zh-CN', '新增');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.EVENTS.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.EVENTS.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.EVENTS.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.EVENTS.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框');
|
|
|
|
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
|
|
VALUES ('T_LIMS_EQUIPT_EVENT', '0', '0');
|
|
|
|
|
|
COMMIT;
|
|
|
|
-- ----------------------------- 2022-09-01 add by lijiaxing------------end
|
|
-- ----------------------------- 2022-09-01 add by lijiaxing--------------begin
|
|
|
|
-- 建表语句
|
|
CREATE TABLE T_LIMS_EQUIPT_EVENT_RECORD(
|
|
ID NUMBER NOT NULL,
|
|
CREATEDBYID VARCHAR2(36) NULL,
|
|
CREATEDBYNAME VARCHAR2(60) NULL,
|
|
CREATEDTIME DATE NULL,
|
|
CREATEDBYORGID VARCHAR2(36) NULL,
|
|
CREATEDBYORGNAME VARCHAR2(270) NULL,
|
|
EVENTID NUMBER NULL,
|
|
EVENTCONTENT VARCHAR2(360) NULL,
|
|
RECORDDATE DATE NULL,
|
|
RECORDERID VARCHAR2(36) NULL,
|
|
RECORDER VARCHAR2(60) NULL,
|
|
REMARKS VARCHAR2(360) NULL
|
|
);
|
|
COMMENT ON TABLE T_LIMS_EQUIPT_EVENT_RECORD IS '设备事件记录表';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_EVENT_RECORD.ID IS '主键';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_EVENT_RECORD.CREATEDBYID IS '制单人编码';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_EVENT_RECORD.CREATEDBYNAME IS '制单人名称';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_EVENT_RECORD.CREATEDTIME IS '制单时间';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_EVENT_RECORD.CREATEDBYORGID IS '制单人单位编码';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_EVENT_RECORD.CREATEDBYORGNAME IS '制单人单位名称';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_EVENT_RECORD.EVENTID IS '事件ID';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_EVENT_RECORD.EVENTCONTENT IS '事件内容';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_EVENT_RECORD.RECORDDATE IS '记录时间';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_EVENT_RECORD.RECORDERID IS '记录人ID';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_EVENT_RECORD.RECORDER IS '记录人';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_EVENT_RECORD.REMARKS IS '备注';
|
|
|
|
ALTER TABLE T_LIMS_EQUIPT_EVENT_RECORD ADD CONSTRAINT PK_LIMS_EQUIPT_EVENT_RECORD PRIMARY KEY (ID);
|
|
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_EVENT_RECORD.SERVICE_NAME', '设备事件记录表', '设备事件记录表', 'zh-CN', '设备事件记录表');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_EVENT_RECORD.ID', '设备事件记录表的主键', '主键', 'zh-CN', '主键');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_EVENT_RECORD.CREATEDBYID', '设备事件记录表的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_EVENT_RECORD.CREATEDBYNAME', '设备事件记录表的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_EVENT_RECORD.CREATEDTIME', '设备事件记录表的制单时间', '制单时间', 'zh-CN', '制单时间');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_EVENT_RECORD.CREATEDBYORGID', '设备事件记录表的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_EVENT_RECORD.CREATEDBYORGNAME', '设备事件记录表的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_EVENT_RECORD.EVENTID', '设备事件记录表的事件ID', '事件ID', 'zh-CN', '事件ID');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_EVENT_RECORD.EVENTCONTENT', '设备事件记录表的事件内容', '事件内容', 'zh-CN', '事件内容');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_EVENT_RECORD.RECORDDATE', '设备事件记录表的记录时间', '记录时间', 'zh-CN', '记录时间');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_EVENT_RECORD.RECORDERID', '设备事件记录表的记录人ID', '记录人ID', 'zh-CN', '记录人ID');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_EVENT_RECORD.RECORDER', '设备事件记录表的记录人', '记录人', 'zh-CN', '记录人');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_EVENT_RECORD.REMARKS', '设备事件记录表的备注', '备注', 'zh-CN', '备注');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.EVENTRECORDS.MODAL.ADD', '新增', '新增', 'zh-CN', '新增');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.EVENTRECORDS.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.EVENTRECORDS.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.EVENTRECORDS.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.EVENTRECORDS.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框');
|
|
|
|
|
|
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
|
|
VALUES ('T_LIMS_EQUIPT_EVENT_RECORD', '0', '0');
|
|
|
|
|
|
COMMIT;
|
|
|
|
-- ----------------------------- 2022-09-01 add by lijiaxing------------end
|
|
-- ----------------------------- 2022-09-01 add by lijiaxing--------------begin
|
|
|
|
-- 建表语句
|
|
CREATE TABLE T_LIMS_EQUIPT_MAINTAIN_PLAN(
|
|
ID NUMBER NOT NULL,
|
|
CREATEDBYID VARCHAR2(36) NULL,
|
|
CREATEDBYNAME VARCHAR2(60) NULL,
|
|
CREATEDTIME DATE NULL,
|
|
CREATEDBYORGID VARCHAR2(36) NULL,
|
|
CREATEDBYORGNAME VARCHAR2(270) NULL,
|
|
PROCESSSTATUS VARCHAR2(36) NULL,
|
|
EQUIPTID NUMBER NULL,
|
|
MAINTAINTYPE VARCHAR2(36) NULL,
|
|
MAINTAINFREQUENCY VARCHAR2(36) NULL,
|
|
MAINTAINDESC VARCHAR2(360) NULL,
|
|
PLANDATE DATE NULL,
|
|
REMINDDAYS NUMBER NULL,
|
|
REMARKS VARCHAR2(360) NULL
|
|
);
|
|
COMMENT ON TABLE T_LIMS_EQUIPT_MAINTAIN_PLAN IS '设备保养点检计划表';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_MAINTAIN_PLAN.ID IS '主键';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_MAINTAIN_PLAN.CREATEDBYID IS '制单人编码';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_MAINTAIN_PLAN.CREATEDBYNAME IS '制单人名称';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_MAINTAIN_PLAN.CREATEDTIME IS '制单时间';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_MAINTAIN_PLAN.CREATEDBYORGID IS '制单人单位编码';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_MAINTAIN_PLAN.CREATEDBYORGNAME IS '制单人单位名称';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_MAINTAIN_PLAN.PROCESSSTATUS IS '流程状态';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_MAINTAIN_PLAN.EQUIPTID IS '设备ID';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_MAINTAIN_PLAN.MAINTAINTYPE IS '类型';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_MAINTAIN_PLAN.MAINTAINFREQUENCY IS '保养/点检频率';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_MAINTAIN_PLAN.MAINTAINDESC IS '保养/点检描述';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_MAINTAIN_PLAN.PLANDATE IS '计划保养/点检日期';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_MAINTAIN_PLAN.REMINDDAYS IS '提醒天数';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_MAINTAIN_PLAN.REMARKS IS '备注';
|
|
|
|
ALTER TABLE T_LIMS_EQUIPT_MAINTAIN_PLAN ADD CONSTRAINT PK_LIMS_EQUIPT_MAINTAIN_PLAN PRIMARY KEY (ID);
|
|
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_MAINTAIN_PLAN.SERVICE_NAME', '设备保养点检计划表', '设备保养点检计划表', 'zh-CN', '设备保养点检计划表');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_MAINTAIN_PLAN.ID', '设备保养点检计划表的主键', '主键', 'zh-CN', '主键');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_MAINTAIN_PLAN.CREATEDBYID', '设备保养点检计划表的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_MAINTAIN_PLAN.CREATEDBYNAME', '设备保养点检计划表的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_MAINTAIN_PLAN.CREATEDTIME', '设备保养点检计划表的制单时间', '制单时间', 'zh-CN', '制单时间');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_MAINTAIN_PLAN.CREATEDBYORGID', '设备保养点检计划表的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_MAINTAIN_PLAN.CREATEDBYORGNAME', '设备保养点检计划表的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_MAINTAIN_PLAN.PROCESSSTATUS', '设备保养点检计划表的流程状态', '流程状态', 'zh-CN', '流程状态');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_MAINTAIN_PLAN.EQUIPTID', '设备保养点检计划表的设备ID', '设备ID', 'zh-CN', '设备ID');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_MAINTAIN_PLAN.MAINTAINTYPE', '设备保养点检计划表的类型', '类型', 'zh-CN', '类型');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_MAINTAIN_PLAN.MAINTAINFREQUENCY', '设备保养点检计划表的保养/点检频率', '保养/点检频率', 'zh-CN', '保养/点检频率');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_MAINTAIN_PLAN.MAINTAINDESC', '设备保养点检计划表的保养/点检描述', '保养/点检描述', 'zh-CN', '保养/点检描述');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_MAINTAIN_PLAN.PLANDATE', '设备保养点检计划表的计划保养/点检日期', '计划保养/点检日期', 'zh-CN', '计划保养/点检日期');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_MAINTAIN_PLAN.REMINDDAYS', '设备保养点检计划表的提醒天数', '提醒天数', 'zh-CN', '提醒天数');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_MAINTAIN_PLAN.REMARKS', '设备保养点检计划表的备注', '备注', 'zh-CN', '备注');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.MAINTAINS.MODAL.ADD', '新增', '新增', 'zh-CN', '新增');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.MAINTAINS.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.MAINTAINS.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.MAINTAINS.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.MAINTAINS.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框');
|
|
|
|
|
|
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
|
|
VALUES ('T_LIMS_EQUIPT_MAINTAIN_PLAN', '1', '0');
|
|
|
|
INSERT INTO T_CORE_MENU_EXT (ID, SERVICENAME, TABLENAME, TYPE, ENABLE)
|
|
VALUES ('910301', '设备保养点检计划', 'T_LIMS_EQUIPT_MAINTAIN_PLAN', 'audit_def', '1');
|
|
|
|
|
|
COMMIT;
|
|
|
|
-- ----------------------------- 2022-09-01 add by lijiaxing------------end
|
|
-- ----------------------------- 2022-09-01 add by lijiaxing--------------begin
|
|
|
|
-- 建表语句
|
|
CREATE TABLE T_LIMS_EQUIPT_MAINTAIN_ITEM(
|
|
ID NUMBER NOT NULL,
|
|
CREATEDBYID VARCHAR2(36) NULL,
|
|
CREATEDBYNAME VARCHAR2(60) NULL,
|
|
CREATEDTIME DATE NULL,
|
|
CREATEDBYORGID VARCHAR2(36) NULL,
|
|
CREATEDBYORGNAME VARCHAR2(270) NULL,
|
|
MAINTAINID NUMBER NULL,
|
|
MAINTAINSPOTCHECKID NUMBER NULL,
|
|
MAINTAINTYPE VARCHAR2(36) NULL,
|
|
MAINTAINITEM VARCHAR2(120) NULL,
|
|
MAINTAINMETHOD VARCHAR2(360) NULL,
|
|
REMARKS VARCHAR2(360) NULL
|
|
);
|
|
COMMENT ON TABLE T_LIMS_EQUIPT_MAINTAIN_ITEM IS '设备保养点检项目表';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_MAINTAIN_ITEM.ID IS '主键';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_MAINTAIN_ITEM.CREATEDBYID IS '制单人编码';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_MAINTAIN_ITEM.CREATEDBYNAME IS '制单人名称';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_MAINTAIN_ITEM.CREATEDTIME IS '制单时间';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_MAINTAIN_ITEM.CREATEDBYORGID IS '制单人单位编码';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_MAINTAIN_ITEM.CREATEDBYORGNAME IS '制单人单位名称';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_MAINTAIN_ITEM.MAINTAINID IS '保养点检计划ID';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_MAINTAIN_ITEM.MAINTAINSPOTCHECKID IS '保养点检项目ID';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_MAINTAIN_ITEM.MAINTAINTYPE IS '项目类型';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_MAINTAIN_ITEM.MAINTAINITEM IS '保养/点检项目';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_MAINTAIN_ITEM.MAINTAINMETHOD IS '保养/点检方法';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_MAINTAIN_ITEM.REMARKS IS '备注';
|
|
|
|
ALTER TABLE T_LIMS_EQUIPT_MAINTAIN_ITEM ADD CONSTRAINT PK_LIMS_EQUIPT_MAINTAIN_ITEM PRIMARY KEY (ID);
|
|
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_MAINTAIN_ITEM.SERVICE_NAME', '设备保养点检项目表', '设备保养点检项目表', 'zh-CN', '设备保养点检项目表');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_MAINTAIN_ITEM.ID', '设备保养点检项目表的主键', '主键', 'zh-CN', '主键');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_MAINTAIN_ITEM.CREATEDBYID', '设备保养点检项目表的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_MAINTAIN_ITEM.CREATEDBYNAME', '设备保养点检项目表的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_MAINTAIN_ITEM.CREATEDTIME', '设备保养点检项目表的制单时间', '制单时间', 'zh-CN', '制单时间');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_MAINTAIN_ITEM.CREATEDBYORGID', '设备保养点检项目表的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_MAINTAIN_ITEM.CREATEDBYORGNAME', '设备保养点检项目表的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_MAINTAIN_ITEM.MAINTAINID', '设备保养点检项目表的保养点检计划ID', '保养点检计划ID', 'zh-CN', '保养点检计划ID');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_MAINTAIN_ITEM.MAINTAINSPOTCHECKID', '设备保养点检项目表的保养点检项目ID', '保养点检项目ID', 'zh-CN', '保养点检项目ID');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_MAINTAIN_ITEM.MAINTAINTYPE', '设备保养点检项目表的项目类型', '项目类型', 'zh-CN', '项目类型');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_MAINTAIN_ITEM.MAINTAINITEM', '设备保养点检项目表的保养/点检项目', '保养/点检项目', 'zh-CN', '保养/点检项目');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_MAINTAIN_ITEM.MAINTAINMETHOD', '设备保养点检项目表的保养/点检方法', '保养/点检方法', 'zh-CN', '保养/点检方法');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_MAINTAIN_ITEM.REMARKS', '设备保养点检项目表的备注', '备注', 'zh-CN', '备注');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.MAINTAINITEMS.MODAL.ADD', '新增', '新增', 'zh-CN', '新增');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.MAINTAINITEMS.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.MAINTAINITEMS.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.MAINTAINITEMS.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.MAINTAINITEMS.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框');
|
|
|
|
|
|
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
|
|
VALUES ('T_LIMS_EQUIPT_MAINTAIN_ITEM', '0', '0');
|
|
|
|
|
|
COMMIT;
|
|
|
|
-- ----------------------------- 2022-09-01 add by lijiaxing------------end
|
|
|
|
-- ----------------------------- 2022-09-01 add by lijiaxing--------------begin
|
|
|
|
-- 建表语句
|
|
CREATE TABLE T_LIMS_EQUIPT_MAINTAIN_RECORD(
|
|
ID NUMBER NOT NULL,
|
|
CREATEDBYID VARCHAR2(36) NULL,
|
|
CREATEDBYNAME VARCHAR2(60) NULL,
|
|
CREATEDTIME DATE NULL,
|
|
CREATEDBYORGID VARCHAR2(36) NULL,
|
|
CREATEDBYORGNAME VARCHAR2(270) NULL,
|
|
EQUIPTID NUMBER NULL,
|
|
MAINTAINID NUMBER NULL,
|
|
MAINTAINITEMID NUMBER NULL,
|
|
MAINTAINTYPE VARCHAR2(36) NULL,
|
|
MAINTAINITEM VARCHAR2(120) NULL,
|
|
MAINTAINMETHOD VARCHAR2(360) NULL,
|
|
MAINTAINRESULT VARCHAR2(36) NULL,
|
|
MAINTAINRECORD VARCHAR2(360) NULL,
|
|
MAINTAINDATE DATE NULL,
|
|
RECORDERID VARCHAR2(36) NULL,
|
|
RECORDER VARCHAR2(60) NULL,
|
|
REMARKS VARCHAR2(360) NULL
|
|
);
|
|
COMMENT ON TABLE T_LIMS_EQUIPT_MAINTAIN_RECORD IS '设备保养点检记录表';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_MAINTAIN_RECORD.ID IS '主键';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_MAINTAIN_RECORD.CREATEDBYID IS '制单人编码';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_MAINTAIN_RECORD.CREATEDBYNAME IS '制单人名称';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_MAINTAIN_RECORD.CREATEDTIME IS '制单时间';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_MAINTAIN_RECORD.CREATEDBYORGID IS '制单人单位编码';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_MAINTAIN_RECORD.CREATEDBYORGNAME IS '制单人单位名称';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_MAINTAIN_RECORD.EQUIPTID IS '设备ID';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_MAINTAIN_RECORD.MAINTAINID IS '保养点检计划ID';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_MAINTAIN_RECORD.MAINTAINITEMID IS '保养点检项目ID';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_MAINTAIN_RECORD.MAINTAINTYPE IS '项目类型';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_MAINTAIN_RECORD.MAINTAINITEM IS '保养/点检项目';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_MAINTAIN_RECORD.MAINTAINMETHOD IS '保养/点检方法';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_MAINTAIN_RECORD.MAINTAINRESULT IS '保养/点检结果';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_MAINTAIN_RECORD.MAINTAINRECORD IS '保养/点检记录';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_MAINTAIN_RECORD.MAINTAINDATE IS '保养/点检时间';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_MAINTAIN_RECORD.RECORDERID IS '记录人ID';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_MAINTAIN_RECORD.RECORDER IS '记录人';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_MAINTAIN_RECORD.REMARKS IS '备注';
|
|
|
|
ALTER TABLE T_LIMS_EQUIPT_MAINTAIN_RECORD ADD CONSTRAINT PK_LIMS_EQUIPT_MAINTAIN_RECORD PRIMARY KEY (ID);
|
|
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_MAINTAIN_RECORD.SERVICE_NAME', '设备保养点检记录表', '设备保养点检记录表', 'zh-CN', '设备保养点检记录表');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_MAINTAIN_RECORD.ID', '设备保养点检记录表的主键', '主键', 'zh-CN', '主键');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_MAINTAIN_RECORD.CREATEDBYID', '设备保养点检记录表的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_MAINTAIN_RECORD.CREATEDBYNAME', '设备保养点检记录表的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_MAINTAIN_RECORD.CREATEDTIME', '设备保养点检记录表的制单时间', '制单时间', 'zh-CN', '制单时间');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_MAINTAIN_RECORD.CREATEDBYORGID', '设备保养点检记录表的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_MAINTAIN_RECORD.CREATEDBYORGNAME', '设备保养点检记录表的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_MAINTAIN_RECORD.EQUIPTID', '设备保养点检记录表的设备ID', '设备ID', 'zh-CN', '设备ID');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_MAINTAIN_RECORD.MAINTAINID', '设备保养点检记录表的保养点检计划ID', '保养点检计划ID', 'zh-CN', '保养点检计划ID');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_MAINTAIN_RECORD.MAINTAINTYPE', '设备保养点检记录表的项目类型', '项目类型', 'zh-CN', '项目类型');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_MAINTAIN_RECORD.MAINTAINITEM', '设备保养点检记录表的保养/点检项目', '保养/点检项目', 'zh-CN', '保养/点检项目');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_MAINTAIN_RECORD.MAINTAINMETHOD', '设备保养点检记录表的保养/点检方法', '保养/点检方法', 'zh-CN', '保养/点检方法');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_MAINTAIN_RECORD.MAINTAINRESULT', '设备保养点检记录表的保养/点检结果', '保养/点检结果', 'zh-CN', '保养/点检结果');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_MAINTAIN_RECORD.MAINTAINRECORD', '设备保养点检记录表的保养/点检记录', '保养/点检记录', 'zh-CN', '保养/点检记录');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_MAINTAIN_RECORD.MAINTAINDATE', '设备保养点检记录表的保养/点检时间', '保养/点检时间', 'zh-CN', '保养/点检时间');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_MAINTAIN_RECORD.RECORDERID', '设备保养点检记录表的记录人ID', '记录人ID', 'zh-CN', '记录人ID');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_MAINTAIN_RECORD.RECORDER', '设备保养点检记录表的记录人', '记录人', 'zh-CN', '记录人');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_MAINTAIN_RECORD.REMARKS', '设备保养点检记录表的备注', '备注', 'zh-CN', '备注');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.MAINTAINRECORDS.MODAL.ADD', '新增', '新增', 'zh-CN', '新增');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.MAINTAINRECORDS.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.MAINTAINRECORDS.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.MAINTAINRECORDS.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.MAINTAINRECORDS.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框');
|
|
|
|
|
|
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
|
|
VALUES ('T_LIMS_EQUIPT_MAINTAIN_RECORD', '0', '0');
|
|
|
|
|
|
COMMIT;
|
|
|
|
-- ----------------------------- 2022-09-01 add by lijiaxing------------end
|
|
-- ----------------------------- 2022-09-01 add by lijiaxing--------------begin
|
|
|
|
-- 建表语句
|
|
CREATE TABLE T_LIMS_EQUIPT_REPAIR(
|
|
ID NUMBER NOT NULL,
|
|
CREATEDBYID VARCHAR2(36) NULL,
|
|
CREATEDBYNAME VARCHAR2(60) NULL,
|
|
CREATEDTIME DATE NULL,
|
|
CREATEDBYORGID VARCHAR2(36) NULL,
|
|
CREATEDBYORGNAME VARCHAR2(270) NULL,
|
|
PROCESSSTATUS VARCHAR2(36) NULL,
|
|
EQUIPTID NUMBER NULL,
|
|
APPLICANTID VARCHAR2(36) NULL,
|
|
APPLICANT VARCHAR2(60) NULL,
|
|
APPLYDATE DATE NULL,
|
|
APPLYDEPTID VARCHAR2(36) NULL,
|
|
APPLYDEPT VARCHAR2(270) NULL,
|
|
FAULTDATE DATE NULL,
|
|
FAULTDESC VARCHAR2(360) NULL,
|
|
EXPECTDATE DATE NULL,
|
|
FAULTREASON VARCHAR2(360) NULL,
|
|
REPAIRMEASURE VARCHAR2(360) NULL,
|
|
FINISHDATE DATE NULL,
|
|
STOPHOURS NUMBER(8,2) NULL,
|
|
REPAIRPERSONID VARCHAR2(36) NULL,
|
|
REPAIRPERSON VARCHAR2(60) NULL,
|
|
REPAIRCOST NUMBER(8,2) NULL,
|
|
REMARKS VARCHAR2(360) NULL
|
|
);
|
|
COMMENT ON TABLE T_LIMS_EQUIPT_REPAIR IS '设备维修表';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_REPAIR.ID IS '主键';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_REPAIR.CREATEDBYID IS '制单人编码';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_REPAIR.CREATEDBYNAME IS '制单人名称';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_REPAIR.CREATEDTIME IS '制单时间';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_REPAIR.CREATEDBYORGID IS '制单人单位编码';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_REPAIR.CREATEDBYORGNAME IS '制单人单位名称';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_REPAIR.PROCESSSTATUS IS '流程状态';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_REPAIR.EQUIPTID IS '设备ID';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_REPAIR.APPLICANTID IS '申请人ID';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_REPAIR.APPLICANT IS '申请人';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_REPAIR.APPLYDATE IS '申请时间';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_REPAIR.APPLYDEPTID IS '申请部门ID';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_REPAIR.APPLYDEPT IS '申请部门';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_REPAIR.FAULTDATE IS '故障发生时间';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_REPAIR.FAULTDESC IS '故障描述';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_REPAIR.EXPECTDATE IS '期望修复日期';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_REPAIR.FAULTREASON IS '故障原因分析';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_REPAIR.REPAIRMEASURE IS '故障维修措施';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_REPAIR.FINISHDATE IS '完成时间';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_REPAIR.STOPHOURS IS '停机时长';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_REPAIR.REPAIRPERSONID IS '维修人员ID';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_REPAIR.REPAIRPERSON IS '维修人员';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_REPAIR.REPAIRCOST IS '维修费用';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_REPAIR.REMARKS IS '备注';
|
|
|
|
ALTER TABLE T_LIMS_EQUIPT_REPAIR ADD CONSTRAINT PK_LIMS_EQUIPT_REPAIR PRIMARY KEY (ID);
|
|
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_REPAIR.SERVICE_NAME', '设备维修表', '设备维修表', 'zh-CN', '设备维修表');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_REPAIR.ID', '设备维修表的主键', '主键', 'zh-CN', '主键');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_REPAIR.CREATEDBYID', '设备维修表的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_REPAIR.CREATEDBYNAME', '设备维修表的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_REPAIR.CREATEDTIME', '设备维修表的制单时间', '制单时间', 'zh-CN', '制单时间');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_REPAIR.CREATEDBYORGID', '设备维修表的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_REPAIR.CREATEDBYORGNAME', '设备维修表的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_REPAIR.PROCESSSTATUS', '设备维修表的流程状态', '流程状态', 'zh-CN', '流程状态');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_REPAIR.EQUIPTID', '设备维修表的设备ID', '设备ID', 'zh-CN', '设备ID');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_REPAIR.APPLICANTID', '设备维修表的申请人ID', '申请人ID', 'zh-CN', '申请人ID');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_REPAIR.APPLICANT', '设备维修表的申请人', '申请人', 'zh-CN', '申请人');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_REPAIR.APPLYDATE', '设备维修表的申请时间', '申请时间', 'zh-CN', '申请时间');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_REPAIR.APPLYDEPTID', '设备维修表的申请部门ID', '申请部门ID', 'zh-CN', '申请部门ID');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_REPAIR.APPLYDEPT', '设备维修表的申请部门', '申请部门', 'zh-CN', '申请部门');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_REPAIR.FAULTDATE', '设备维修表的故障发生时间', '故障发生时间', 'zh-CN', '故障发生时间');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_REPAIR.FAULTDESC', '设备维修表的故障描述', '故障描述', 'zh-CN', '故障描述');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_REPAIR.EXPECTDATE', '设备维修表的期望修复日期', '期望修复日期', 'zh-CN', '期望修复日期');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_REPAIR.FAULTREASON', '设备维修表的故障原因分析', '故障原因分析', 'zh-CN', '故障原因分析');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_REPAIR.REPAIRMEASURE', '设备维修表的故障维修措施', '故障维修措施', 'zh-CN', '故障维修措施');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_REPAIR.FINISHDATE', '设备维修表的完成时间', '完成时间', 'zh-CN', '完成时间');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_REPAIR.STOPHOURS', '设备维修表的停机时长', '停机时长', 'zh-CN', '停机时长');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_REPAIR.REPAIRPERSONID', '设备维修表的维修人员ID', '维修人员ID', 'zh-CN', '维修人员ID');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_REPAIR.REPAIRPERSON', '设备维修表的维修人员', '维修人员', 'zh-CN', '维修人员');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_REPAIR.REPAIRCOST', '设备维修表的维修费用', '维修费用', 'zh-CN', '维修费用');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_REPAIR.REMARKS', '设备维修表的备注', '备注', 'zh-CN', '备注');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.REPAIRS.MODAL.ADD', '新增', '新增', 'zh-CN', '新增');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.REPAIRS.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.REPAIRS.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.REPAIRS.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.REPAIRS.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框');
|
|
|
|
|
|
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
|
|
VALUES ('T_LIMS_EQUIPT_REPAIR', '1', '0');
|
|
|
|
INSERT INTO T_CORE_MENU_EXT (ID, SERVICENAME, TABLENAME, TYPE, ENABLE)
|
|
VALUES ('910201', '设备维修','T_LIMS_EQUIPT_REPAIR', 'audit_def', '1');
|
|
|
|
|
|
COMMIT;
|
|
|
|
-- ----------------------------- 2022-09-01 add by lijiaxing------------end
|
|
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.EQUIPT.EQUIPTCHANNELPANEL', '设备通道', '设备通道', 'zh-CN', '设备通道');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.EQUIPT.AUXILIARYPANEL', '辅助设备', '辅助设备', 'zh-CN', '辅助设备');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.EQUIPT.EVENTPANEL', '设备事件', '设备事件', 'zh-CN', '设备事件');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.EQUIPT.EVENTRECORDPANEL', '设备事件记录', '设备事件记录', 'zh-CN', '设备事件记录');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.EQUIPT.REPAIRPANEL', '设备维修', '设备维修', 'zh-CN', '设备维修');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.EQUIPT.MAINTAINPANEL', '设备保养/点检', '设备保养/点检', 'zh-CN', '设备保养/点检');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.EQUIPT.MAINTAINITEMPANEL', '设备保养/点检项目', '设备保养/点检项目', 'zh-CN', '设备保养/点检项目');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.EQUIPT.MAINTAINRECORDPANEL', '设备保养/点检记录', '设备保养/点检记录', 'zh-CN', '设备保养/点检记录');
|
|
|
|
-- 创建菜单语句
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('910201', '设备维修管理', '', '20220825001', '910201', '008.svg', '设备维修管理');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('91020101', '设备维修申请', '/secure/basemodule/trm/equipt/equipt-repairs/page/edit-list', '910201', '1', '008.svg', '设备维修申请');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('91020102', '设备维修审核', '/secure/basemodule/trm/equipt/equipt-repairs/page/audit-list?bpmn_statusCode=Audit', '910201', '2', '008.svg', '设备维修审核');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('91020103', '设备维修实施', '/secure/basemodule/trm/equipt/equipt-repairs/page/audit-list?bpmn_statusCode=Implement', '910201', '3', '008.svg', '设备维修实施');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('91020104', '设备维修确认', '/secure/basemodule/trm/equipt/equipt-repairs/page/audit-list?bpmn_statusCode=Affirm', '910201', '4', '008.svg', '设备维修确认');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('91020105', '设备维修查询', '/secure/basemodule/trm/equipt/equipt-repairs/page/search-list', '910201', '5', '008.svg', '设备维修查询');
|
|
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('910202', '设备保养点检管理', '', '20220825001', '910202', '008.svg', '设备保养点检管理');
|
|
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('91020201', '设备保养点检记录', '/secure/basemodule/trm/equipt/equipt-maintain-plans/page/edit-list', '910202', '1', '008.svg', '设备保养点检记录');
|
|
|
|
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_AUXILIARY.EXT.EQUIPTNAME', '设备名称', '设备名称', 'zh-CN', '设备名称');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_AUXILIARY.EXT.EQUIPTCODE', '设备编号', '设备名称', 'zh-CN', '设备名称');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_REPAIR.EXT.EQUIPTNAME', '设备名称', '设备名称', 'zh-CN', '设备名称');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_REPAIR.EXT.EQUIPTCODE', '设备编号', '设备名称', 'zh-CN', '设备名称');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_MAINTAIN_PLAN.EXT.EQUIPTNAME', '设备名称', '设备名称', 'zh-CN', '设备名称');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_MAINTAIN_PLAN.EXT.EQUIPTCODE', '设备编号', '设备名称', 'zh-CN', '设备名称');
|
|
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_REPAIR.PANEL.EDIT', '申请', '申请', 'zh-CN', '申请');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_REPAIR.PANEL.EQUIPT', '设备', '设备', 'zh-CN', '设备');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_REPAIR.PANEL.IMPLEMENT', '实施', '实施', 'zh-CN', '实施');
|
|
|
|
INSERT INTO T_CORE_CODE_CATEGORY (ID, CODECATEGORYNAME, CODECLASSID)
|
|
VALUES ('equiptEventType', '事件类型', 'sys');
|
|
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
|
|
VALUES (202209021501, '检定', '1', 1, 'equiptEventType', 0, 'admin', '系统管理员', '0');
|
|
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
|
|
VALUES (202209021502, '校准', '2', 2, 'equiptEventType', 0, 'admin', '系统管理员', '0');
|
|
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
|
|
VALUES (202209021503, '期间核查', '3', 3, 'equiptEventType', 0, 'admin', '系统管理员', '0');
|
|
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
|
|
VALUES (202209021504, '量值溯源', '4', 4, 'equiptEventType', 0, 'admin', '系统管理员', '0');
|
|
|
|
INSERT INTO T_CORE_CODE_CATEGORY (ID, CODECATEGORYNAME, CODECLASSID)
|
|
VALUES ('equiptEventFrequency', '事件的频率', 'sys');
|
|
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
|
|
VALUES (202209021601, '次/年', '1', 1, 'equiptEventFrequency', 0, 'admin', '系统管理员', '0');
|
|
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
|
|
VALUES (202209021602, '次/半年', '2', 2, 'equiptEventFrequency', 0, 'admin', '系统管理员', '0');
|
|
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
|
|
VALUES (202209021603, '次/季度', '3', 3, 'equiptEventFrequency', 0, 'admin', '系统管理员', '0');
|
|
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
|
|
VALUES (202209021604, '次/月', '4', 4, 'equiptEventFrequency', 0, 'admin', '系统管理员', '0');
|
|
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
|
|
VALUES (202209021605, '次/周', '5', 5, 'equiptEventFrequency', 0, 'admin', '系统管理员', '0');
|
|
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
|
|
VALUES (202209021606, '次/天', '6', 6, 'equiptEventFrequency', 0, 'admin', '系统管理员', '0');
|
|
|
|
|
|
INSERT INTO T_CORE_CODE_CATEGORY (ID, CODECATEGORYNAME, CODECLASSID)
|
|
VALUES ('equiptMaintainFrequency', '点检的频率', 'sys');
|
|
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
|
|
VALUES (202209021701, '次/年', '1', 1, 'equiptMaintainFrequency', 0, 'admin', '系统管理员', '0');
|
|
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
|
|
VALUES (202209021702, '次/半年', '2', 2, 'equiptMaintainFrequency', 0, 'admin', '系统管理员', '0');
|
|
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
|
|
VALUES (202209021703, '次/季度', '3', 3, 'equiptMaintainFrequency', 0, 'admin', '系统管理员', '0');
|
|
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
|
|
VALUES (202209021704, '次/月', '4', 4, 'equiptMaintainFrequency', 0, 'admin', '系统管理员', '0');
|
|
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
|
|
VALUES (202209021705, '次/周', '5', 5, 'equiptMaintainFrequency', 0, 'admin', '系统管理员', '0');
|
|
INSERT INTO T_CORE_CODE (ID, CODENAME, CODE, ORDERNO, CODECATEGORYID, VERSION, CREATEDBYID, CREATEDBYNAME, LASTSUSPENDEDFLAG)
|
|
VALUES (202209021706, '次/天', '6', 6, 'equiptMaintainFrequency', 0, 'admin', '系统管理员', '0');
|
|
|
|
INSERT INTO T_CORE_ADMIN_CHOOSE_CONFIG (ID,NAME,TITLE,CATEGORY,URL,WIDTH) VALUES
|
|
(2022090116372,'保养点检项目库','保养点检项目库','maintainLibraryChoose','/secure/basemodule/basedata/equipt-maintain-librarys/page/choose-list','80%');
|
|
|
|
|
|
|
|
-- ----------------------------- 2022-09-14 add by wangyuwei@sunwaywolrd.com--------------begin
|
|
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('20220902013', '设备管理', NULL , '91', '7', '008.svg', '设备管理');
|
|
|
|
INSERT INTO t_core_menu (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('910203', '设备台账管理', '/secure/basemodule/trm/equipts/page/edit-list', '20220902013', 1, '024.svg','设备台账管理');
|
|
|
|
CALL INSERTI18N('T_LIMS_EQUIPT.MANUFACTURER', '制造商', '制造商', 'zh-CN', '制造商');
|
|
|
|
ALTER TABLE T_LIMS_EQUIPT ADD SPECIFICATION VARCHAR2(270);
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT.SPECIFICATION IS '规格';
|
|
CALL INSERTI18N('T_LIMS_EQUIPT.SPECIFICATION', '规格', '规格', 'zh-CN', '规格');
|
|
|
|
|
|
ALTER TABLE T_LIMS_EQUIPT ADD DISTINGUISHABILITY NUMBER;
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT.DISTINGUISHABILITY IS '分辨率';
|
|
CALL INSERTI18N('T_LIMS_EQUIPT.DISTINGUISHABILITY', '分辨率', '分辨率', 'zh-CN', '分辨率');
|
|
|
|
ALTER TABLE T_LIMS_EQUIPT ADD CORRECTMODE VARCHAR2(36);
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT.CORRECTMODE IS '校准方式';
|
|
CALL INSERTI18N('T_LIMS_EQUIPT.CORRECTMODE', '校准方式', '校准方式', 'zh-CN', '校准方式');
|
|
|
|
ALTER TABLE T_LIMS_EQUIPT ADD CORRECTPERIOD VARCHAR2(36);
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT.CORRECTPERIOD IS '校准周期';
|
|
CALL INSERTI18N('T_LIMS_EQUIPT.CORRECTPERIOD', '校准周期', '校准周期', 'zh-CN', '校准周期');
|
|
|
|
ALTER TABLE T_LIMS_EQUIPT ADD CORRECTINDATE DATE;
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT.CORRECTINDATE IS '校准有效期';
|
|
CALL INSERTI18N('T_LIMS_EQUIPT.CORRECTINDATE', '校准有效期', '校准有效期', 'zh-CN', '校准有效期');
|
|
|
|
ALTER TABLE T_LIMS_EQUIPT ADD PLANCORRECTTIME DATE;
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT.PLANCORRECTTIME IS '计划校准日期';
|
|
CALL INSERTI18N('T_LIMS_EQUIPT.PLANCORRECTTIME', '计划校准日期', '计划校准日期', 'zh-CN', '计划校准日期');
|
|
|
|
ALTER TABLE T_LIMS_EQUIPT ADD EQUIPTCHANNELAMOUNT NUMBER;
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT.EQUIPTCHANNELAMOUNT IS '设备通道数';
|
|
CALL INSERTI18N('T_LIMS_EQUIPT.EQUIPTCHANNELAMOUNT', '设备通道数', '设备通道数', 'zh-CN', '设备通道数');
|
|
|
|
ALTER TABLE T_LIMS_EQUIPT ADD BASEORG VARCHAR2(36);
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT.BASEORG IS '所属基地';
|
|
CALL INSERTI18N('T_LIMS_EQUIPT.BASEORG', '所属基地', '所属基地', 'zh-CN', '所属基地');
|
|
|
|
ALTER TABLE T_LIMS_EQUIPT ADD TESTGROUP VARCHAR2(36);
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT.TESTGROUP IS '检测组';
|
|
CALL INSERTI18N('T_LIMS_EQUIPT.TESTGROUP', '检测组', '检测组', 'zh-CN', '检测组');
|
|
|
|
ALTER TABLE T_LIMS_EQUIPT ADD BUYTIME DATE;
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT.BUYTIME IS '购进日期';
|
|
CALL INSERTI18N('T_LIMS_EQUIPT.BUYTIME', '购进日期', '购进日期', 'zh-CN', '购进日期');
|
|
|
|
ALTER TABLE T_LIMS_EQUIPT ADD EQUIPTCOST NUMBER(16,2);
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT.EQUIPTCOST IS '设备原值';
|
|
CALL INSERTI18N('T_LIMS_EQUIPT.EQUIPTCOST', '设备原值', '设备原值', 'zh-CN', '设备原值');
|
|
|
|
ALTER TABLE T_LIMS_EQUIPT ADD EQUIPTUSECOST NUMBER(16,2);
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT.EQUIPTUSECOST IS '设备使用成本';
|
|
CALL INSERTI18N('T_LIMS_EQUIPT.EQUIPTUSECOST', '设备使用成本', '设备使用成本', 'zh-CN', '设备使用成本');
|
|
|
|
ALTER TABLE T_LIMS_EQUIPT ADD IDNORMALRANGE NUMBER(16,2);
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT.IDNORMALRANGE IS '正常量程';
|
|
CALL INSERTI18N('T_LIMS_EQUIPT.IDNORMALRANGE', '正常量程', '正常量程', 'zh-CN', '正常量程');
|
|
|
|
ALTER TABLE T_LIMS_EQUIPT ADD LIMITREANGE NUMBER(16,2);
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT.LIMITREANGE IS '限制量程';
|
|
CALL INSERTI18N('T_LIMS_EQUIPT.LIMITREANGE', '限制量程', '限制量程', 'zh-CN', '限制量程');
|
|
|
|
ALTER TABLE T_LIMS_EQUIPT ADD ORGID VARCHAR2(36);
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT.ORGID IS '组织id';
|
|
CALL INSERTI18N('T_LIMS_EQUIPT.ORGID', '组织id', '组织id', 'zh-CN', '组织id');
|
|
|
|
ALTER TABLE T_LIMS_EQUIPT ADD ORGNAME VARCHAR2(270);
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT.ORGNAME IS '组织名称';
|
|
CALL INSERTI18N('T_LIMS_EQUIPT.ORGNAME', '组织名称', '组织名称', 'zh-CN', '组织名称');
|
|
|
|
ALTER TABLE T_LIMS_EQUIPT_CHANNEL ADD ORGID VARCHAR2(36);
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_CHANNEL.ORGID IS '组织id';
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_CHANNEL.ORGID', '组织id', '组织id', 'zh-CN', '组织id');
|
|
|
|
ALTER TABLE T_LIMS_EQUIPT_CHANNEL ADD ORGNAME VARCHAR2(270);
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_CHANNEL.ORGNAME IS '组织名称';
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_CHANNEL.ORGNAME', '组织名称', '组织名称', 'zh-CN', '组织名称');
|
|
|
|
|
|
ALTER TABLE T_LIMS_EQUIPT_AUXILIARY ADD ORGID VARCHAR2(36);
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_AUXILIARY.ORGID IS '组织id';
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_AUXILIARY.ORGID', '组织id', '组织id', 'zh-CN', '组织id');
|
|
|
|
ALTER TABLE T_LIMS_EQUIPT_AUXILIARY ADD ORGNAME VARCHAR2(270);
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_AUXILIARY.ORGNAME IS '组织名称';
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_AUXILIARY.ORGNAME', '组织名称', '组织名称', 'zh-CN', '组织名称');
|
|
|
|
CALL INSERTI18N('BASEMODULE.BASEDATA.EQUIPT.BASE.TNFO', '基础信息', '基础信息', 'zh-CN', '基础信息');
|
|
CALL INSERTI18N('BASEMODULE.BASEDATA.EQUIPT.CHANNEL', '设备通道', '设备通道', 'zh-CN', '设备通道');
|
|
CALL INSERTI18N('BASEMODULE.BASEDATA.EQUIPT.AUXILIARY', '辅助设备', '辅助设备', 'zh-CN', '辅助设备');
|
|
CALL INSERTI18N('BASEMODULE.BASEDATA.STANDBY', '设备备件', '设备备件', 'zh-CN', '设备备件');
|
|
CALL INSERTI18N('BASEMODULE.BASEDATA.LIFECYCLE', '生命周期', '生命周期', 'zh-CN', '生命周期');
|
|
CALL INSERTI18N('BASEMODULE.BASEDATA.QUALITYCONTROLSAMPLE', '质控样', '质控样', 'zh-CN', '质控样');
|
|
CALL INSERTI18N('BASEMODULE.BASEDATA.ENCLOSURE', '附件', '附件', 'zh-CN', '附件');
|
|
|
|
-- ----------------------------- 2022-09-14 add by wangyuwei@sunwaywolrd.com--------------end
|
|
|
|
|
|
-- ----------------------------- 2022-09-15 add by wangyuwei@sunwaywolrd.com--------------begin
|
|
|
|
-- 建表语句
|
|
CREATE TABLE T_LIMS_EQUIPT_STANDBY(
|
|
ID NUMBER NOT NULL,
|
|
STANDBYEQUIPTNAME VARCHAR2(270) NULL,
|
|
SPECIFICATION VARCHAR2(270) NULL,
|
|
MODEL VARCHAR2(270) NULL,
|
|
MANUFACTURER VARCHAR2(2700) NULL,
|
|
AMOUNT NUMBER NULL,
|
|
CHANGETIME DATE NULL,
|
|
REMARK VARCHAR2(270) NULL,
|
|
CREATEDBYID VARCHAR2(36) NULL,
|
|
CREATEDBYNAME VARCHAR2(60) NULL,
|
|
CREATEDTIME DATE NULL,
|
|
CREATEDBYORGID VARCHAR2(36) NULL,
|
|
CREATEDBYORGNAME VARCHAR2(270) NULL,
|
|
PROCESSSTATUS VARCHAR2(36) NULL,
|
|
ORGID VARCHAR2(36) NULL,
|
|
ORGNAME VARCHAR2(270) NULL
|
|
);
|
|
COMMENT ON TABLE T_LIMS_EQUIPT_STANDBY IS '设备备件表';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_STANDBY.ID IS '主键';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_STANDBY.STANDBYEQUIPTNAME IS '备件名称';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_STANDBY.SPECIFICATION IS '规格';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_STANDBY.MODEL IS '型号';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_STANDBY.MANUFACTURER IS '制造商';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_STANDBY.AMOUNT IS '数量';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_STANDBY.CHANGETIME IS '更换日期';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_STANDBY.REMARK IS '备注';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_STANDBY.CREATEDBYID IS '制单人编码';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_STANDBY.CREATEDBYNAME IS '制单人名称';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_STANDBY.CREATEDTIME IS '制单时间';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_STANDBY.CREATEDBYORGID IS '制单人单位编码';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_STANDBY.CREATEDBYORGNAME IS '制单人单位名称';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_STANDBY.PROCESSSTATUS IS '流程状态';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_STANDBY.ORGID IS '组织id';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_STANDBY.ORGNAME IS '组织名称';
|
|
|
|
ALTER TABLE T_LIMS_EQUIPT_STANDBY ADD CONSTRAINT PK_LIMS_EQUIPT_STANDBY PRIMARY KEY (ID);
|
|
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_STANDBY.SERVICE_NAME', '设备备件表', '设备备件表', 'zh-CN', '设备备件表');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_STANDBY.ID', '设备备件表的主键', '主键', 'zh-CN', '主键');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_STANDBY.STANDBYEQUIPTNAME', '设备备件表的备件名称', '备件名称', 'zh-CN', '备件名称');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_STANDBY.SPECIFICATION', '设备备件表的规格', '规格', 'zh-CN', '规格');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_STANDBY.MODEL', '设备备件表的型号', '型号', 'zh-CN', '型号');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_STANDBY.MANUFACTURER', '设备备件表的制造商', '制造商', 'zh-CN', '制造商');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_STANDBY.AMOUNT', '设备备件表的数量', '数量', 'zh-CN', '数量');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_STANDBY.CHANGETIME', '设备备件表的更换日期', '更换日期', 'zh-CN', '更换日期');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_STANDBY.REMARK', '设备备件表的备注', '备注', 'zh-CN', '备注');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_STANDBY.CREATEDBYID', '设备备件表的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_STANDBY.CREATEDBYNAME', '设备备件表的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_STANDBY.CREATEDTIME', '设备备件表的制单时间', '制单时间', 'zh-CN', '制单时间');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_STANDBY.CREATEDBYORGID', '设备备件表的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_STANDBY.CREATEDBYORGNAME', '设备备件表的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_STANDBY.PROCESSSTATUS', '设备备件表的流程状态', '流程状态', 'zh-CN', '流程状态');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_STANDBY.ORGID', '设备备件表的组织id', '组织id', 'zh-CN', '组织id');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_STANDBY.ORGNAME', '设备备件表的组织名称', '组织名称', 'zh-CN', '组织名称');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.STANDBYS.MODAL.ADD', '新增', '新增', 'zh-CN', '新增');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.STANDBYS.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.STANDBYS.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.STANDBYS.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.STANDBYS.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框');
|
|
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_AUXILIARY.EQUIPTNAME', '设备名称', '设备名称', 'zh-CN', '设备名称');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_AUXILIARY.EQUIPTCODE', '设备编号', '设备编号', 'zh-CN', '设备编号');
|
|
|
|
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('910204', '设备期间核查', null, '20220902013', '2', '008.svg', '设备期间核查');
|
|
|
|
|
|
CREATE TABLE T_LIMS_EQUIPT_PERIOD_PLAN(
|
|
ID NUMBER NOT NULL,
|
|
EQUIPTID NUMBER NULL,
|
|
EQUIPTCODE VARCHAR2(270) NULL,
|
|
EQUIPTNAME VARCHAR2(270) NULL,
|
|
SPECIFICATION VARCHAR2(270) NULL,
|
|
MODEL VARCHAR2(270) NULL,
|
|
CHECKKEY VARCHAR2(270) NULL,
|
|
CHECKMOD VARCHAR2(36) NULL,
|
|
CHECKFREQUENCY VARCHAR2(36) NULL,
|
|
CHECKTIME DATE NULL,
|
|
DUTYORG VARCHAR2(270) NULL,
|
|
DUTYORGID VARCHAR2(36) NULL,
|
|
PRINCIPAL VARCHAR2(270) NULL,
|
|
PRINCIPALID VARCHAR2(36) NULL,
|
|
REMARK 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_EQUIPT_PERIOD_PLAN IS '设备期间核查计划表';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_PLAN.ID IS '主键';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_PLAN.EQUIPTID IS '设备ID';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_PLAN.EQUIPTCODE IS '设备仪器编号';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_PLAN.EQUIPTNAME IS '设备仪器名称';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_PLAN.SPECIFICATION IS '规格';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_PLAN.MODEL IS '型号';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_PLAN.CHECKKEY IS '核查关键点';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_PLAN.CHECKMOD IS '核查方法';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_PLAN.CHECKFREQUENCY IS '期间核查频率';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_PLAN.CHECKTIME IS '期间核查日期';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_PLAN.DUTYORG IS '期间核查责任部门';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_PLAN.DUTYORGID IS '期间核查责任部门ID';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_PLAN.PRINCIPAL IS '责任人';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_PLAN.PRINCIPALID IS '责任人ID';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_PLAN.REMARK IS '备注';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_PLAN.PROCESSSTATUS IS '流程状态';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_PLAN.CREATEDBYID IS '制单人编码';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_PLAN.CREATEDBYNAME IS '制单人名称';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_PLAN.CREATEDTIME IS '制单时间';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_PLAN.CREATEDBYORGID IS '制单人单位编码';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_PLAN.CREATEDBYORGNAME IS '制单人单位名称';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_PLAN.ORGID IS '组织id';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_PLAN.ORGNAME IS '组织名称';
|
|
|
|
ALTER TABLE T_LIMS_EQUIPT_PERIOD_PLAN ADD CONSTRAINT PK_LIMS_EQUIPT_PERIOD_PLAN PRIMARY KEY (ID);
|
|
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_PLAN.SERVICE_NAME', '设备期间核查计划表', '设备期间核查计划表', 'zh-CN', '设备期间核查计划表');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_PLAN.ID', '设备期间核查计划表的主键', '主键', 'zh-CN', '主键');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_PLAN.EQUIPTID', '设备期间核查计划表的设备ID', '设备ID', 'zh-CN', '设备ID');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_PLAN.EQUIPTCODE', '设备期间核查计划表的设备编号', '设备编号', 'zh-CN', '设备仪器编号');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_PLAN.EQUIPTNAME', '设备期间核查计划表的设备名称', '设备名称', 'zh-CN', '设备仪器名称');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_PLAN.SPECIFICATION', '设备期间核查计划表的规格', '规格', 'zh-CN', '规格');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_PLAN.MODEL', '设备期间核查计划表的型号', '型号', 'zh-CN', '型号');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_PLAN.CHECKKEY', '设备期间核查计划表的核查关键点', '核查关键点', 'zh-CN', '核查关键点');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_PLAN.CHECKMOD', '设备期间核查计划表的核查方法', '核查方法', 'zh-CN', '核查方法');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_PLAN.CHECKFREQUENCY', '设备期间核查计划表的期间核查频率', '期间核查频率', 'zh-CN', '期间核查频率');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_PLAN.CHECKTIME', '设备期间核查计划表的期间核查日期', '期间核查日期', 'zh-CN', '期间核查日期');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_PLAN.DUTYORG', '设备期间核查计划表的期间核查责任部门', '期间核查责任部门', 'zh-CN', '期间核查责任部门');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_PLAN.DUTYORGID', '设备期间核查计划表的期间核查责任部门ID', '期间核查责任部门ID', 'zh-CN', '期间核查责任部门ID');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_PLAN.PRINCIPAL', '设备期间核查计划表的责任人', '责任人', 'zh-CN', '责任人');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_PLAN.PRINCIPALID', '设备期间核查计划表的责任人ID', '责任人ID', 'zh-CN', '责任人ID');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_PLAN.REMARK', '设备期间核查计划表的备注', '备注', 'zh-CN', '备注');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_PLAN.PROCESSSTATUS', '设备期间核查计划表的流程状态', '流程状态', 'zh-CN', '流程状态');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_PLAN.CREATEDBYID', '设备期间核查计划表的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_PLAN.CREATEDBYNAME', '设备期间核查计划表的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_PLAN.CREATEDTIME', '设备期间核查计划表的制单时间', '制单时间', 'zh-CN', '制单时间');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_PLAN.CREATEDBYORGID', '设备期间核查计划表的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_PLAN.CREATEDBYORGNAME', '设备期间核查计划表的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_PLAN.ORGID', '设备期间核查计划表的组织id', '组织id', 'zh-CN', '组织id');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_PLAN.ORGNAME', '设备期间核查计划表的组织名称', '组织名称', 'zh-CN', '组织名称');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.EQUIPMENTCHECKS.MODAL.ADD', '新增', '新增', 'zh-CN', '新增');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.EQUIPMENTCHECKS.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.EQUIPMENTCHECKS.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.EQUIPMENTCHECKS.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.EQUIPMENTCHECKS.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框');
|
|
-- ----------------------------- 2022-09-15 add by wangyuwei@sunwaywolrd.com--------------end
|
|
|
|
-- ----------------------------- 2022-09-16 add by wangyuwei@sunwaywolrd.com--------------end
|
|
|
|
|
|
CALL INSERTI18N('BASEMODULE.BASEDATA.EUQIPT.FOLDER.BASE.TNFO', '委托单', '委托单', 'zh-CN', '委托单');
|
|
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('91020401', '期间核查计划', '/secure/basemodule/trm/equipt/equipt-period-plans/page/edit-list', '910204', '1', '008.svg', '期间核查计划');
|
|
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('91020402', '期间核查计划审核', '/secure/basemodule/trm/equipt/equipt-period-plans/page/audit-list?bpmn_statusCode=Audit', '910204', '2', '008.svg', '期间核查计划审核');
|
|
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('91020403', '期间核查计划审批', '/secure/basemodule/trm/equipt/equipt-period-plans/page/audit-list?bpmn_statusCode=Approval', '910204', '3', '008.svg', '期间核查计划审批');
|
|
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('91020404', '期间核查计划查询', '/secure/basemodule/trm/equipt/equipt-period-plans/page/search-list', '910204', '4', '008.svg', '期间核查计划查询');
|
|
|
|
INSERT INTO T_CORE_MENU_EXT (ID, SERVICENAME, TABLENAME, TYPE, ENABLE)
|
|
VALUES ('91020402', '期间核查计划审核', 'T_LIMS_EQUIPT_PERIOD_PLAN', 'audit_def', '1');
|
|
|
|
|
|
|
|
-- 建表语句
|
|
CREATE TABLE T_LIMS_EQUIPT_STANDBY_RECORD(
|
|
ID NUMBER NOT NULL,
|
|
STANDBYEQUIPTID NUMBER NULL,
|
|
AMOUNT NUMBER NULL,
|
|
CHANGETIME NUMBER NULL,
|
|
CREATEDBYID VARCHAR2(36) NULL,
|
|
CREATEDBYNAME VARCHAR2(60) NULL,
|
|
CREATEDTIME DATE NULL,
|
|
CREATEDBYORGID VARCHAR2(36) NULL,
|
|
CREATEDBYORGNAME VARCHAR2(270) NULL,
|
|
PROCESSSTATUS VARCHAR2(36) NULL,
|
|
ORGID VARCHAR2(36) NULL,
|
|
ORGNAME VARCHAR2(270) NULL
|
|
);
|
|
COMMENT ON TABLE T_LIMS_EQUIPT_STANDBY_RECORD IS '设备备件记录表';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_STANDBY_RECORD.ID IS '主键';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_STANDBY_RECORD.STANDBYEQUIPTID IS '备件ID';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_STANDBY_RECORD.AMOUNT IS '数量';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_STANDBY_RECORD.CHANGETIME IS '更换日期';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_STANDBY_RECORD.CREATEDBYID IS '制单人编码';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_STANDBY_RECORD.CREATEDBYNAME IS '制单人名称';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_STANDBY_RECORD.CREATEDTIME IS '制单时间';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_STANDBY_RECORD.CREATEDBYORGID IS '制单人单位编码';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_STANDBY_RECORD.CREATEDBYORGNAME IS '制单人单位名称';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_STANDBY_RECORD.PROCESSSTATUS IS '流程状态';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_STANDBY_RECORD.ORGID IS '组织id';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_STANDBY_RECORD.ORGNAME IS '组织名称';
|
|
|
|
ALTER TABLE T_LIMS_EQUIPT_STANDBY_RECORD ADD CONSTRAINT PK_LIMS_EQUIPT_STANDBY_RECORD PRIMARY KEY (ID);
|
|
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_STANDBY_RECORD.SERVICE_NAME', '设备备件记录表', '设备备件记录表', 'zh-CN', '设备备件记录表');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_STANDBY_RECORD.ID', '设备备件记录表的主键', '主键', 'zh-CN', '主键');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_STANDBY_RECORD.STANDBYEQUIPTID', '设备备件记录表的备件ID', '备件ID', 'zh-CN', '备件ID');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_STANDBY_RECORD.AMOUNT', '设备备件记录表的数量', '数量', 'zh-CN', '数量');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_STANDBY_RECORD.CHANGETIME', '设备备件记录表的更换日期', '更换日期', 'zh-CN', '更换日期');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_STANDBY_RECORD.CREATEDBYID', '设备备件记录表的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_STANDBY_RECORD.CREATEDBYNAME', '设备备件记录表的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_STANDBY_RECORD.CREATEDTIME', '设备备件记录表的制单时间', '制单时间', 'zh-CN', '制单时间');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_STANDBY_RECORD.CREATEDBYORGID', '设备备件记录表的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_STANDBY_RECORD.CREATEDBYORGNAME', '设备备件记录表的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_STANDBY_RECORD.PROCESSSTATUS', '设备备件记录表的流程状态', '流程状态', 'zh-CN', '流程状态');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_STANDBY_RECORD.ORGID', '设备备件记录表的组织id', '组织id', 'zh-CN', '组织id');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_STANDBY_RECORD.ORGNAME', '设备备件记录表的组织名称', '组织名称', 'zh-CN', '组织名称');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.STANDBYRECORDS.MODAL.ADD', '新增', '新增', 'zh-CN', '新增');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.STANDBYRECORDS.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.STANDBYRECORDS.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.STANDBYRECORDS.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.STANDBYRECORDS.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框');
|
|
|
|
|
|
|
|
-- 建表语句
|
|
CREATE TABLE T_LIMS_EQUIPT_PERIOD_RECORD(
|
|
ID NUMBER NOT NULL,
|
|
EQUIPTID NUMBER NULL,
|
|
EQUIPTCODE VARCHAR2(270) NULL,
|
|
EQUIPTNAME VARCHAR2(270) NULL,
|
|
SPECIFICATION VARCHAR2(270) NULL,
|
|
MODEL VARCHAR2(270) NULL,
|
|
CHECKTIME DATE NULL,
|
|
CORRECTINDATE DATE NULL,
|
|
TEMPERATURE NUMBER(16,2) NULL,
|
|
HUMIDITY VARCHAR2(270) NULL,
|
|
OPINION VARCHAR2(270) NULL,
|
|
CHECKMODE VARCHAR2(36) NULL,
|
|
CHECKRESULT VARCHAR2(270) NULL,
|
|
CHECKCONCLUSION VARCHAR2(270) NULL,
|
|
CHECKPROCESS 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_EQUIPT_PERIOD_RECORD IS '设备期间核查记录表';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_RECORD.ID IS '主键';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_RECORD.EQUIPTID IS '设备ID';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_RECORD.EQUIPTCODE IS '设备编号';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_RECORD.EQUIPTNAME IS '设备名称';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_RECORD.SPECIFICATION IS '规格';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_RECORD.MODEL IS '型号';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_RECORD.CHECKTIME IS '期间核查日期';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_RECORD.CORRECTINDATE IS '校准有效期';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_RECORD.TEMPERATURE IS '核查温度';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_RECORD.HUMIDITY IS '核查湿度';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_RECORD.OPINION IS '审核意见';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_RECORD.CHECKMODE IS '核查方法';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_RECORD.CHECKRESULT IS '核查结果';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_RECORD.CHECKCONCLUSION IS '核查结论';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_RECORD.CHECKPROCESS IS '核查过程';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_RECORD.PROCESSSTATUS IS '流程状态';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_RECORD.CREATEDBYID IS '制单人编码';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_RECORD.CREATEDBYNAME IS '制单人名称';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_RECORD.CREATEDTIME IS '制单时间';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_RECORD.CREATEDBYORGID IS '制单人单位编码';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_RECORD.CREATEDBYORGNAME IS '制单人单位名称';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_RECORD.ORGID IS '组织id';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_RECORD.ORGNAME IS '组织名称';
|
|
|
|
ALTER TABLE T_LIMS_EQUIPT_PERIOD_RECORD ADD CONSTRAINT PK_LIMS_EQUIPT_PERIOD_RECORD PRIMARY KEY (ID);
|
|
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_RECORD.SERVICE_NAME', '设备期间核查记录表', '设备期间核查记录表', 'zh-CN', '设备期间核查记录表');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_RECORD.ID', '设备期间核查记录表的主键', '主键', 'zh-CN', '主键');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_RECORD.EQUIPTID', '设备期间核查记录表的设备ID', '设备ID', 'zh-CN', '设备ID');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_RECORD.EQUIPTCODE', '设备期间核查记录表的设备编号', '设备编号', 'zh-CN', '设备编号');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_RECORD.EQUIPTNAME', '设备期间核查记录表的设备名称', '设备名称', 'zh-CN', '设备名称');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_RECORD.SPECIFICATION', '设备期间核查记录表的规格', '规格', 'zh-CN', '规格');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_RECORD.MODEL', '设备期间核查记录表的型号', '型号', 'zh-CN', '型号');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_RECORD.CHECKTIME', '设备期间核查记录表的期间核查日期', '期间核查日期', 'zh-CN', '期间核查日期');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_RECORD.CORRECTINDATE', '设备期间核查记录表的校准有效期', '校准有效期', 'zh-CN', '校准有效期');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_RECORD.TEMPERATURE', '设备期间核查记录表的核查温度', '核查温度', 'zh-CN', '核查温度');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_RECORD.HUMIDITY', '设备期间核查记录表的核查湿度', '核查湿度', 'zh-CN', '核查湿度');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_RECORD.OPINION', '设备期间核查记录表的审核意见', '审核意见', 'zh-CN', '审核意见');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_RECORD.CHECKMODE', '设备期间核查记录表的核查方法', '核查方法', 'zh-CN', '核查方法');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_RECORD.CHECKRESULT', '设备期间核查记录表的核查结果', '核查结果', 'zh-CN', '核查结果');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_RECORD.CHECKCONCLUSION', '设备期间核查记录表的核查结论', '核查结论', 'zh-CN', '核查结论');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_RECORD.CHECKPROCESS', '设备期间核查记录表的核查过程', '核查过程', 'zh-CN', '核查过程');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_RECORD.PROCESSSTATUS', '设备期间核查记录表的流程状态', '流程状态', 'zh-CN', '流程状态');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_RECORD.CREATEDBYID', '设备期间核查记录表的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_RECORD.CREATEDBYNAME', '设备期间核查记录表的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_RECORD.CREATEDTIME', '设备期间核查记录表的制单时间', '制单时间', 'zh-CN', '制单时间');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_RECORD.CREATEDBYORGID', '设备期间核查记录表的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_RECORD.CREATEDBYORGNAME', '设备期间核查记录表的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_RECORD.ORGID', '设备期间核查记录表的组织id', '组织id', 'zh-CN', '组织id');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_RECORD.ORGNAME', '设备期间核查记录表的组织名称', '组织名称', 'zh-CN', '组织名称');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.EQUIPCHECKRECORDS.MODAL.ADD', '新增', '新增', 'zh-CN', '新增');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.EQUIPCHECKRECORDS.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.EQUIPCHECKRECORDS.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.EQUIPCHECKRECORDS.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.EQUIPCHECKRECORDS.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框');
|
|
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('91020405', '新增期间核查记录', '/secure/basemodule/trm/equipt/equipt-period-records/page/edit-list', '910204', '5', '008.svg', '新增期间核查记录');
|
|
|
|
CALL INSERTI18N('BASEMODULE.BASEDATA.EQUIPT.ENCLOSURE.BASE.TNFO', '附件', '附件', 'zh-CN', '附件');
|
|
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('91020406', '期间核查记录审核', '/secure/basemodule/trm/equipt/equipt-period-records/page/audit-list?bpmn_statusCode=Audit', '910204', '6', '008.svg', '期间核查记录审核');
|
|
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('91020407', '期间核查记录审批', '/secure/basemodule/trm/equipt/equipt-period-records/page/audit-list?bpmn_statusCode=Approval', '910204', '7', '008.svg', '期间核查记录审批');
|
|
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('91020408', '期间核查记录查询', '/secure/basemodule/trm/equipt/equipt-period-records/page/search-list', '910204', '8', '008.svg', '期间核查记录查询');
|
|
|
|
|
|
INSERT INTO T_CORE_MENU_EXT (ID, SERVICENAME, TABLENAME, TYPE, ENABLE)
|
|
VALUES ('91020405', '期间核查记录', 'T_LIMS_EQUIPT_PERIOD_RECORD', 'audit_def', '1');
|
|
|
|
-- ----------------------------- 2022-09-16 add by wangyuwei@sunwaywolrd.com--------------end
|
|
|
|
-- ----------------------------- 2022-09-18 add by wangyuwei@sunwaywolrd.com--------------begin
|
|
|
|
ALTER TABLE T_LIMS_EQUIPT_AUXILIARY ADD SPECIFICATION VARCHAR2(270)
|
|
|
|
ALTER TABLE T_LIMS_EQUIPT_STANDBY modify STANDBYID NUMBER
|
|
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_AUXILIARY.SPECIFICATION', '规格', '规格', 'zh-CN', '规格');
|
|
|
|
INSERT INTO T_CORE_CODE_CATEGORY (ID,CODECATEGORYNAME,CODECLASSID,REMARK,ORDERNO,VERSION,CREATEDBYID,CREATEDBYNAME,CREATEDTIME)
|
|
VALUES('eventType','仓库','sys', NULL, NULL, NULL,NULL,NULL,NULL);
|
|
INSERT INTO LIMS_BP_DEV.T_CORE_CODE
|
|
(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
|
|
VALUES(20220918001, '维修', 'eventType', '5', 4, 1, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'repair');
|
|
INSERT INTO LIMS_BP_DEV.T_CORE_CODE
|
|
(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
|
|
VALUES(20220918002, '保养', 'eventType', '5', 4, 2, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'maintain');
|
|
INSERT INTO LIMS_BP_DEV.T_CORE_CODE
|
|
(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
|
|
VALUES(20220918003, '点检', 'eventType', '5', 4, 3, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'Spotcheck');
|
|
INSERT INTO LIMS_BP_DEV.T_CORE_CODE
|
|
(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
|
|
VALUES(20220918004, '巡检', 'eventType', '5', 4, 4, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'OnSiteInspection');
|
|
|
|
ALTER TABLE T_LIMS_EQUIPT MODIFY correctInDate DATE
|
|
ALTER TABLE T_LIMS_EQUIPT MODIFY planCorrectTime DATE
|
|
ALTER TABLE T_LIMS_EQUIPT MODIFY buyTime DATE
|
|
|
|
|
|
|
|
-- 建表语句
|
|
CREATE TABLE T_LIMS_EQUIPT_QUALITY(
|
|
ID NUMBER NOT NULL,
|
|
QUALITYNAME VARCHAR2(270) NULL,
|
|
QUALITYUP VARCHAR2(36) NULL,
|
|
QUALITYDOWN VARCHAR2(36) NULL,
|
|
VALIDDATE DATE NULL,
|
|
CONTROLFREQUENCY VARCHAR2(270) NULL,
|
|
REMARK 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_EQUIPT_QUALITY IS '质控样';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_QUALITY.ID IS '主键';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_QUALITY.QUALITYNAME IS '质控样名称';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_QUALITY.QUALITYUP IS '控制上限值';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_QUALITY.QUALITYDOWN IS '控制下限值';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_QUALITY.VALIDDATE IS '有效日期';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_QUALITY.CONTROLFREQUENCY IS '控制频次';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_QUALITY.REMARK IS '备注';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_QUALITY.PROCESSSTATUS IS '流程状态';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_QUALITY.CREATEDBYID IS '制单人编码';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_QUALITY.CREATEDBYNAME IS '制单人名称';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_QUALITY.CREATEDTIME IS '制单时间';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_QUALITY.CREATEDBYORGID IS '制单人单位编码';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_QUALITY.CREATEDBYORGNAME IS '制单人单位名称';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_QUALITY.ORGID IS '组织id';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_QUALITY.ORGNAME IS '组织名称';
|
|
|
|
ALTER TABLE T_LIMS_EQUIPT_QUALITY ADD CONSTRAINT PK_LIMS_EQUIPT_QUALITY PRIMARY KEY (ID);
|
|
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_QUALITY.SERVICE_NAME', '质控样', '质控样', 'zh-CN', '质控样');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_QUALITY.ID', '质控样的主键', '主键', 'zh-CN', '主键');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_QUALITY.QUALITYNAME', '质控样的质控样名称', '质控样名称', 'zh-CN', '质控样名称');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_QUALITY.QUALITYUP', '质控样的控制上限值', '控制上限值', 'zh-CN', '控制上限值');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_QUALITY.QUALITYDOWN', '质控样的控制下限值', '控制下限值', 'zh-CN', '控制下限值');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_QUALITY.VALIDDATE', '质控样的有效日期', '有效日期', 'zh-CN', '有效日期');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_QUALITY.CONTROLFREQUENCY', '质控样的控制频次', '控制频次', 'zh-CN', '控制频次');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_QUALITY.REMARK', '质控样的备注', '备注', 'zh-CN', '备注');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_QUALITY.PROCESSSTATUS', '质控样的流程状态', '流程状态', 'zh-CN', '流程状态');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_QUALITY.CREATEDBYID', '质控样的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_QUALITY.CREATEDBYNAME', '质控样的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_QUALITY.CREATEDTIME', '质控样的制单时间', '制单时间', 'zh-CN', '制单时间');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_QUALITY.CREATEDBYORGID', '质控样的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_QUALITY.CREATEDBYORGNAME', '质控样的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_QUALITY.ORGID', '质控样的组织id', '组织id', 'zh-CN', '组织id');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_QUALITY.ORGNAME', '质控样的组织名称', '组织名称', 'zh-CN', '组织名称');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.QUALITYSAMPLES.MODAL.ADD', '新增', '新增', 'zh-CN', '新增');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.QUALITYSAMPLES.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.QUALITYSAMPLES.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.QUALITYSAMPLES.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.QUALITYSAMPLES.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框');
|
|
|
|
ALTER TABLE T_LIMS_EQUIPT_QUALITY ADD qualityId VARCHAR2(36)
|
|
-- ----------------------------- 2022-09-18 add by wangyuwei@sunwaywolrd.com--------------end
|
|
|
|
|
|
-- ----------------------------- 2022-09-19 add by wangyuwei@sunwaywolrd.com--------------begin
|
|
|
|
|
|
INSERT INTO T_CORE_CODE_CATEGORY (ID,CODECATEGORYNAME,CODECLASSID,REMARK,ORDERNO,VERSION,CREATEDBYID,CREATEDBYNAME,CREATEDTIME)
|
|
VALUES('correctMode','校准方式','sys', NULL, NULL, NULL,NULL,NULL,NULL);
|
|
INSERT INTO LIMS_BP_DEV.T_CORE_CODE
|
|
(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
|
|
VALUES(20220919003, '内校', 'correctMode', '8', 3, 1, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'in');
|
|
INSERT INTO LIMS_BP_DEV.T_CORE_CODE
|
|
(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
|
|
VALUES(20220919004, '外校', 'correctMode', '8', 3, 2, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'out');
|
|
INSERT INTO LIMS_BP_DEV.T_CORE_CODE
|
|
(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
|
|
VALUES(20220919005, '免校', 'correctMode', '8', 3, 3, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'free');
|
|
INSERT INTO LIMS_BP_DEV.T_CORE_CODE
|
|
(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
|
|
VALUES(20220919006, '外审', 'correctMode', '8', 3, 4, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'outCheck');
|
|
|
|
|
|
|
|
INSERT INTO T_CORE_CODE_CATEGORY (ID,CODECATEGORYNAME,CODECLASSID,REMARK,ORDERNO,VERSION,CREATEDBYID,CREATEDBYNAME,CREATEDTIME)
|
|
VALUES('correctPeriod','校准方式','sys', NULL, NULL, NULL,NULL,NULL,NULL);
|
|
INSERT INTO LIMS_BP_DEV.T_CORE_CODE
|
|
(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
|
|
VALUES(20220919007, '6个月', 'correctPeriod', '9', 3, 1, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'sixMonth');
|
|
INSERT INTO LIMS_BP_DEV.T_CORE_CODE
|
|
(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
|
|
VALUES(20220919008, '12个月', 'correctPeriod', '9', 3, 2, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'twlMonth');
|
|
INSERT INTO LIMS_BP_DEV.T_CORE_CODE
|
|
(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
|
|
VALUES(20220919009, '24个月', 'correctPeriod', '9', 3, 3, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'twlFourMonth');
|
|
|
|
INSERT INTO T_CORE_CODE_CATEGORY (ID,CODECATEGORYNAME,CODECLASSID,REMARK,ORDERNO,VERSION,CREATEDBYID,CREATEDBYNAME,CREATEDTIME)
|
|
VALUES('baseOrg','校准方式','sys', NULL, NULL, NULL,NULL,NULL,NULL);
|
|
INSERT INTO LIMS_BP_DEV.T_CORE_CODE
|
|
(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
|
|
VALUES(20220919010, 'FS1', 'baseOrg', '10', 3, 1, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'FS1');
|
|
INSERT INTO LIMS_BP_DEV.T_CORE_CODE
|
|
(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
|
|
VALUES(20220919011, 'FS3', 'baseOrg', '10', 3, 2, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'FS3');
|
|
-- ----------------------------- 2022-09-19 add by wangyuwei@sunwaywolrd.com--------------end
|
|
|
|
|
|
-- ----------------------------- 2022-09-21 add by wangyuwei@sunwaywolrd.com--------------begin
|
|
|
|
INSERT INTO LIMS_BP_DEV.T_CORE_CODE
|
|
(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
|
|
VALUES(202110190003, '维修', 'equiptStatus', '13', 3, 2, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'repair');
|
|
INSERT INTO LIMS_BP_DEV.T_CORE_CODE
|
|
(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
|
|
VALUES(202110190004, '停用', 'equiptStatus', '13', 3, 2, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'stop');
|
|
INSERT INTO LIMS_BP_DEV.T_CORE_CODE
|
|
(ID, CODENAME, CODECATEGORYID, REMARK, ORDERNO, VERSION, CREATEDBYID, CREATEDBYNAME, CREATEDTIME, LASTSUSPENDEDFLAG, LASTSUSPENDEDBYID, LASTSUSPENDEDBYNAME, LASTSUSPENDEDTIME, CODE)
|
|
VALUES(202110190005, '限制使用', 'equiptStatus', '13', 3, 2, 'admin', '系统管理员', NULL, '0', NULL, NULL, NULL, 'Restricted');
|
|
|
|
CALL INSERTI18N('T_LIMS_FOLDER.STATUS', '状态', '状态', 'zh-CN', '状态');
|
|
|
|
-- ----------------------------- 2022-09-21 add by wangyuwei@sunwaywolrd.com--------------end
|
|
|
|
|
|
-- ----------------------------- 2022-09-27 add by wangyuwei@sunwaywolrd.com--------------begin
|
|
|
|
ALTER TABLE T_LIMS_EQUIPT_AUXILIARY ADD AUXILIARYCODE varchar2(36);
|
|
ALTER TABLE T_LIMS_EQUIPT_AUXILIARY ADD AUXILIARYNAME varchar2(270);
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_AUXILIARY.AUXILIARYCODE','辅助设备编码', '辅助设备编码', 'zh-CN', '辅助设备编码');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_AUXILIARY.AUXILIARYNAME','辅助设备名称', '辅助设备名称', 'zh-CN', '辅助设备名称');
|
|
ALTER TABLE T_LIMS_EQUIPT_STANDBY ADD OPERATIONTYPE varchar2(270);
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_STANDBY.OPERATIONTYPE','操作类型', '操作类型', 'zh-CN', '操作类型');
|
|
CALL INSERTI18N('BASEMODULE.TRM.EQUIPT.SPAREPARTS.TAB.BASE_INFO','备件列表', '备件列表', 'zh-CN', '备件列表');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_SPAREPARTLOGS.SERVICE_NAME','更换记录', '更换记录', 'zh-CN', '更换记录');
|
|
-- ----------------------------- 2022-09-27 add by wangyuwei@sunwaywolrd.com--------------end
|
|
|
|
|
|
-- ----------------------------- 2022-09-28 add by wangyuwei@sunwaywolrd.com--------------begin
|
|
|
|
ALTER TABLE T_LIMS_EQUIPT_PERIOD_PLAN ADD FOLDERSTATUS varchar2(270);
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_PLAN.FOLDERSTATUS','委托单状态', '委托单状态', 'zh-CN', '委托单状态');
|
|
ALTER TABLE T_LIMS_EQUIPT_PERIOD_PLAN ADD FOLDERCODE varchar2(36);
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_PLAN.FOLDERCODE','委托单编号', '委托单编号', 'zh-CN', '委托单编号');
|
|
|
|
|
|
ALTER TABLE T_LIMS_EQUIPT_PERIOD_PLAN ADD CORRECTINDATE DATE;
|
|
ALTER TABLE T_LIMS_EQUIPT_PERIOD_PLAN ADD TEMPERATURE NUMBER(16,2);
|
|
ALTER TABLE T_LIMS_EQUIPT_PERIOD_PLAN ADD HUMIDITY VARCHAR2(270);
|
|
ALTER TABLE T_LIMS_EQUIPT_PERIOD_PLAN ADD OPINION VARCHAR2(270);
|
|
ALTER TABLE T_LIMS_EQUIPT_PERIOD_PLAN ADD CHECKMODE VARCHAR2(36);
|
|
ALTER TABLE T_LIMS_EQUIPT_PERIOD_PLAN ADD CHECKRESULT VARCHAR2(270);
|
|
ALTER TABLE T_LIMS_EQUIPT_PERIOD_PLAN ADD CHECKCONCLUSION VARCHAR2(270);
|
|
ALTER TABLE T_LIMS_EQUIPT_PERIOD_PLAN ADD CHECKPROCESS VARCHAR2(270);
|
|
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_PLAN.CORRECTINDATE IS '校准有效期';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_PLAN.TEMPERATURE IS '核查温度';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_PLAN.HUMIDITY IS '核查湿度';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_PLAN.OPINION IS '审核意见';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_PLAN.CHECKMODE IS '核查方法';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_PLAN.CHECKRESULT IS '核查结果';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_PLAN.CHECKCONCLUSION IS '核查结论';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_PLAN.CHECKPROCESS IS '核查过程';
|
|
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_PLAN.CORRECTINDATE', '设备期间核查记录表的校准有效期', '校准有效期', 'zh-CN', '校准有效期');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_PLAN.TEMPERATURE', '设备期间核查记录表的核查温度', '核查温度', 'zh-CN', '核查温度');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_PLAN.HUMIDITY', '设备期间核查记录表的核查湿度', '核查湿度', 'zh-CN', '核查湿度');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_PLAN.OPINION', '设备期间核查记录表的审核意见', '审核意见', 'zh-CN', '审核意见');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_PLAN.CHECKMODE', '设备期间核查记录表的核查方法', '核查方法', 'zh-CN', '核查方法');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_PLAN.CHECKRESULT', '设备期间核查记录表的核查结果', '核查结果', 'zh-CN', '核查结果');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_PLAN.CHECKCONCLUSION', '设备期间核查记录表的核查结论', '核查结论', 'zh-CN', '核查结论');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_PLAN.CHECKPROCESS', '设备期间核查记录表的核查过程', '核查过程', 'zh-CN', '核查过程');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_PLAN.PROCESSSTATUS', '设备期间核查记录表的流程状态', '流程状态', 'zh-CN', '流程状态');
|
|
-- ----------------------------- 2022-09-28 add by wangyuwei@sunwaywolrd.com--------------end
|
|
|
|
-- ----------------------------- 2022-09-29 add by wangyuwei@sunwaywolrd.com--------------begin
|
|
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('91020405', '新增期间核查记录', '/secure/basemodule/trm/equipt/equipt-period-plans/page/audit-list?bpmn_statusCode=RecordEdit', '910204', '5', '035.svg', '新增期间核查记录');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('91020406', '期间核查记录审核', '/secure/basemodule/trm/equipt/equipt-period-plans/page/audit-list?bpmn_statusCode=RecordAudit', '910204', '6', '035.svg', '期间核查记录审核');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('91020407', '期间核查记录审批', '/secure/basemodule/trm/equipt/equipt-period-plans/page/audit-list?bpmn_statusCode=RecordApproval', '910204', '7', '035.svg', '期间核查记录审批');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('91020408', '期间核查记录查询', '/secure/basemodule/trm/equipt/equipt-period-plans/page/search-list?page=resultSearch', '910204', '8', '035.svg', '期间核查记录查询');
|
|
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('91020405', '新增期间核查记录', '/secure/basemodule/trm/equipt/equipt-period-plans/page/audit-list?bpmn_statusCode=RecordEdit', '910204', '5', '035.svg', '新增期间核查记录');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('91020406', '期间核查记录审核', '/secure/basemodule/trm/equipt/equipt-period-plans/page/audit-list?bpmn_statusCode=RecordAudit', '910204', '6', '035.svg', '期间核查记录审核');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('91020407', '期间核查记录审批', '/secure/basemodule/trm/equipt/equipt-period-plans/page/audit-list?bpmn_statusCode=RecordApproval', '910204', '7', '035.svg', '期间核查记录审批');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('91020408', '期间核查记录查询', '/secure/basemodule/trm/equipt/equipt-period-plans/page/search-list?page=resultSearch', '910204', '8', '035.svg', '期间核查记录查询');
|
|
|
|
-- ----------------------------- 2022-09-29 add by wangyuwei@sunwaywolrd.com--------------end
|
|
|
|
|
|
-- ----------------------------- 2022-10-08 add by wangyuwei@sunwaywolrd.com--------------begin
|
|
|
|
|
|
ALTER TABLE T_LIMS_EQUIPT_PERIOD_PLAN ADD FOLDERID NUMBER;
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_PLAN.FOLDERID', '委托单id', '委托单id', 'zh-CN', '委托单id');
|
|
|
|
|
|
-- ----------------------------- 2022-10-08 add by wangyuwei@sunwaywolrd.com--------------end
|
|
|
|
|
|
|
|
-- ----------------------------- 2022-10-12 add by wangyuwei--------------begin
|
|
|
|
-- 建表语句
|
|
CREATE TABLE T_LIMS_EQUIPT_PERIOD_PLAN_FOLDER(
|
|
ID NUMBER NOT NULL,
|
|
FOLDERID VARCHAR2(36) NULL,
|
|
CHECKID 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_EQUIPT_PERIOD_PLAN_FOLDER IS '设备期间核查计划委托单表';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_PLAN_FOLDER.ID IS '主键';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_PLAN_FOLDER.FOLDERID IS '委托单id';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_PLAN_FOLDER.CHECKID IS '核查id';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_PLAN_FOLDER.CREATEDBYID IS '制单人编码';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_PLAN_FOLDER.CREATEDBYNAME IS '制单人名称';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_PLAN_FOLDER.CREATEDTIME IS '制单时间';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_PLAN_FOLDER.CREATEDBYORGID IS '制单人单位编码';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_PLAN_FOLDER.CREATEDBYORGNAME IS '制单人单位名称';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_PLAN_FOLDER.ORGID IS '组织id';
|
|
COMMENT ON COLUMN T_LIMS_EQUIPT_PERIOD_PLAN_FOLDER.ORGNAME IS '组织名称';
|
|
|
|
ALTER TABLE T_LIMS_EQUIPT_PERIOD_PLAN_FOLDER ADD CONSTRAINT PK_LIMS_EQUIPT_PERIOD_PLAN_FOLDER PRIMARY KEY (ID);
|
|
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_PLAN_FOLDER.SERVICE_NAME', '设备期间核查计划委托单表', '设备期间核查计划委托单表', 'zh-CN', '设备期间核查计划委托单表');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_PLAN_FOLDER.ID', '设备期间核查计划委托单表的主键', '主键', 'zh-CN', '主键');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_PLAN_FOLDER.FOLDERID', '设备期间核查计划委托单表的委托单id', '委托单id', 'zh-CN', '委托单id');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_PLAN_FOLDER.CHECKID', '设备期间核查计划委托单表的核查id', '核查id', 'zh-CN', '核查id');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_PLAN_FOLDER.CREATEDBYID', '设备期间核查计划委托单表的制单人编码', '制单人编码', 'zh-CN', '制单人编码');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_PLAN_FOLDER.CREATEDBYNAME', '设备期间核查计划委托单表的制单人名称', '制单人名称', 'zh-CN', '制单人名称');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_PLAN_FOLDER.CREATEDTIME', '设备期间核查计划委托单表的制单时间', '制单时间', 'zh-CN', '制单时间');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_PLAN_FOLDER.CREATEDBYORGID', '设备期间核查计划委托单表的制单人单位编码', '制单人单位编码', 'zh-CN', '制单人单位编码');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_PLAN_FOLDER.CREATEDBYORGNAME', '设备期间核查计划委托单表的制单人单位名称', '制单人单位名称', 'zh-CN', '制单人单位名称');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_PLAN_FOLDER.ORGID', '设备期间核查计划委托单表的组织id', '组织id', 'zh-CN', '组织id');
|
|
CALL INSERTI18N('T_LIMS_EQUIPT_PERIOD_PLAN_FOLDER.ORGNAME', '设备期间核查计划委托单表的组织名称', '组织名称', 'zh-CN', '组织名称');
|
|
CALL INSERTI18N('2212S.MODAL.ADD', '新增', '新增', 'zh-CN', '新增');
|
|
CALL INSERTI18N('2212S.TAB.BASE_INFO', '基本信息', '基本信息', 'zh-CN', '基本信息');
|
|
CALL INSERTI18N('2212S.BUTTON.BUTTON', '按钮', '按钮', 'zh-CN', '按钮');
|
|
CALL INSERTI18N('2212S.TIP.TIP', '提示框', '提示框', 'zh-CN', '提示框');
|
|
CALL INSERTI18N('2212S.MODAL.MODAL', '对话框', '对话框', 'zh-CN', '对话框');
|
|
|
|
|
|
|
|
COMMIT;
|
|
|
|
-- ----------------------------- 2022-10-12 add by wangyuwei------------end |