596 lines
71 KiB
Plaintext
596 lines
71 KiB
Plaintext
-- ----------------------------- 2022-08-31 add by lijiaxing--------------begin
|
|
|
|
-- 建表语句
|
|
CREATE TABlE DBO.T_LIMS_EQUIPT_CHANNEL(
|
|
ID BIGINT NOT NULL,
|
|
CREATEDBYID VARCHAR(36) NULL ,
|
|
CREATEDBYNAME VARCHAR(60) NULL ,
|
|
CREATEDTIME DATETIME NULL ,
|
|
CREATEDBYORGID VARCHAR(36) NULL ,
|
|
CREATEDBYORGNAME VARCHAR(270) NULL ,
|
|
EQUIPTID BIGINT NULL ,
|
|
UNITCODE VARCHAR(36) NULL ,
|
|
CHANNELCODE VARCHAR(36) NULL ,
|
|
CHANNELNAME VARCHAR(36) NULL ,
|
|
CHANNELSTATUS VARCHAR(36) NULL ,
|
|
REMARKS VARCHAR(360) NULL ,
|
|
CONSTRAINT PK_LIMS_EQUIPT_CHANNEL PRIMARY KEY(ID));
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'设备通道表' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_CHANNEL';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_CHANNEL', @level2type=N'COLUMN',@level2name=N'ID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人编码' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_CHANNEL', @level2type=N'COLUMN',@level2name=N'CREATEDBYID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人名称' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_CHANNEL', @level2type=N'COLUMN',@level2name=N'CREATEDBYNAME';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单时间' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_CHANNEL', @level2type=N'COLUMN',@level2name=N'CREATEDTIME';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人单位编码' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_CHANNEL', @level2type=N'COLUMN',@level2name=N'CREATEDBYORGID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人单位名称' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_CHANNEL', @level2type=N'COLUMN',@level2name=N'CREATEDBYORGNAME';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'设备ID' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_CHANNEL', @level2type=N'COLUMN',@level2name=N'EQUIPTID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单元编号' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_CHANNEL', @level2type=N'COLUMN',@level2name=N'UNITCODE';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'通道编号' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_CHANNEL', @level2type=N'COLUMN',@level2name=N'CHANNELCODE';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'通道名称' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_CHANNEL', @level2type=N'COLUMN',@level2name=N'CHANNELNAME';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'通道状态' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_CHANNEL', @level2type=N'COLUMN',@level2name=N'CHANNELSTATUS';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_CHANNEL', @level2type=N'COLUMN',@level2name=N'REMARKS';
|
|
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_CHANNEL.SERVICE_NAME', N'设备通道表', N'设备通道表', N'zh-CN',N'设备通道表';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_CHANNEL.ID', N'设备通道表的主键', N'主键', N'zh-CN',N'主键';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_CHANNEL.CREATEDBYID', N'设备通道表的制单人编码', N'制单人编码', N'zh-CN',N'制单人编码';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_CHANNEL.CREATEDBYNAME', N'设备通道表的制单人名称', N'制单人名称', N'zh-CN',N'制单人名称';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_CHANNEL.CREATEDTIME', N'设备通道表的制单时间', N'制单时间', N'zh-CN',N'制单时间';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_CHANNEL.CREATEDBYORGID', N'设备通道表的制单人单位编码', N'制单人单位编码', N'zh-CN',N'制单人单位编码';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_CHANNEL.CREATEDBYORGNAME', N'设备通道表的制单人单位名称', N'制单人单位名称', N'zh-CN',N'制单人单位名称';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_CHANNEL.EQUIPTID', N'设备通道表的设备ID', N'设备ID', N'zh-CN',N'设备ID';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_CHANNEL.UNITCODE', N'设备通道表的单元编号', N'单元编号', N'zh-CN',N'单元编号';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_CHANNEL.CHANNELCODE', N'设备通道表的通道编号', N'通道编号', N'zh-CN',N'通道编号';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_CHANNEL.CHANNELNAME', N'设备通道表的通道名称', N'通道名称', N'zh-CN',N'通道名称';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_CHANNEL.CHANNELSTATUS', N'设备通道表的通道状态', N'通道状态', N'zh-CN',N'通道状态';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_CHANNEL.REMARKS', N'设备通道表的备注', N'备注', N'zh-CN',N'备注';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.TRM.EQUIPT.CHANNELS.MODAL.ADD', N'新增', N'新增', N'zh-CN',N'新增';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.TRM.EQUIPT.CHANNELS.TAB.BASE_INFO', N'基本信息', N'基本信息', N'zh-CN',N'基本信息';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.TRM.EQUIPT.CHANNELS.BUTTON.BUTTON', N'按钮', N'按钮', N'zh-CN',N'按钮';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.TRM.EQUIPT.CHANNELS.TIP.TIP', N'提示框', N'提示框', N'zh-CN',N'提示框';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.TRM.EQUIPT.CHANNELS.MODAL.MODAL', N'对话框', N'对话框', N'zh-CN',N'对话框';
|
|
|
|
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
|
|
VALUES ('T_LIMS_EQUIPT_CHANNEL', '0', '0');
|
|
|
|
|
|
-- ----------------------------- 2022-08-31 add by lijiaxing------------end
|
|
-- ----------------------------- 2022-09-01 add by lijiaxing--------------begin
|
|
|
|
-- 建表语句
|
|
CREATE TABlE DBO.T_LIMS_EQUIPT_AUXILIARY(
|
|
ID BIGINT NOT NULL,
|
|
CREATEDBYID VARCHAR(36) NULL ,
|
|
CREATEDBYNAME VARCHAR(60) NULL ,
|
|
CREATEDTIME DATETIME NULL ,
|
|
CREATEDBYORGID VARCHAR(36) NULL ,
|
|
CREATEDBYORGNAME VARCHAR(270) NULL ,
|
|
EQUIPTID BIGINT NULL ,
|
|
AUXILIARYID BIGINT NULL ,
|
|
REMARKS VARCHAR(360) NULL ,
|
|
CONSTRAINT PK_LIMS_EQUIPT_AUXILIARY PRIMARY KEY(ID));
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'辅助设备表' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_AUXILIARY';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_AUXILIARY', @level2type=N'COLUMN',@level2name=N'ID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人编码' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_AUXILIARY', @level2type=N'COLUMN',@level2name=N'CREATEDBYID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人名称' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_AUXILIARY', @level2type=N'COLUMN',@level2name=N'CREATEDBYNAME';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单时间' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_AUXILIARY', @level2type=N'COLUMN',@level2name=N'CREATEDTIME';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人单位编码' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_AUXILIARY', @level2type=N'COLUMN',@level2name=N'CREATEDBYORGID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人单位名称' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_AUXILIARY', @level2type=N'COLUMN',@level2name=N'CREATEDBYORGNAME';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'设备ID' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_AUXILIARY', @level2type=N'COLUMN',@level2name=N'EQUIPTID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'辅助设备ID' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_AUXILIARY', @level2type=N'COLUMN',@level2name=N'AUXILIARYID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_AUXILIARY', @level2type=N'COLUMN',@level2name=N'REMARKS';
|
|
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_AUXILIARY.SERVICE_NAME', N'辅助设备表', N'辅助设备表', N'zh-CN',N'辅助设备表';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_AUXILIARY.ID', N'辅助设备表的主键', N'主键', N'zh-CN',N'主键';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_AUXILIARY.CREATEDBYID', N'辅助设备表的制单人编码', N'制单人编码', N'zh-CN',N'制单人编码';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_AUXILIARY.CREATEDBYNAME', N'辅助设备表的制单人名称', N'制单人名称', N'zh-CN',N'制单人名称';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_AUXILIARY.CREATEDTIME', N'辅助设备表的制单时间', N'制单时间', N'zh-CN',N'制单时间';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_AUXILIARY.CREATEDBYORGID', N'辅助设备表的制单人单位编码', N'制单人单位编码', N'zh-CN',N'制单人单位编码';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_AUXILIARY.CREATEDBYORGNAME', N'辅助设备表的制单人单位名称', N'制单人单位名称', N'zh-CN',N'制单人单位名称';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_AUXILIARY.EQUIPTID', N'辅助设备表的设备ID', N'设备ID', N'zh-CN',N'设备ID';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_AUXILIARY.AUXILIARYID', N'辅助设备表的辅助设备ID', N'辅助设备ID', N'zh-CN',N'辅助设备ID';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_AUXILIARY.REMARKS', N'辅助设备表的备注', N'备注', N'zh-CN',N'备注';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.TRM.EQUIPT.AUXILIARYS.MODAL.ADD', N'新增', N'新增', N'zh-CN',N'新增';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.TRM.EQUIPT.AUXILIARYS.TAB.BASE_INFO', N'基本信息', N'基本信息', N'zh-CN',N'基本信息';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.TRM.EQUIPT.AUXILIARYS.BUTTON.BUTTON', N'按钮', N'按钮', N'zh-CN',N'按钮';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.TRM.EQUIPT.AUXILIARYS.TIP.TIP', N'提示框', N'提示框', N'zh-CN',N'提示框';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.TRM.EQUIPT.AUXILIARYS.MODAL.MODAL', N'对话框', N'对话框', N'zh-CN',N'对话框';
|
|
|
|
|
|
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
|
|
VALUES ('T_LIMS_EQUIPT_AUXILIARY', '0', '0');
|
|
|
|
|
|
-- ----------------------------- 2022-09-01 add by lijiaxing------------end
|
|
-- ----------------------------- 2022-09-01 add by lijiaxing--------------begin
|
|
|
|
-- 建表语句
|
|
CREATE TABlE DBO.T_LIMS_EQUIPT_EVENT(
|
|
ID BIGINT NOT NULL,
|
|
CREATEDBYID VARCHAR(36) NULL ,
|
|
CREATEDBYNAME VARCHAR(60) NULL ,
|
|
CREATEDTIME DATETIME NULL ,
|
|
CREATEDBYORGID VARCHAR(36) NULL ,
|
|
CREATEDBYORGNAME VARCHAR(270) NULL ,
|
|
EQUIPTID BIGINT NULL ,
|
|
EVENTTYPE VARCHAR(36) NULL ,
|
|
EVENTFREQUENCY VARCHAR(36) NULL ,
|
|
EVENTDESC VARCHAR(360) NULL ,
|
|
PLANDATE DATETIME NULL ,
|
|
REMINDDAYS BIGINT NULL ,
|
|
REMARKS VARCHAR(360) NULL ,
|
|
CONSTRAINT PK_LIMS_EQUIPT_EVENT PRIMARY KEY(ID));
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'设备事件表' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_EVENT';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_EVENT', @level2type=N'COLUMN',@level2name=N'ID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人编码' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_EVENT', @level2type=N'COLUMN',@level2name=N'CREATEDBYID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人名称' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_EVENT', @level2type=N'COLUMN',@level2name=N'CREATEDBYNAME';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单时间' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_EVENT', @level2type=N'COLUMN',@level2name=N'CREATEDTIME';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人单位编码' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_EVENT', @level2type=N'COLUMN',@level2name=N'CREATEDBYORGID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人单位名称' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_EVENT', @level2type=N'COLUMN',@level2name=N'CREATEDBYORGNAME';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'设备ID' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_EVENT', @level2type=N'COLUMN',@level2name=N'EQUIPTID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'事件类型' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_EVENT', @level2type=N'COLUMN',@level2name=N'EVENTTYPE';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'事件频率' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_EVENT', @level2type=N'COLUMN',@level2name=N'EVENTFREQUENCY';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'事件描述' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_EVENT', @level2type=N'COLUMN',@level2name=N'EVENTDESC';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'计划日期' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_EVENT', @level2type=N'COLUMN',@level2name=N'PLANDATE';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'提醒天数' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_EVENT', @level2type=N'COLUMN',@level2name=N'REMINDDAYS';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_EVENT', @level2type=N'COLUMN',@level2name=N'REMARKS';
|
|
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_EVENT.SERVICE_NAME', N'设备事件表', N'设备事件表', N'zh-CN',N'设备事件表';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_EVENT.ID', N'设备事件表的主键', N'主键', N'zh-CN',N'主键';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_EVENT.CREATEDBYID', N'设备事件表的制单人编码', N'制单人编码', N'zh-CN',N'制单人编码';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_EVENT.CREATEDBYNAME', N'设备事件表的制单人名称', N'制单人名称', N'zh-CN',N'制单人名称';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_EVENT.CREATEDTIME', N'设备事件表的制单时间', N'制单时间', N'zh-CN',N'制单时间';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_EVENT.CREATEDBYORGID', N'设备事件表的制单人单位编码', N'制单人单位编码', N'zh-CN',N'制单人单位编码';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_EVENT.CREATEDBYORGNAME', N'设备事件表的制单人单位名称', N'制单人单位名称', N'zh-CN',N'制单人单位名称';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_EVENT.EQUIPTID', N'设备事件表的设备ID', N'设备ID', N'zh-CN',N'设备ID';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_EVENT.EVENTTYPE', N'设备事件表的事件类型', N'事件类型', N'zh-CN',N'事件类型';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_EVENT.EVENTFREQUENCY', N'设备事件表的事件频率', N'事件频率', N'zh-CN',N'事件频率';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_EVENT.EVENTDESC', N'设备事件表的事件描述', N'事件描述', N'zh-CN',N'事件描述';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_EVENT.PLANDATE', N'设备事件表的计划日期', N'计划日期', N'zh-CN',N'计划日期';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_EVENT.REMINDDAYS', N'设备事件表的提醒天数', N'提醒天数', N'zh-CN',N'提醒天数';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_EVENT.REMARKS', N'设备事件表的备注', N'备注', N'zh-CN',N'备注';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.TRM.EQUIPT.EVENTS.MODAL.ADD', N'新增', N'新增', N'zh-CN',N'新增';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.TRM.EQUIPT.EVENTS.TAB.BASE_INFO', N'基本信息', N'基本信息', N'zh-CN',N'基本信息';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.TRM.EQUIPT.EVENTS.BUTTON.BUTTON', N'按钮', N'按钮', N'zh-CN',N'按钮';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.TRM.EQUIPT.EVENTS.TIP.TIP', N'提示框', N'提示框', N'zh-CN',N'提示框';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.TRM.EQUIPT.EVENTS.MODAL.MODAL', N'对话框', N'对话框', N'zh-CN',N'对话框';
|
|
|
|
|
|
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
|
|
VALUES ('T_LIMS_EQUIPT_EVENT', '0', '0');
|
|
|
|
|
|
-- ----------------------------- 2022-09-01 add by lijiaxing------------end
|
|
-- ----------------------------- 2022-09-01 add by lijiaxing--------------begin
|
|
|
|
-- 建表语句
|
|
CREATE TABlE DBO.T_LIMS_EQUIPT_EVENT_RECORD(
|
|
ID BIGINT NOT NULL,
|
|
CREATEDBYID VARCHAR(36) NULL ,
|
|
CREATEDBYNAME VARCHAR(60) NULL ,
|
|
CREATEDTIME DATETIME NULL ,
|
|
CREATEDBYORGID VARCHAR(36) NULL ,
|
|
CREATEDBYORGNAME VARCHAR(270) NULL ,
|
|
EVENTID BIGINT NULL ,
|
|
EVENTCONTENT VARCHAR(360) NULL ,
|
|
RECORDDATE DATETIME NULL ,
|
|
RECORDERID VARCHAR(36) NULL ,
|
|
RECORDER VARCHAR(60) NULL ,
|
|
REMARKS VARCHAR(360) NULL ,
|
|
CONSTRAINT PK_LIMS_EQUIPT_EVENT_RECORD PRIMARY KEY(ID));
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'设备事件记录表' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_EVENT_RECORD';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_EVENT_RECORD', @level2type=N'COLUMN',@level2name=N'ID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人编码' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_EVENT_RECORD', @level2type=N'COLUMN',@level2name=N'CREATEDBYID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人名称' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_EVENT_RECORD', @level2type=N'COLUMN',@level2name=N'CREATEDBYNAME';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单时间' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_EVENT_RECORD', @level2type=N'COLUMN',@level2name=N'CREATEDTIME';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人单位编码' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_EVENT_RECORD', @level2type=N'COLUMN',@level2name=N'CREATEDBYORGID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人单位名称' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_EVENT_RECORD', @level2type=N'COLUMN',@level2name=N'CREATEDBYORGNAME';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'事件ID' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_EVENT_RECORD', @level2type=N'COLUMN',@level2name=N'EVENTID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'事件内容' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_EVENT_RECORD', @level2type=N'COLUMN',@level2name=N'EVENTCONTENT';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'记录时间' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_EVENT_RECORD', @level2type=N'COLUMN',@level2name=N'RECORDDATE';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'记录人ID' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_EVENT_RECORD', @level2type=N'COLUMN',@level2name=N'RECORDERID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'记录人' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_EVENT_RECORD', @level2type=N'COLUMN',@level2name=N'RECORDER';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_EVENT_RECORD', @level2type=N'COLUMN',@level2name=N'REMARKS';
|
|
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_EVENT_RECORD.SERVICE_NAME', N'设备事件记录表', N'设备事件记录表', N'zh-CN',N'设备事件记录表';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_EVENT_RECORD.ID', N'设备事件记录表的主键', N'主键', N'zh-CN',N'主键';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_EVENT_RECORD.CREATEDBYID', N'设备事件记录表的制单人编码', N'制单人编码', N'zh-CN',N'制单人编码';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_EVENT_RECORD.CREATEDBYNAME', N'设备事件记录表的制单人名称', N'制单人名称', N'zh-CN',N'制单人名称';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_EVENT_RECORD.CREATEDTIME', N'设备事件记录表的制单时间', N'制单时间', N'zh-CN',N'制单时间';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_EVENT_RECORD.CREATEDBYORGID', N'设备事件记录表的制单人单位编码', N'制单人单位编码', N'zh-CN',N'制单人单位编码';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_EVENT_RECORD.CREATEDBYORGNAME', N'设备事件记录表的制单人单位名称', N'制单人单位名称', N'zh-CN',N'制单人单位名称';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_EVENT_RECORD.EVENTID', N'设备事件记录表的事件ID', N'事件ID', N'zh-CN',N'事件ID';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_EVENT_RECORD.EVENTCONTENT', N'设备事件记录表的事件内容', N'事件内容', N'zh-CN',N'事件内容';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_EVENT_RECORD.RECORDDATE', N'设备事件记录表的记录时间', N'记录时间', N'zh-CN',N'记录时间';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_EVENT_RECORD.RECORDERID', N'设备事件记录表的记录人ID', N'记录人ID', N'zh-CN',N'记录人ID';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_EVENT_RECORD.RECORDER', N'设备事件记录表的记录人', N'记录人', N'zh-CN',N'记录人';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_EVENT_RECORD.REMARKS', N'设备事件记录表的备注', N'备注', N'zh-CN',N'备注';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.TRM.EQUIPT.EVENTRECORDS.MODAL.ADD', N'新增', N'新增', N'zh-CN',N'新增';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.TRM.EQUIPT.EVENTRECORDS.TAB.BASE_INFO', N'基本信息', N'基本信息', N'zh-CN',N'基本信息';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.TRM.EQUIPT.EVENTRECORDS.BUTTON.BUTTON', N'按钮', N'按钮', N'zh-CN',N'按钮';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.TRM.EQUIPT.EVENTRECORDS.TIP.TIP', N'提示框', N'提示框', N'zh-CN',N'提示框';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.TRM.EQUIPT.EVENTRECORDS.MODAL.MODAL', N'对话框', N'对话框', N'zh-CN',N'对话框';
|
|
|
|
|
|
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
|
|
VALUES ('T_LIMS_EQUIPT_EVENT_RECORD', '0', '0');
|
|
|
|
|
|
-- ----------------------------- 2022-09-01 add by lijiaxing------------end
|
|
-- ----------------------------- 2022-09-01 add by lijiaxing--------------begin
|
|
|
|
-- 建表语句
|
|
CREATE TABlE DBO.T_LIMS_EQUIPT_MAINTAIN_PLAN(
|
|
ID BIGINT NOT NULL,
|
|
CREATEDBYID VARCHAR(36) NULL ,
|
|
CREATEDBYNAME VARCHAR(60) NULL ,
|
|
CREATEDTIME DATETIME NULL ,
|
|
CREATEDBYORGID VARCHAR(36) NULL ,
|
|
CREATEDBYORGNAME VARCHAR(270) NULL ,
|
|
PROCESSSTATUS VARCHAR(36) NULL ,
|
|
EQUIPTID BIGINT NULL ,
|
|
MAINTAINTYPE VARCHAR(36) NULL ,
|
|
MAINTAINFREQUENCY VARCHAR(36) NULL ,
|
|
MAINTAINDESC VARCHAR(360) NULL ,
|
|
PLANDATE DATETIME NULL ,
|
|
REMINDDAYS BIGINT NULL ,
|
|
REMARKS VARCHAR(360) NULL ,
|
|
CONSTRAINT PK_LIMS_EQUIPT_MAINTAIN_PLAN PRIMARY KEY(ID));
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'设备保养点检计划表' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_MAINTAIN_PLAN';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_MAINTAIN_PLAN', @level2type=N'COLUMN',@level2name=N'ID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人编码' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_MAINTAIN_PLAN', @level2type=N'COLUMN',@level2name=N'CREATEDBYID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人名称' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_MAINTAIN_PLAN', @level2type=N'COLUMN',@level2name=N'CREATEDBYNAME';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单时间' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_MAINTAIN_PLAN', @level2type=N'COLUMN',@level2name=N'CREATEDTIME';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人单位编码' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_MAINTAIN_PLAN', @level2type=N'COLUMN',@level2name=N'CREATEDBYORGID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人单位名称' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_MAINTAIN_PLAN', @level2type=N'COLUMN',@level2name=N'CREATEDBYORGNAME';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'流程状态' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_MAINTAIN_PLAN', @level2type=N'COLUMN',@level2name=N'PROCESSSTATUS';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'设备ID' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_MAINTAIN_PLAN', @level2type=N'COLUMN',@level2name=N'EQUIPTID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'类型' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_MAINTAIN_PLAN', @level2type=N'COLUMN',@level2name=N'MAINTAINTYPE';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'保养/点检频率' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_MAINTAIN_PLAN', @level2type=N'COLUMN',@level2name=N'MAINTAINFREQUENCY';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'保养/点检描述' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_MAINTAIN_PLAN', @level2type=N'COLUMN',@level2name=N'MAINTAINDESC';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'计划保养/点检日期' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_MAINTAIN_PLAN', @level2type=N'COLUMN',@level2name=N'PLANDATE';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'提醒天数' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_MAINTAIN_PLAN', @level2type=N'COLUMN',@level2name=N'REMINDDAYS';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_MAINTAIN_PLAN', @level2type=N'COLUMN',@level2name=N'REMARKS';
|
|
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_MAINTAIN_PLAN.SERVICE_NAME', N'设备保养点检计划表', N'设备保养点检计划表', N'zh-CN',N'设备保养点检计划表';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_MAINTAIN_PLAN.ID', N'设备保养点检计划表的主键', N'主键', N'zh-CN',N'主键';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_MAINTAIN_PLAN.CREATEDBYID', N'设备保养点检计划表的制单人编码', N'制单人编码', N'zh-CN',N'制单人编码';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_MAINTAIN_PLAN.CREATEDBYNAME', N'设备保养点检计划表的制单人名称', N'制单人名称', N'zh-CN',N'制单人名称';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_MAINTAIN_PLAN.CREATEDTIME', N'设备保养点检计划表的制单时间', N'制单时间', N'zh-CN',N'制单时间';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_MAINTAIN_PLAN.CREATEDBYORGID', N'设备保养点检计划表的制单人单位编码', N'制单人单位编码', N'zh-CN',N'制单人单位编码';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_MAINTAIN_PLAN.CREATEDBYORGNAME', N'设备保养点检计划表的制单人单位名称', N'制单人单位名称', N'zh-CN',N'制单人单位名称';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_MAINTAIN_PLAN.PROCESSSTATUS', N'设备保养点检计划表的流程状态', N'流程状态', N'zh-CN',N'流程状态';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_MAINTAIN_PLAN.EQUIPTID', N'设备保养点检计划表的设备ID', N'设备ID', N'zh-CN',N'设备ID';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_MAINTAIN_PLAN.MAINTAINTYPE', N'设备保养点检计划表的类型', N'类型', N'zh-CN',N'类型';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_MAINTAIN_PLAN.MAINTAINFREQUENCY', N'设备保养点检计划表的保养/点检频率', N'保养/点检频率', N'zh-CN',N'保养/点检频率';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_MAINTAIN_PLAN.MAINTAINDESC', N'设备保养点检计划表的保养/点检描述', N'保养/点检描述', N'zh-CN',N'保养/点检描述';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_MAINTAIN_PLAN.PLANDATE', N'设备保养点检计划表的计划保养/点检日期', N'计划保养/点检日期', N'zh-CN',N'计划保养/点检日期';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_MAINTAIN_PLAN.REMINDDAYS', N'设备保养点检计划表的提醒天数', N'提醒天数', N'zh-CN',N'提醒天数';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_MAINTAIN_PLAN.REMARKS', N'设备保养点检计划表的备注', N'备注', N'zh-CN',N'备注';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.TRM.EQUIPT.MAINTAINS.MODAL.ADD', N'新增', N'新增', N'zh-CN',N'新增';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.TRM.EQUIPT.MAINTAINS.TAB.BASE_INFO', N'基本信息', N'基本信息', N'zh-CN',N'基本信息';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.TRM.EQUIPT.MAINTAINS.BUTTON.BUTTON', N'按钮', N'按钮', N'zh-CN',N'按钮';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.TRM.EQUIPT.MAINTAINS.TIP.TIP', N'提示框', N'提示框', N'zh-CN',N'提示框';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.TRM.EQUIPT.MAINTAINS.MODAL.MODAL', N'对话框', N'对话框', N'zh-CN',N'对话框';
|
|
|
|
|
|
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');
|
|
|
|
|
|
-- ----------------------------- 2022-09-01 add by lijiaxing------------end
|
|
-- ----------------------------- 2022-09-01 add by lijiaxing--------------begin
|
|
|
|
-- 建表语句
|
|
CREATE TABlE DBO.T_LIMS_EQUIPT_MAINTAIN_ITEM(
|
|
ID BIGINT NOT NULL,
|
|
CREATEDBYID VARCHAR(36) NULL ,
|
|
CREATEDBYNAME VARCHAR(60) NULL ,
|
|
CREATEDTIME DATETIME NULL ,
|
|
CREATEDBYORGID VARCHAR(36) NULL ,
|
|
CREATEDBYORGNAME VARCHAR(270) NULL ,
|
|
MAINTAINID BIGINT NULL ,
|
|
MAINTAINSPOTCHECKID BIGINT NULL ,
|
|
MAINTAINTYPE VARCHAR(36) NULL ,
|
|
MAINTAINITEM VARCHAR(120) NULL ,
|
|
MAINTAINMETHOD VARCHAR(360) NULL ,
|
|
REMARKS VARCHAR(360) NULL ,
|
|
CONSTRAINT PK_LIMS_EQUIPT_MAINTAIN_ITEM PRIMARY KEY(ID));
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'设备保养点检项目表' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_MAINTAIN_ITEM';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_MAINTAIN_ITEM', @level2type=N'COLUMN',@level2name=N'ID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人编码' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_MAINTAIN_ITEM', @level2type=N'COLUMN',@level2name=N'CREATEDBYID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人名称' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_MAINTAIN_ITEM', @level2type=N'COLUMN',@level2name=N'CREATEDBYNAME';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单时间' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_MAINTAIN_ITEM', @level2type=N'COLUMN',@level2name=N'CREATEDTIME';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人单位编码' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_MAINTAIN_ITEM', @level2type=N'COLUMN',@level2name=N'CREATEDBYORGID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人单位名称' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_MAINTAIN_ITEM', @level2type=N'COLUMN',@level2name=N'CREATEDBYORGNAME';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'保养点检计划ID' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_MAINTAIN_ITEM', @level2type=N'COLUMN',@level2name=N'MAINTAINID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'保养点检项目ID' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_MAINTAIN_ITEM', @level2type=N'COLUMN',@level2name=N'MAINTAINSPOTCHECKID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'项目类型' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_MAINTAIN_ITEM', @level2type=N'COLUMN',@level2name=N'MAINTAINTYPE';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'保养/点检项目' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_MAINTAIN_ITEM', @level2type=N'COLUMN',@level2name=N'MAINTAINITEM';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'保养/点检方法' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_MAINTAIN_ITEM', @level2type=N'COLUMN',@level2name=N'MAINTAINMETHOD';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_MAINTAIN_ITEM', @level2type=N'COLUMN',@level2name=N'REMARKS';
|
|
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_MAINTAIN_ITEM.SERVICE_NAME', N'设备保养点检项目表', N'设备保养点检项目表', N'zh-CN',N'设备保养点检项目表';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_MAINTAIN_ITEM.ID', N'设备保养点检项目表的主键', N'主键', N'zh-CN',N'主键';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_MAINTAIN_ITEM.CREATEDBYID', N'设备保养点检项目表的制单人编码', N'制单人编码', N'zh-CN',N'制单人编码';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_MAINTAIN_ITEM.CREATEDBYNAME', N'设备保养点检项目表的制单人名称', N'制单人名称', N'zh-CN',N'制单人名称';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_MAINTAIN_ITEM.CREATEDTIME', N'设备保养点检项目表的制单时间', N'制单时间', N'zh-CN',N'制单时间';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_MAINTAIN_ITEM.CREATEDBYORGID', N'设备保养点检项目表的制单人单位编码', N'制单人单位编码', N'zh-CN',N'制单人单位编码';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_MAINTAIN_ITEM.CREATEDBYORGNAME', N'设备保养点检项目表的制单人单位名称', N'制单人单位名称', N'zh-CN',N'制单人单位名称';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_MAINTAIN_ITEM.MAINTAINID', N'设备保养点检项目表的保养点检计划ID', N'保养点检计划ID', N'zh-CN',N'保养点检计划ID';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_MAINTAIN_ITEM.MAINTAINSPOTCHECKID', N'设备保养点检项目表的保养点检项目ID', N'保养点检项目ID', N'zh-CN',N'保养点检项目ID';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_MAINTAIN_ITEM.MAINTAINTYPE', N'设备保养点检项目表的项目类型', N'项目类型', N'zh-CN',N'项目类型';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_MAINTAIN_ITEM.MAINTAINITEM', N'设备保养点检项目表的保养/点检项目', N'保养/点检项目', N'zh-CN',N'保养/点检项目';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_MAINTAIN_ITEM.MAINTAINMETHOD', N'设备保养点检项目表的保养/点检方法', N'保养/点检方法', N'zh-CN',N'保养/点检方法';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_MAINTAIN_ITEM.REMARKS', N'设备保养点检项目表的备注', N'备注', N'zh-CN',N'备注';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.TRM.EQUIPT.MAINTAINITEMS.MODAL.ADD', N'新增', N'新增', N'zh-CN',N'新增';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.TRM.EQUIPT.MAINTAINITEMS.TAB.BASE_INFO', N'基本信息', N'基本信息', N'zh-CN',N'基本信息';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.TRM.EQUIPT.MAINTAINITEMS.BUTTON.BUTTON', N'按钮', N'按钮', N'zh-CN',N'按钮';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.TRM.EQUIPT.MAINTAINITEMS.TIP.TIP', N'提示框', N'提示框', N'zh-CN',N'提示框';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.TRM.EQUIPT.MAINTAINITEMS.MODAL.MODAL', N'对话框', N'对话框', N'zh-CN',N'对话框';
|
|
|
|
|
|
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
|
|
VALUES ('T_LIMS_EQUIPT_MAINTAIN_ITEM', '0', '0');
|
|
|
|
|
|
-- ----------------------------- 2022-09-01 add by lijiaxing------------end
|
|
|
|
-- ----------------------------- 2022-09-01 add by lijiaxing--------------begin
|
|
|
|
-- 建表语句
|
|
CREATE TABlE DBO.T_LIMS_EQUIPT_MAINTAIN_RECORD(
|
|
ID BIGINT NOT NULL,
|
|
CREATEDBYID VARCHAR(36) NULL ,
|
|
CREATEDBYNAME VARCHAR(60) NULL ,
|
|
CREATEDTIME DATETIME NULL ,
|
|
CREATEDBYORGID VARCHAR(36) NULL ,
|
|
CREATEDBYORGNAME VARCHAR(270) NULL ,
|
|
EQUIPTID BIGINT NULL ,
|
|
MAINTAINID BIGINT NULL ,
|
|
MAINTAINITEMID BIGINT NULL ,
|
|
MAINTAINTYPE VARCHAR(36) NULL ,
|
|
MAINTAINITEM VARCHAR(120) NULL ,
|
|
MAINTAINMETHOD VARCHAR(360) NULL ,
|
|
MAINTAINRESULT VARCHAR(36) NULL ,
|
|
MAINTAINRECORD VARCHAR(360) NULL ,
|
|
MAINTAINDATE DATETIME NULL ,
|
|
RECORDERID VARCHAR(36) NULL ,
|
|
RECORDER VARCHAR(60) NULL ,
|
|
REMARKS VARCHAR(360) NULL ,
|
|
CONSTRAINT PK_LIMS_EQUIPT_MAINTAIN_RECORD PRIMARY KEY(ID));
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'设备保养点检记录表' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_MAINTAIN_RECORD';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_MAINTAIN_RECORD', @level2type=N'COLUMN',@level2name=N'ID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人编码' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_MAINTAIN_RECORD', @level2type=N'COLUMN',@level2name=N'CREATEDBYID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人名称' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_MAINTAIN_RECORD', @level2type=N'COLUMN',@level2name=N'CREATEDBYNAME';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单时间' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_MAINTAIN_RECORD', @level2type=N'COLUMN',@level2name=N'CREATEDTIME';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人单位编码' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_MAINTAIN_RECORD', @level2type=N'COLUMN',@level2name=N'CREATEDBYORGID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人单位名称' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_MAINTAIN_RECORD', @level2type=N'COLUMN',@level2name=N'CREATEDBYORGNAME';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'设备ID' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_MAINTAIN_RECORD', @level2type=N'COLUMN',@level2name=N'EQUIPTID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'保养点检计划ID' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_MAINTAIN_RECORD', @level2type=N'COLUMN',@level2name=N'MAINTAINID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'保养点检项目ID' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_MAINTAIN_RECORD', @level2type=N'COLUMN',@level2name=N'MAINTAINITEMID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'项目类型' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_MAINTAIN_RECORD', @level2type=N'COLUMN',@level2name=N'MAINTAINTYPE';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'保养/点检项目' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_MAINTAIN_RECORD', @level2type=N'COLUMN',@level2name=N'MAINTAINITEM';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'保养/点检方法' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_MAINTAIN_RECORD', @level2type=N'COLUMN',@level2name=N'MAINTAINMETHOD';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'保养/点检结果' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_MAINTAIN_RECORD', @level2type=N'COLUMN',@level2name=N'MAINTAINRESULT';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'保养/点检记录' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_MAINTAIN_RECORD', @level2type=N'COLUMN',@level2name=N'MAINTAINRECORD';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'保养/点检时间' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_MAINTAIN_RECORD', @level2type=N'COLUMN',@level2name=N'MAINTAINDATE';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'记录人ID' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_MAINTAIN_RECORD', @level2type=N'COLUMN',@level2name=N'RECORDERID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'记录人' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_MAINTAIN_RECORD', @level2type=N'COLUMN',@level2name=N'RECORDER';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_MAINTAIN_RECORD', @level2type=N'COLUMN',@level2name=N'REMARKS';
|
|
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_MAINTAIN_RECORD.SERVICE_NAME', N'设备保养点检记录表', N'设备保养点检记录表', N'zh-CN',N'设备保养点检记录表';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_MAINTAIN_RECORD.ID', N'设备保养点检记录表的主键', N'主键', N'zh-CN',N'主键';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_MAINTAIN_RECORD.CREATEDBYID', N'设备保养点检记录表的制单人编码', N'制单人编码', N'zh-CN',N'制单人编码';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_MAINTAIN_RECORD.CREATEDBYNAME', N'设备保养点检记录表的制单人名称', N'制单人名称', N'zh-CN',N'制单人名称';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_MAINTAIN_RECORD.CREATEDTIME', N'设备保养点检记录表的制单时间', N'制单时间', N'zh-CN',N'制单时间';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_MAINTAIN_RECORD.CREATEDBYORGID', N'设备保养点检记录表的制单人单位编码', N'制单人单位编码', N'zh-CN',N'制单人单位编码';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_MAINTAIN_RECORD.CREATEDBYORGNAME', N'设备保养点检记录表的制单人单位名称', N'制单人单位名称', N'zh-CN',N'制单人单位名称';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_MAINTAIN_RECORD.EQUIPTID', N'设备保养点检记录表的设备ID', N'设备ID', N'zh-CN',N'设备ID';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_MAINTAIN_RECORD.MAINTAINID', N'设备保养点检记录表的保养点检计划ID', N'保养点检计划ID', N'zh-CN',N'保养点检计划ID';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_MAINTAIN_RECORD.MAINTAINTYPE', N'设备保养点检记录表的项目类型', N'项目类型', N'zh-CN',N'项目类型';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_MAINTAIN_RECORD.MAINTAINITEM', N'设备保养点检记录表的保养/点检项目', N'保养/点检项目', N'zh-CN',N'保养/点检项目';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_MAINTAIN_RECORD.MAINTAINMETHOD', N'设备保养点检记录表的保养/点检方法', N'保养/点检方法', N'zh-CN',N'保养/点检方法';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_MAINTAIN_RECORD.MAINTAINRESULT', N'设备保养点检记录表的保养/点检结果', N'保养/点检结果', N'zh-CN',N'保养/点检结果';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_MAINTAIN_RECORD.MAINTAINRECORD', N'设备保养点检记录表的保养/点检记录', N'保养/点检记录', N'zh-CN',N'保养/点检记录';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_MAINTAIN_RECORD.MAINTAINDATE', N'设备保养点检记录表的保养/点检时间', N'保养/点检时间', N'zh-CN',N'保养/点检时间';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_MAINTAIN_RECORD.RECORDERID', N'设备保养点检记录表的记录人ID', N'记录人ID', N'zh-CN',N'记录人ID';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_MAINTAIN_RECORD.RECORDER', N'设备保养点检记录表的记录人', N'记录人', N'zh-CN',N'记录人';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_MAINTAIN_RECORD.REMARKS', N'设备保养点检记录表的备注', N'备注', N'zh-CN',N'备注';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.TRM.EQUIPT.MAINTAINRECORDS.MODAL.ADD', N'新增', N'新增', N'zh-CN',N'新增';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.TRM.EQUIPT.MAINTAINRECORDS.TAB.BASE_INFO', N'基本信息', N'基本信息', N'zh-CN',N'基本信息';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.TRM.EQUIPT.MAINTAINRECORDS.BUTTON.BUTTON', N'按钮', N'按钮', N'zh-CN',N'按钮';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.TRM.EQUIPT.MAINTAINRECORDS.TIP.TIP', N'提示框', N'提示框', N'zh-CN',N'提示框';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.TRM.EQUIPT.MAINTAINRECORDS.MODAL.MODAL', N'对话框', N'对话框', N'zh-CN',N'对话框';
|
|
|
|
|
|
INSERT INTO T_CORE_TABLE (ID, AUDITABLE, ATTACHMENT)
|
|
VALUES ('T_LIMS_EQUIPT_MAINTAIN_RECORD', '0', '0');
|
|
|
|
|
|
-- ----------------------------- 2022-09-01 add by lijiaxing------------end
|
|
-- ----------------------------- 2022-09-01 add by lijiaxing--------------begin
|
|
|
|
-- 建表语句
|
|
CREATE TABlE DBO.T_LIMS_EQUIPT_REPAIR(
|
|
ID BIGINT NOT NULL,
|
|
CREATEDBYID VARCHAR(36) NULL ,
|
|
CREATEDBYNAME VARCHAR(60) NULL ,
|
|
CREATEDTIME DATETIME NULL ,
|
|
CREATEDBYORGID VARCHAR(36) NULL ,
|
|
CREATEDBYORGNAME VARCHAR(270) NULL ,
|
|
PROCESSSTATUS VARCHAR(36) NULL ,
|
|
EQUIPTID BIGINT NULL ,
|
|
APPLICANTID VARCHAR(36) NULL ,
|
|
APPLICANT VARCHAR(60) NULL ,
|
|
APPLYDATE DATETIME NULL ,
|
|
APPLYDEPTID VARCHAR(36) NULL ,
|
|
APPLYDEPT VARCHAR(270) NULL ,
|
|
FAULTDATE DATETIME NULL ,
|
|
FAULTDESC VARCHAR(360) NULL ,
|
|
EXPECTDATE DATETIME NULL ,
|
|
FAULTREASON VARCHAR(360) NULL ,
|
|
REPAIRMEASURE VARCHAR(360) NULL ,
|
|
FINISHDATE DATETIME NULL ,
|
|
STOPHOURS DECIMAL(8,2) NULL ,
|
|
REPAIRPERSONID VARCHAR(36) NULL ,
|
|
REPAIRPERSON VARCHAR(60) NULL ,
|
|
REPAIRCOST DECIMAL(8,2) NULL ,
|
|
REMARKS VARCHAR(360) NULL ,
|
|
CONSTRAINT PK_LIMS_EQUIPT_REPAIR PRIMARY KEY(ID));
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'设备维修表' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_REPAIR';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_REPAIR', @level2type=N'COLUMN',@level2name=N'ID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人编码' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_REPAIR', @level2type=N'COLUMN',@level2name=N'CREATEDBYID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人名称' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_REPAIR', @level2type=N'COLUMN',@level2name=N'CREATEDBYNAME';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单时间' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_REPAIR', @level2type=N'COLUMN',@level2name=N'CREATEDTIME';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人单位编码' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_REPAIR', @level2type=N'COLUMN',@level2name=N'CREATEDBYORGID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'制单人单位名称' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_REPAIR', @level2type=N'COLUMN',@level2name=N'CREATEDBYORGNAME';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'流程状态' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_REPAIR', @level2type=N'COLUMN',@level2name=N'PROCESSSTATUS';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'设备ID' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_REPAIR', @level2type=N'COLUMN',@level2name=N'EQUIPTID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'申请人ID' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_REPAIR', @level2type=N'COLUMN',@level2name=N'APPLICANTID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'申请人' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_REPAIR', @level2type=N'COLUMN',@level2name=N'APPLICANT';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'申请时间' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_REPAIR', @level2type=N'COLUMN',@level2name=N'APPLYDATE';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'申请部门ID' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_REPAIR', @level2type=N'COLUMN',@level2name=N'APPLYDEPTID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'申请部门' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_REPAIR', @level2type=N'COLUMN',@level2name=N'APPLYDEPT';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'故障发生时间' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_REPAIR', @level2type=N'COLUMN',@level2name=N'FAULTDATE';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'故障描述' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_REPAIR', @level2type=N'COLUMN',@level2name=N'FAULTDESC';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'期望修复日期' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_REPAIR', @level2type=N'COLUMN',@level2name=N'EXPECTDATE';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'故障原因分析' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_REPAIR', @level2type=N'COLUMN',@level2name=N'FAULTREASON';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'故障维修措施' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_REPAIR', @level2type=N'COLUMN',@level2name=N'REPAIRMEASURE';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'完成时间' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_REPAIR', @level2type=N'COLUMN',@level2name=N'FINISHDATE';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'停机时长' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_REPAIR', @level2type=N'COLUMN',@level2name=N'STOPHOURS';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'维修人员ID' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_REPAIR', @level2type=N'COLUMN',@level2name=N'REPAIRPERSONID';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'维修人员' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_REPAIR', @level2type=N'COLUMN',@level2name=N'REPAIRPERSON';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'维修费用' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_REPAIR', @level2type=N'COLUMN',@level2name=N'REPAIRCOST';
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE',@level1name=N'T_LIMS_EQUIPT_REPAIR', @level2type=N'COLUMN',@level2name=N'REMARKS';
|
|
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_REPAIR.SERVICE_NAME', N'设备维修表', N'设备维修表', N'zh-CN',N'设备维修表';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_REPAIR.ID', N'设备维修表的主键', N'主键', N'zh-CN',N'主键';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_REPAIR.CREATEDBYID', N'设备维修表的制单人编码', N'制单人编码', N'zh-CN',N'制单人编码';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_REPAIR.CREATEDBYNAME', N'设备维修表的制单人名称', N'制单人名称', N'zh-CN',N'制单人名称';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_REPAIR.CREATEDTIME', N'设备维修表的制单时间', N'制单时间', N'zh-CN',N'制单时间';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_REPAIR.CREATEDBYORGID', N'设备维修表的制单人单位编码', N'制单人单位编码', N'zh-CN',N'制单人单位编码';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_REPAIR.CREATEDBYORGNAME', N'设备维修表的制单人单位名称', N'制单人单位名称', N'zh-CN',N'制单人单位名称';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_REPAIR.PROCESSSTATUS', N'设备维修表的流程状态', N'流程状态', N'zh-CN',N'流程状态';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_REPAIR.EQUIPTID', N'设备维修表的设备ID', N'设备ID', N'zh-CN',N'设备ID';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_REPAIR.APPLICANTID', N'设备维修表的申请人ID', N'申请人ID', N'zh-CN',N'申请人ID';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_REPAIR.APPLICANT', N'设备维修表的申请人', N'申请人', N'zh-CN',N'申请人';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_REPAIR.APPLYDATE', N'设备维修表的申请时间', N'申请时间', N'zh-CN',N'申请时间';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_REPAIR.APPLYDEPTID', N'设备维修表的申请部门ID', N'申请部门ID', N'zh-CN',N'申请部门ID';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_REPAIR.APPLYDEPT', N'设备维修表的申请部门', N'申请部门', N'zh-CN',N'申请部门';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_REPAIR.FAULTDATE', N'设备维修表的故障发生时间', N'故障发生时间', N'zh-CN',N'故障发生时间';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_REPAIR.FAULTDESC', N'设备维修表的故障描述', N'故障描述', N'zh-CN',N'故障描述';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_REPAIR.EXPECTDATE', N'设备维修表的期望修复日期', N'期望修复日期', N'zh-CN',N'期望修复日期';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_REPAIR.FAULTREASON', N'设备维修表的故障原因分析', N'故障原因分析', N'zh-CN',N'故障原因分析';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_REPAIR.REPAIRMEASURE', N'设备维修表的故障维修措施', N'故障维修措施', N'zh-CN',N'故障维修措施';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_REPAIR.FINISHDATE', N'设备维修表的完成时间', N'完成时间', N'zh-CN',N'完成时间';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_REPAIR.STOPHOURS', N'设备维修表的停机时长', N'停机时长', N'zh-CN',N'停机时长';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_REPAIR.REPAIRPERSONID', N'设备维修表的维修人员ID', N'维修人员ID', N'zh-CN',N'维修人员ID';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_REPAIR.REPAIRPERSON', N'设备维修表的维修人员', N'维修人员', N'zh-CN',N'维修人员';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_REPAIR.REPAIRCOST', N'设备维修表的维修费用', N'维修费用', N'zh-CN',N'维修费用';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_REPAIR.REMARKS', N'设备维修表的备注', N'备注', N'zh-CN',N'备注';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.TRM.EQUIPT.REPAIRS.MODAL.ADD', N'新增', N'新增', N'zh-CN',N'新增';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.TRM.EQUIPT.REPAIRS.TAB.BASE_INFO', N'基本信息', N'基本信息', N'zh-CN',N'基本信息';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.TRM.EQUIPT.REPAIRS.BUTTON.BUTTON', N'按钮', N'按钮', N'zh-CN',N'按钮';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.TRM.EQUIPT.REPAIRS.TIP.TIP', N'提示框', N'提示框', N'zh-CN',N'提示框';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.TRM.EQUIPT.REPAIRS.MODAL.MODAL', N'对话框', N'对话框', N'zh-CN',N'对话框';
|
|
|
|
|
|
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');
|
|
|
|
|
|
-- ----------------------------- 2022-09-01 add by lijiaxing------------e;
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.TRM.EQUIPT.EQUIPT.EQUIPTCHANNELPANEL', '设备通道', '设备通道', 'zh-CN', '设备通道';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.TRM.EQUIPT.EQUIPT.AUXILIARYPANEL', '辅助设备', '辅助设备', 'zh-CN', '辅助设备';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.TRM.EQUIPT.EQUIPT.EVENTPANEL', '设备事件', '设备事件', 'zh-CN', '设备事件';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.TRM.EQUIPT.EQUIPT.EVENTRECORDPANEL', '设备事件记录', '设备事件记录', 'zh-CN', '设备事件记录';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.TRM.EQUIPT.EQUIPT.REPAIRPANEL', '设备维修', '设备维修', 'zh-CN', '设备维修';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.TRM.EQUIPT.EQUIPT.MAINTAINPANEL', '设备保养/点检', '设备保养/点检', 'zh-CN', '设备保养/点检';
|
|
EXEC DBO.INSERTI18N N'BASEMODULE.TRM.EQUIPT.EQUIPT.MAINTAINITEMPANEL', '设备保养/点检项目', '设备保养/点检项目', 'zh-CN', '设备保养/点检项目';
|
|
EXEC DBO.INSERTI18N N'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', '设备保养点检记录');
|
|
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_AUXILIARY.EXT.EQUIPTNAME', '设备名称', '设备名称', 'zh-CN', '设备名称';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_AUXILIARY.EXT.EQUIPTCODE', '设备编号', '设备名称', 'zh-CN', '设备名称';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_REPAIR.EXT.EQUIPTNAME', '设备名称', '设备名称', 'zh-CN', '设备名称';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_REPAIR.EXT.EQUIPTCODE', '设备编号', '设备名称', 'zh-CN', '设备名称';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_MAINTAIN_PLAN.EXT.EQUIPTNAME', '设备名称', '设备名称', 'zh-CN', '设备名称';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_MAINTAIN_PLAN.EXT.EQUIPTCODE', '设备编号', '设备名称', 'zh-CN', '设备名称';
|
|
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_REPAIR.PANEL.EDIT', '申请', '申请', 'zh-CN', '申请';
|
|
EXEC DBO.INSERTI18N N'T_LIMS_EQUIPT_REPAIR.PANEL.EQUIPT', '设备', '设备', 'zh-CN', '设备';
|
|
EXEC DBO.INSERTI18N N'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%');
|
|
|
|
|
|
|
|
|
|
|