127 lines
7.4 KiB
Plaintext
127 lines
7.4 KiB
Plaintext
-- ----------------------------- 2022-09-28 add by wangyuwei@sunwaywolrd.com--------------begin
|
|
|
|
CREATE TABLE T_LIMS_ENVIRONMENT_ROOM
|
|
(
|
|
ID NUMBER NOT NULL,
|
|
CREATEDBYID VARCHAR2(36) NULL,
|
|
CREATEDBYNAME VARCHAR2(36) NULL,
|
|
CREATEDTIME DATE NULL,
|
|
CREATEDBYORGID VARCHAR2(36) NULL,
|
|
CREATEDBYORGNAME VARCHAR2(300) NULL,
|
|
LABORATORY VARCHAR2(120) NULL,
|
|
UPPERTEMLIMIT VARCHAR2(60) NULL,
|
|
LOWERTEMLIMIT VARCHAR2(60) NULL,
|
|
UPPERHUMLIMIT VARCHAR2(60) NULL,
|
|
LOWERHUMLIMIT VARCHAR2(60) NULL,
|
|
FREQUENCY VARCHAR2(30) NULL,
|
|
IP VARCHAR2(30) NULL,
|
|
ROOMID NUMBER NULL
|
|
);
|
|
COMMENT ON TABLE T_LIMS_ENVIRONMENT_ROOM IS '环境房间信息';
|
|
COMMENT ON COLUMN T_LIMS_ENVIRONMENT_ROOM.ID IS '主键';
|
|
COMMENT ON COLUMN T_LIMS_ENVIRONMENT_ROOM.CREATEDBYID IS '创建人账号';
|
|
COMMENT ON COLUMN T_LIMS_ENVIRONMENT_ROOM.CREATEDBYNAME IS '创建人姓名';
|
|
COMMENT ON COLUMN T_LIMS_ENVIRONMENT_ROOM.CREATEDTIME IS '创建时间';
|
|
COMMENT ON COLUMN T_LIMS_ENVIRONMENT_ROOM.CREATEDBYORGID IS '创建人所属组织ID';
|
|
COMMENT ON COLUMN T_LIMS_ENVIRONMENT_ROOM.CREATEDBYORGNAME IS '创建人所属组织名称';
|
|
COMMENT ON COLUMN T_LIMS_ENVIRONMENT_ROOM.LABORATORY IS '实验室';
|
|
COMMENT ON COLUMN T_LIMS_ENVIRONMENT_ROOM.UPPERTEMLIMIT IS '温度上限';
|
|
COMMENT ON COLUMN T_LIMS_ENVIRONMENT_ROOM.LOWERTEMLIMIT IS '温度下限';
|
|
COMMENT ON COLUMN T_LIMS_ENVIRONMENT_ROOM.UPPERHUMLIMIT IS '湿度上限';
|
|
COMMENT ON COLUMN T_LIMS_ENVIRONMENT_ROOM.LOWERHUMLIMIT IS '湿度下限';
|
|
COMMENT ON COLUMN T_LIMS_ENVIRONMENT_ROOM.FREQUENCY IS '频率';
|
|
COMMENT ON COLUMN T_LIMS_ENVIRONMENT_ROOM.IP IS '物理IP';
|
|
|
|
CALL INSERTI18N('T_LIMS_ENVIRONMENT_ROOM.ID', '主键', '主键', 'zh-CN', '主键');
|
|
CALL INSERTI18N('T_LIMS_ENVIRONMENT_ROOM.CREATEDBYID', '制单人编码', '制单人编码', 'zh-CN', '制单人编码');
|
|
CALL INSERTI18N('T_LIMS_ENVIRONMENT_ROOM.CREATEDBYNAME', '创建人姓名', '创建人姓名', 'zh-CN', '创建人姓名');
|
|
CALL INSERTI18N('T_LIMS_ENVIRONMENT_ROOM.CREATEDTIME', '创建时间', '创建时间', 'zh-CN', '创建时间');
|
|
CALL INSERTI18N('T_LIMS_ENVIRONMENT_ROOM.CREATEDBYORGID', '组织ID', '组织ID', 'zh-CN', '组织ID');
|
|
CALL INSERTI18N('T_LIMS_ENVIRONMENT_ROOM.CREATEDBYORGNAME', '组织名称', '组织名称', 'zh-CN', '组织名称');
|
|
CALL INSERTI18N('T_LIMS_ENVIRONMENT_ROOM.LABORATORY', '实验室', '实验室', 'zh-CN', '实验室');
|
|
CALL INSERTI18N('T_LIMS_ENVIRONMENT_ROOM.UPPERTEMLIMIT', '温度上限', '温度上限', 'zh-CN', '温度上限');
|
|
CALL INSERTI18N('T_LIMS_ENVIRONMENT_ROOM.LOWERTEMLIMIT', '温度下限', '温度下限', 'zh-CN', '温度下限');
|
|
CALL INSERTI18N('T_LIMS_ENVIRONMENT_ROOM.UPPERHUMLIMIT', '湿度上限', '湿度上限', 'zh-CN', '湿度上限');
|
|
CALL INSERTI18N('T_LIMS_ENVIRONMENT_ROOM.LOWERHUMLIMIT', '湿度下限', '湿度下限', 'zh-CN', '湿度下限');
|
|
CALL INSERTI18N('T_LIMS_ENVIRONMENT_ROOM.FREQUENCY', '频率', '频率', 'zh-CN', '频率');
|
|
CALL INSERTI18N('T_LIMS_ENVIRONMENT_ROOM.IP', '物理IP', '物理IP', 'zh-CN', '物理IP');
|
|
|
|
|
|
CREATE TABLE T_LIMS_ENVIRONMENT_VALUE
|
|
(
|
|
ID NUMBER NOT NULL,
|
|
CREATEDBYID VARCHAR2(36) NULL,
|
|
CREATEDBYNAME VARCHAR2(36) NULL,
|
|
CREATEDTIME DATE NULL,
|
|
CREATEDBYORGID VARCHAR2(36) NULL,
|
|
CREATEDBYORGNAME VARCHAR2(300) NULL,
|
|
ROOMID NUMBER NULL,
|
|
TEMPERATURE VARCHAR2(36) NULL,
|
|
HUMIDITY VARCHAR2(36) NULL,
|
|
COLLETEDATE DATE NULL
|
|
);
|
|
|
|
COMMENT ON TABLE T_LIMS_ENVIRONMENT_VALUE IS '环境温湿度信息';
|
|
COMMENT ON COLUMN T_LIMS_ENVIRONMENT_VALUE.ID IS '主键';
|
|
COMMENT ON COLUMN T_LIMS_ENVIRONMENT_VALUE.CREATEDBYID IS '创建人账号';
|
|
COMMENT ON COLUMN T_LIMS_ENVIRONMENT_VALUE.CREATEDBYNAME IS '创建人姓名';
|
|
COMMENT ON COLUMN T_LIMS_ENVIRONMENT_VALUE.CREATEDTIME IS '创建时间';
|
|
COMMENT ON COLUMN T_LIMS_ENVIRONMENT_VALUE.CREATEDBYORGID IS '创建人所属组织ID';
|
|
COMMENT ON COLUMN T_LIMS_ENVIRONMENT_VALUE.CREATEDBYORGNAME IS '创建人所属组织名称';
|
|
COMMENT ON COLUMN T_LIMS_ENVIRONMENT_VALUE.ROOMID IS '房间ID';
|
|
COMMENT ON COLUMN T_LIMS_ENVIRONMENT_VALUE.TEMPERATURE IS '温度';
|
|
COMMENT ON COLUMN T_LIMS_ENVIRONMENT_VALUE.HUMIDITY IS '湿度';
|
|
COMMENT ON COLUMN T_LIMS_ENVIRONMENT_VALUE.COLLETEDATE IS '采集时间';
|
|
|
|
CALL INSERTI18N('T_LIMS_ENVIRONMENT_VALUE.ID', '主键', '主键', 'zh-CN', '主键');
|
|
CALL INSERTI18N('T_LIMS_ENVIRONMENT_VALUE.CREATEDBYID', '制单人编码', '制单人编码', 'zh-CN', '制单人编码');
|
|
CALL INSERTI18N('T_LIMS_ENVIRONMENT_VALUE.CREATEDBYNAME', '创建人姓名', '创建人姓名', 'zh-CN', '创建人姓名');
|
|
CALL INSERTI18N('T_LIMS_ENVIRONMENT_VALUE.CREATEDTIME', '创建时间', '创建时间', 'zh-CN', '创建时间');
|
|
CALL INSERTI18N('T_LIMS_ENVIRONMENT_VALUE.CREATEDBYORGID', '组织ID', '组织ID', 'zh-CN', '组织ID');
|
|
CALL INSERTI18N('T_LIMS_ENVIRONMENT_VALUE.CREATEDBYORGNAME', '组织名称', '组织名称', 'zh-CN', '组织名称');
|
|
CALL INSERTI18N('T_LIMS_ENVIRONMENT_VALUE.ROOMID', '房间ID', '房间ID', 'zh-CN', '房间ID');
|
|
CALL INSERTI18N('T_LIMS_ENVIRONMENT_VALUE.TEMPERATURE', '温度', '温度', 'zh-CN', '温度');
|
|
CALL INSERTI18N('T_LIMS_ENVIRONMENT_VALUE.HUMIDITY', '湿度', '湿度', 'zh-CN', '湿度');
|
|
CALL INSERTI18N('T_LIMS_ENVIRONMENT_VALUE.COLLETEDATE', '采集时间', '采集时间', 'zh-CN', '采集时间');
|
|
|
|
|
|
|
|
CREATE TABLE T_LIMS_TEMPR_HUMIDITY
|
|
(
|
|
ID NUMBER NOT NULL,
|
|
IP VARCHAR2(60) NULL,
|
|
ROOMID NUMBER NULL,
|
|
TEMPR VARCHAR2(30) NULL,
|
|
HUMIDITY VARCHAR2(30) NULL,
|
|
CREATEDTIME DATE
|
|
);
|
|
|
|
COMMENT ON TABLE T_LIMS_TEMPR_HUMIDITY IS '温湿度';
|
|
COMMENT ON COLUMN T_LIMS_TEMPR_HUMIDITY.ID IS '主键';
|
|
COMMENT ON COLUMN T_LIMS_TEMPR_HUMIDITY.IP IS '所属IP的ID';
|
|
COMMENT ON COLUMN T_LIMS_TEMPR_HUMIDITY.ROOMID IS '房间ID';
|
|
COMMENT ON COLUMN T_LIMS_TEMPR_HUMIDITY.TEMPR IS '温度';
|
|
COMMENT ON COLUMN T_LIMS_TEMPR_HUMIDITY.HUMIDITY IS '湿度';
|
|
COMMENT ON COLUMN T_LIMS_TEMPR_HUMIDITY.CREATEDTIME IS '制单时间';
|
|
|
|
|
|
CALL INSERTI18N('T_LIMS_TEMPR_HUMIDITY.ID', '主键', '主键', 'zh-CN', '主键');
|
|
CALL INSERTI18N('T_LIMS_TEMPR_HUMIDITY.IP', '所属IP的ID', '所属IP的ID', 'zh-CN', '所属IP的ID');
|
|
CALL INSERTI18N('T_LIMS_ENVIRONMENT_VALUE.ROOMID', '房间ID', '房间ID', 'zh-CN', '房间ID');
|
|
CALL INSERTI18N('T_LIMS_TEMPR_HUMIDITY.ROOMID', '房间ID', '房间ID', 'zh-CN', '房间ID');
|
|
CALL INSERTI18N('T_LIMS_TEMPR_HUMIDITY.TEMPR', '温度', '温度', 'zh-CN', '温度');
|
|
CALL INSERTI18N('T_LIMS_TEMPR_HUMIDITY.CREATEDTIME', '制单时间', '制单时间', 'zh-CN', '制单时间');
|
|
|
|
CALL INSERTI18N('T_LIMS_TEMPR_HUMIDITY.SERVICE_NAME', '温湿度表', '温湿度表', 'zh-CN', '温湿度表');
|
|
CALL INSERTI18N('T_LIMS_ENVIRONMENT_ROOM.SERVICE_NAME', '环境房间信息表', '环境房间信息表', 'zh-CN', '环境房间信息表');
|
|
CALL INSERTI18N('T_LIMS_ENVIRONMENT_VALUE.SERVICE_NAME', '环境温湿度信息表', '环境温湿度信息表', 'zh-CN', '环境温湿度信息表');
|
|
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('20220928', '环境管理', null, '91', '8', '035.svg', '环境管理');
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('2022092801', '仪器采集配置', '/secure/basemodule/trm/environment-rooms/page/edit-list', '20220928', '1', '035.svg', '仪器采集配置');
|
|
|
|
INSERT INTO T_CORE_MENU (ID, MENUNAME, HREF, PARENTID, ORDERNO, ICON, MENUINITNAME)
|
|
VALUES ('2022092803', '位置管理', '/secure/basemodule/trm/locations/page/edit-list', '20220928', '3', '035.svg', '位置管理');
|
|
|
|
-- ----------------------------- 2022-09-28 add by wangyuwei@sunwaywolrd.com--------------end |