floraachy
/
xiuos_IoT
1
0
Fork 1
Code Issues Pull Requests 2 Actions Packages Projects Releases Wiki Activity
xiuos_IoT/xiuosiot-backend/dbsql/device_info.sql

111 lines
12 KiB
SQL
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

/*
Navicat Premium Data Transfer
Source Server : localdsd
Source Server Type : PostgreSQL
Source Server Version : 120012
Source Host : localhost:5432
Source Catalog : xiuosiot
Source Schema : public
Target Server Type : PostgreSQL
Target Server Version : 120012
File Encoding : 65001
Date: 09/10/2022 20:43:52
*/
-- ----------------------------
-- Table structure for device_info
-- ----------------------------
DROP TABLE IF EXISTS "public"."device_info";
CREATE TABLE "public"."device_info" (
"id" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
"productname" varchar(32) COLLATE "pg_catalog"."default",
"type" varchar(32) COLLATE "pg_catalog"."default",
"no" varchar(16) COLLATE "pg_catalog"."default" NOT NULL,
"activestatus" int4,
"updatetime" varchar(32) COLLATE "pg_catalog"."default",
"devicedesc" varchar(255) COLLATE "pg_catalog"."default",
"runstatus" int4,
"statusdesc" varchar(255) COLLATE "pg_catalog"."default",
"kernel" varchar(32) COLLATE "pg_catalog"."default",
"webversion" varchar(32) COLLATE "pg_catalog"."default",
"ipaddr" varchar(32) COLLATE "pg_catalog"."default",
"netmask" varchar(32) COLLATE "pg_catalog"."default",
"gateway" varchar(32) COLLATE "pg_catalog"."default",
"dnsserver0" varchar(32) COLLATE "pg_catalog"."default",
"dnsserver1" varchar(32) COLLATE "pg_catalog"."default",
"topic" varchar(32) COLLATE "pg_catalog"."default",
"serveraddr" varchar(64) COLLATE "pg_catalog"."default",
"serverport" varchar(32) COLLATE "pg_catalog"."default",
"username" varchar(32) COLLATE "pg_catalog"."default",
"clientid" varchar(64) COLLATE "pg_catalog"."default",
"privateserveraddr" varchar(32) COLLATE "pg_catalog"."default",
"privateserverport" varchar(32) COLLATE "pg_catalog"."default",
"privateserverusername" varchar(32) COLLATE "pg_catalog"."default",
"org" varchar(32) COLLATE "pg_catalog"."default"
)
;
COMMENT ON COLUMN "public"."device_info"."id" IS '主键id';
COMMENT ON COLUMN "public"."device_info"."productname" IS '产品名称
彩印车间0
生产车间1
成型车间2
打包车间3';
COMMENT ON COLUMN "public"."device_info"."type" IS '设备类型
RV400-NPU16T-5G-AR100 0
RV400-NPU4T-5G-SR100 1
M528-A800-5G-HM100 2
RV400-4G-FR100 3
M168-LoRa-FM100 4';
COMMENT ON COLUMN "public"."device_info"."no" IS '设备编号';
COMMENT ON COLUMN "public"."device_info"."activestatus" IS '设备状态 1-已激活 0-未激活';
COMMENT ON COLUMN "public"."device_info"."updatetime" IS '更新数据时间';
COMMENT ON COLUMN "public"."device_info"."devicedesc" IS '设备描述';
COMMENT ON COLUMN "public"."device_info"."runstatus" IS '运行状态：0-待机，1-运行，2-警告';
COMMENT ON COLUMN "public"."device_info"."statusdesc" IS '运行状态描述';
COMMENT ON COLUMN "public"."device_info"."kernel" IS '内核类型';
COMMENT ON COLUMN "public"."device_info"."webversion" IS '内核版本';
COMMENT ON COLUMN "public"."device_info"."ipaddr" IS 'ipv4地址';
COMMENT ON COLUMN "public"."device_info"."netmask" IS 'ipv4子网掩码';
COMMENT ON COLUMN "public"."device_info"."gateway" IS 'ipv4默认网关';
COMMENT ON COLUMN "public"."device_info"."dnsserver0" IS '首选dns服务器';
COMMENT ON COLUMN "public"."device_info"."dnsserver1" IS '备用dns服务器';
COMMENT ON COLUMN "public"."device_info"."topic" IS 'mqtt发布主题';
COMMENT ON COLUMN "public"."device_info"."serveraddr" IS 'mqtt服务器地址';
COMMENT ON COLUMN "public"."device_info"."serverport" IS 'matt端口';
COMMENT ON COLUMN "public"."device_info"."username" IS 'mqtt用户名';
COMMENT ON COLUMN "public"."device_info"."clientid" IS 'mqtt客户端id';
COMMENT ON COLUMN "public"."device_info"."privateserveraddr" IS '私有协议服务器地址';
COMMENT ON COLUMN "public"."device_info"."privateserverport" IS '私有协议端口号';
COMMENT ON COLUMN "public"."device_info"."privateserverusername" IS '私有协议用户名';
COMMENT ON COLUMN "public"."device_info"."org" IS '所属公司';
-- ----------------------------
-- Records of device_info
-- ----------------------------
INSERT INTO "public"."device_info" VALUES ('20220901112007aiitxiosdsd', '打包车间', 'RV400-NPU16T-5G-AR100', 'A000005', 1, '2022-09-01 11:20:07', '电表监测', 1, '运行', 'rt-thread kenel', '1.0', '192.168.131.29', '255.255.254.0', '192.168.130.1', '10.0.110.21', '10.0.110.20', '/broadcast/hf6mzwdVnJg/989898', 'zwdVnJg.iot-as-mqtt.cn-shanghai.aliyuncs.com', '1883', 'test1&hf6mzwdVnJg', '123|securemode=3,signmethod=hmacsha1|', '192.168.131.30', '9898', 'admin', 'dsd');
INSERT INTO "public"."device_info" VALUES ('20220901112047aiitxiosdsd', '彩印车间', 'M168-LoRa-FM100', 'A000007', 0, '2022-09-01 11:20:47', '电表监测', 1, '运行', 'rt-thread kenel', '1.0', '192.168.131.29', '255.255.254.0', '192.168.130.1', '10.0.110.21', '10.0.110.20', '/broadcast/hf6mzwdVnJg/989898', 'zwdVnJg.iot-as-mqtt.cn-shanghai.aliyuncs.com', '1883', 'test1&hf6mzwdVnJg', '123|securemode=3,signmethod=hmacsha1|', '192.168.131.30', '9898', 'admin', 'dsd');
INSERT INTO "public"."device_info" VALUES ('20220901112103aiitxiosdsd', '成型车间', 'M528-A800-5G-HM100', 'A000008', 0, '2022-09-01 11:21:03', '电表监测', 1, '运行', 'rt-thread kenel', '1.0', '192.168.131.29', '255.255.254.0', '192.168.130.1', '10.0.110.21', '10.0.110.20', '/broadcast/hf6mzwdVnJg/989898', 'zwdVnJg.iot-as-mqtt.cn-shanghai.aliyuncs.com', '1883', 'test1&hf6mzwdVnJg', '123|securemode=3,signmethod=hmacsha1|', '192.168.131.30', '9898', 'admin', 'dsd');
INSERT INTO "public"."device_info" VALUES ('20220901195013aiitxiosdsd', '成型车间', 'RV400-NPU16T-5G-AR100', 'A000009', 1, '2022-09-01 19:50:13', '电表监测', 1, '运行', 'rt-thread kenel', '1.0', '192.168.131.29', '255.255.254.0', '192.168.130.1', '10.0.110.21', '10.0.110.20', '/broadcast/hf6mzwdVnJg/989898', 'zwdVnJg.iot-as-mqtt.cn-shanghai.aliyuncs.com', '1883', 'test1&hf6mzwdVnJg', '123|securemode=3,signmethod=hmacsha1|', '192.168.131.30', '9898', 'admin', 'dsd');
INSERT INTO "public"."device_info" VALUES ('20220901195050aiitxiosdsd', '彩印车间', 'RV400-4G-FR100', 'A000010', 1, '2022-09-01 19:50:50', '电表监测', 0, '待机', 'rt-thread kenel', '1.0', '192.168.131.29', '255.255.254.0', '192.168.130.1', '10.0.110.21', '10.0.110.20', '/broadcast/hf6mzwdVnJg/989898', 'zwdVnJg.iot-as-mqtt.cn-shanghai.aliyuncs.com', '1883', 'test1&hf6mzwdVnJg', '123|securemode=3,signmethod=hmacsha1|', '192.168.131.30', '9898', 'admin', 'dsd');
INSERT INTO "public"."device_info" VALUES ('20220901112032aiitxiosdsd', '生产车间', 'RV400-NPU4T-5G-SR100', 'A000006', 1, '2022-09-01 20:12:43', '电表监测', 1, '运行', 'rt-thread kenel', '1.0', '192.168.131.29', '255.255.254.0', '192.168.130.1', '10.0.110.21', '10.0.110.20', '/broadcast/hf6mzwdVnJg/989898', 'zwdVnJg.iot-as-mqtt.cn-shanghai.aliyuncs.com', '1883', 'test1&hf6mzwdVnJg', '123|securemode=3,signmethod=hmacsha1|', '192.168.131.30', '9898', 'admin', 'dsd');
INSERT INTO "public"."device_info" VALUES ('20220901201304aiitxiosdsd', '彩印车间', 'RV400-NPU16T-5G-AR100', 'A000011', 1, '2022-09-01 20:13:04', '电表监测', 0, '待机', 'rt-thread kenel', '1.0', '192.168.131.29', '255.255.254.0', '192.168.130.1', '10.0.110.21', '10.0.110.20', '/broadcast/hf6mzwdVnJg/989898', 'zwdVnJg.iot-as-mqtt.cn-shanghai.aliyuncs.com', '1883', 'test1&hf6mzwdVnJg', '123|securemode=3,signmethod=hmacsha1|', '192.168.131.30', '9898', 'admin', 'dsd');
INSERT INTO "public"."device_info" VALUES ('20220901111814aiitxiosdsd', '彩印车间', 'M168-LoRa-FM100', 'A000001', 1, '2022-09-01 11:18:14', '电表监测', 1, '运行', 'rt-thread kenel', '1.0', '192.168.131.29', '255.255.254.0', '192.168.130.1', '10.0.110.21', '10.0.110.20', '/broadcast/hf6mzwdVnJg/989898', 'zwdVnJg.iot-as-mqtt.cn-shanghai.aliyuncs.com', '1883', 'test1&hf6mzwdVnJg', '123|securemode=3,signmethod=hmacsha1|', '192.168.131.30', '9898', 'admin', 'dsd');
INSERT INTO "public"."device_info" VALUES ('20221009180320-hangxiao-hx', '数字工厂', 'M528-A800-5G-HM100', 'A000012', 1, '2022-10-09 18:03:20', '激光切割机', 0, '待机', 'rt-thread kenel', '1.0', '192.168.131.29', '255.255.254.0', '192.168.130.1', '10.0.110.21', '10.0.110.20', '/broadcast/hf6mzwdVnJg/989898', 'zwdVnJg.iot-as-mqtt.cn-shanghai.aliyuncs.com', '1883', 'test1&hf6mzwdVnJg', '123|securemode=3,signmethod=hmacsha1|', '192.168.131.30', '9898', 'admin', 'hxgg');
INSERT INTO "public"."device_info" VALUES ('20221009163548-hangxiao-hx', '数字工厂', 'RV400-NPU4T-5G-SR100', 'A000013', 1, '2022-10-09 18:08:23', '火焰切割机', 2, '警告', 'rt-thread kenel', '1.0', '192.168.131.29', '255.255.254.0', '192.168.130.1', '10.0.110.21', '10.0.110.20', '/broadcast/hf6mzwdVnJg/989898', 'zwdVnJg.iot-as-mqtt.cn-shanghai.aliyuncs.com', '1883', 'test1&hf6mzwdVnJg', '123|securemode=3,signmethod=hmacsha1|', '192.168.131.30', '9898', 'admin', 'hxgg');
INSERT INTO "public"."device_info" VALUES ('20221009180814-hangxiao-hx', '数字工厂', 'RV400-NPU16T-5G-AR100', 'A000015', 1, '2022-10-09 18:08:14', '上料工位2', 2, '警告', 'rt-thread kenel', '1.0', '192.168.131.29', '255.255.254.0', '192.168.130.1', '10.0.110.21', '10.0.110.20', '/broadcast/hf6mzwdVnJg/989898', 'zwdVnJg.iot-as-mqtt.cn-shanghai.aliyuncs.com', '1883', 'test1&hf6mzwdVnJg', '123|securemode=3,signmethod=hmacsha1|', '192.168.131.30', '9898', 'admin', 'hxgg');
INSERT INTO "public"."device_info" VALUES ('20221009180843-hangxiao-hx', '数字工厂', 'RV400-NPU4T-5G-SR100', 'A000016', 1, '2022-10-09 18:08:43', '火焰切割机2', 0, '待机', 'rt-thread kenel', '1.0', '192.168.131.29', '255.255.254.0', '192.168.130.1', '10.0.110.21', '10.0.110.20', '/broadcast/hf6mzwdVnJg/989898', 'zwdVnJg.iot-as-mqtt.cn-shanghai.aliyuncs.com', '1883', 'test1&hf6mzwdVnJg', '123|securemode=3,signmethod=hmacsha1|', '192.168.131.30', '9898', 'admin', 'hxgg');
INSERT INTO "public"."device_info" VALUES ('20221009180859-hangxiao-hx', '数字工厂', 'RV400-NPU4T-5G-SR100', 'A000017', 1, '2022-10-09 18:08:59', '火焰切割机3', 1, '运行', 'rt-thread kenel', '1.0', '192.168.131.29', '255.255.254.0', '192.168.130.1', '10.0.110.21', '10.0.110.20', '/broadcast/hf6mzwdVnJg/989898', 'zwdVnJg.iot-as-mqtt.cn-shanghai.aliyuncs.com', '1883', 'test1&hf6mzwdVnJg', '123|securemode=3,signmethod=hmacsha1|', '192.168.131.30', '9898', 'admin', 'hxgg');
INSERT INTO "public"."device_info" VALUES ('20221009180939-hangxiao-hx', '数字工厂', 'RV400-4G-FR100', 'A000018', 1, '2022-10-09 18:09:39', '卧式矫正机', 0, '待机', 'rt-thread kenel', '1.0', '192.168.131.29', '255.255.254.0', '192.168.130.1', '10.0.110.21', '10.0.110.20', '/broadcast/hf6mzwdVnJg/989898', 'zwdVnJg.iot-as-mqtt.cn-shanghai.aliyuncs.com', '1883', 'test1&hf6mzwdVnJg', '123|securemode=3,signmethod=hmacsha1|', '192.168.131.30', '9898', 'admin', 'hxgg');
INSERT INTO "public"."device_info" VALUES ('20221009181000-hangxiao-hx', '数字工厂', 'M168-LoRa-FM100', 'A000019', 1, '2022-10-09 18:10:00', '抛丸线', 0, '待机', 'rt-thread kenel', '1.0', '192.168.131.29', '255.255.254.0', '192.168.130.1', '10.0.110.21', '10.0.110.20', '/broadcast/hf6mzwdVnJg/989898', 'zwdVnJg.iot-as-mqtt.cn-shanghai.aliyuncs.com', '1883', 'test1&hf6mzwdVnJg', '123|securemode=3,signmethod=hmacsha1|', '192.168.131.30', '9898', 'admin', 'hxgg');
INSERT INTO "public"."device_info" VALUES ('20221009181032-hangxiao-hx', '数字工厂', 'M528-A800-5G-HM100', 'A000020', 0, '2022-10-09 18:10:32', '出料缓存工位', 2, '警告', 'rt-thread kenel', '1.0', '192.168.131.29', '255.255.254.0', '192.168.130.1', '10.0.110.21', '10.0.110.20', '/broadcast/hf6mzwdVnJg/989898', 'zwdVnJg.iot-as-mqtt.cn-shanghai.aliyuncs.com', '1883', 'test1&hf6mzwdVnJg', '123|securemode=3,signmethod=hmacsha1|', '192.168.131.30', '9898', 'admin', 'hxgg');
INSERT INTO "public"."device_info" VALUES ('20221009181047-hangxiao-hx', '数字工厂', 'RV400-NPU16T-5G-AR100', 'A000021', 0, '2022-10-09 18:10:47', '进料缓存工位', 2, '警告', 'rt-thread kenel', '1.0', '192.168.131.29', '255.255.254.0', '192.168.130.1', '10.0.110.21', '10.0.110.20', '/broadcast/hf6mzwdVnJg/989898', 'zwdVnJg.iot-as-mqtt.cn-shanghai.aliyuncs.com', '1883', 'test1&hf6mzwdVnJg', '123|securemode=3,signmethod=hmacsha1|', '192.168.131.30', '9898', 'admin', 'hxgg');
-- ----------------------------
-- Primary Key structure for table device_info
-- ----------------------------
ALTER TABLE "public"."device_info" ADD CONSTRAINT "device_info_pkey" PRIMARY KEY ("id", "no");
Reference in New Issue View Git Blame Copy Permalink