55 lines
7.7 KiB
SQL
55 lines
7.7 KiB
SQL
/*
|
|
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: 23/09/2022 17:26:29
|
|
*/
|
|
|
|
|
|
-- ----------------------------
|
|
-- Table structure for protocol_product_info
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS "public"."protocol_product_info";
|
|
CREATE TABLE "public"."protocol_product_info" (
|
|
"product_name" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
|
|
"protocol_type" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
|
|
"read_item_list" varchar(5000) COLLATE "pg_catalog"."default",
|
|
"updatetime" timestamp(6),
|
|
"device_id" varchar(32) COLLATE "pg_catalog"."default",
|
|
"device_name" varchar(32) COLLATE "pg_catalog"."default",
|
|
"socket_config" varchar(255) COLLATE "pg_catalog"."default",
|
|
"read_period" varchar(32) COLLATE "pg_catalog"."default"
|
|
)
|
|
;
|
|
COMMENT ON COLUMN "public"."protocol_product_info"."product_name" IS '产品名称';
|
|
COMMENT ON COLUMN "public"."protocol_product_info"."protocol_type" IS '协议类型';
|
|
COMMENT ON COLUMN "public"."protocol_product_info"."read_item_list" IS '配方列表';
|
|
COMMENT ON COLUMN "public"."protocol_product_info"."updatetime" IS '更新时间';
|
|
COMMENT ON COLUMN "public"."protocol_product_info"."device_id" IS '设备id';
|
|
COMMENT ON COLUMN "public"."protocol_product_info"."device_name" IS '设备名称';
|
|
COMMENT ON COLUMN "public"."protocol_product_info"."socket_config" IS 'socket配置';
|
|
COMMENT ON COLUMN "public"."protocol_product_info"."read_period" IS '读取间隔';
|
|
|
|
-- ----------------------------
|
|
-- Records of protocol_product_info
|
|
-- ----------------------------
|
|
INSERT INTO "public"."protocol_product_info" VALUES ('PLC_FINS_1', 'FINS', '[{"value_name":"启动","value_type":1,"area_char":"W","data_type":0,"start_address":0,"bit_address":0,"data_length":1},{"value_name":"停止","value_type":1,"area_char":"W","data_type":0,"start_address":0,"bit_address":1,"data_length":1},{"value_name":"使能","value_type":1,"area_char":"H","data_type":0,"start_address":0,"bit_address":2,"data_length":1},{"value_name":"回零","value_type":1,"area_char":"D","data_type":0,"start_address":0,"bit_address":3,"data_length":1},{"value_name":"急停","value_type":1,"area_char":"W","data_type":0,"start_address":0,"bit_address":4,"data_length":1},{"value_name":"正限位","value_type":1,"area_char":"W","data_type":0,"start_address":10,"bit_address":11,"data_length":1},{"value_name":"负限位","value_type":1,"area_char":"W","data_type":0,"start_address":10,"bit_address":12,"data_length":1},{"value_name":"自动运行中","value_type":1,"area_char":"W","data_type":0,"start_address":200,"bit_address":5,"data_length":1},{"value_name":"故障","value_type":1,"area_char":"W","data_type":0,"start_address":200,"bit_address":6,"data_length":1},{"value_name":"待机","value_type":1,"area_char":"W","data_type":0,"start_address":200,"bit_address":7,"data_length":1},{"value_name":"手动模式","value_type":1,"area_char":"W","data_type":0,"start_address":300,"bit_address":0,"data_length":1},{"value_name":"自动模式","value_type":1,"area_char":"W","data_type":0,"start_address":300,"bit_address":1,"data_length":1},{"value_name":"运行方向","value_type":1,"area_char":"W","data_type":0,"start_address":300,"bit_address":2,"data_length":1},{"value_name":"复位","value_type":1,"area_char":"W","data_type":0,"start_address":400,"bit_address":3,"data_length":1},{"value_name":"备用1","value_type":1,"area_char":"W","data_type":0,"start_address":400,"bit_address":4,"data_length":1},{"value_name":"产量","value_type":3,"area_char":"D","data_type":1,"start_address":10,"bit_address":0,"data_length":1},{"value_name":"整型1","value_type":3,"area_char":"D","data_type":1,"start_address":11,"bit_address":0,"data_length":1},{"value_name":"整型2","value_type":3,"area_char":"D","data_type":1,"start_address":20,"bit_address":0,"data_length":1},{"value_name":"整型3","value_type":3,"area_char":"D","data_type":1,"start_address":100,"bit_address":0,"data_length":1},{"value_name":"整型4","value_type":3,"area_char":"W","data_type":1,"start_address":100,"bit_address":0,"data_length":1},{"value_name":"整型5","value_type":3,"area_char":"W","data_type":1,"start_address":101,"bit_address":0,"data_length":1},{"value_name":"整型6","value_type":3,"area_char":"W","data_type":1,"start_address":110,"bit_address":0,"data_length":1},{"value_name":"整型7","value_type":3,"area_char":"H","data_type":1,"start_address":10,"bit_address":0,"data_length":1},{"value_name":"整型8","value_type":3,"area_char":"H","data_type":1,"start_address":20,"bit_address":0,"data_length":1},{"value_name":"整型9","value_type":3,"area_char":"H","data_type":1,"start_address":21,"bit_address":0,"data_length":1},{"value_name":"速度","value_type":9,"area_char":"D","data_type":1,"start_address":2000,"bit_address":0,"data_length":2},{"value_name":"加速度","value_type":9,"area_char":"D","data_type":1,"start_address":2002,"bit_address":0,"data_length":2},{"value_name":"减速度","value_type":9,"area_char":"D","data_type":1,"start_address":2004,"bit_address":0,"data_length":2},{"value_name":"起始位置","value_type":9,"area_char":"D","data_type":1,"start_address":300,"bit_address":0,"data_length":2},{"value_name":"终点位置","value_type":9,"area_char":"D","data_type":1,"start_address":302,"bit_address":0,"data_length":2},{"value_name":"张力值","value_type":9,"area_char":"W","data_type":1,"start_address":80,"bit_address":0,"data_length":2},{"value_name":"浮点型1","value_type":8,"area_char":"H","data_type":1,"start_address":100,"bit_address":0,"data_length":4},{"value_name":"浮点型2","value_type":8,"area_char":"H","data_type":1,"start_address":104,"bit_address":0,"data_length":4},{"value_name":"浮点型3","value_type":8,"area_char":"H","data_type":1,"start_address":108,"bit_address":0,"data_length":4},{"value_name":"浮点型4","value_type":8,"area_char":"H","data_type":1,"start_address":112,"bit_address":0,"data_length":4}]', '2022-09-21 14:43:23', '769', 'S01', '{"plc_ip":"192.168.250.22","local_ip":"192.168.250.233","port":9600}', '100');
|
|
INSERT INTO "public"."protocol_product_info" VALUES ('PLC_S7_1', 'S7', '[{"value_name":"手动模式","value_type":"BOOL","data_type":"Bit","function_code":"","area_char":"M","start_address":"1","bit_address":"","db_number":"0","data_length":"1","command_type":"","monitoring_timer":""}]', '2022-09-22 14:29:20', '800', 'S04', '{"plc_ip":"192.168.250.22","local_ip":"192.168.250.233","stop_bits":"","baud_rate":"","data_bits":"","port":"9797","check_mode":""}', '120');
|
|
INSERT INTO "public"."protocol_product_info" VALUES ('PLC_Modbus_1', 'Modbus', '[{"value_name":"整型1","value_type":"BOOL","function_code":"01","start_address":"0","data_length":"1"}]', '2022-09-22 14:30:22', '900', 'S04', '{"plc_ip":"192.168.250.22","local_ip":"192.168.250.233","stop_bits":"","baud_rate":"","data_bits":"","port":"9898","check_mode":""}', '200');
|
|
INSERT INTO "public"."protocol_product_info" VALUES ('PLC_MC_1', 'MC', '[{"value_name":"启动","value_type":"BOOL","data_type":"","function_code":"","area_char":"M","start_address":"1","bit_address":"","db_number":"","data_length":"1","command_type":"位读","monitoring_timer":"1"}]', '2022-09-22 15:11:49', '700', 'S03', '{"plc_ip":"192.168.250.22","local_ip":"192.168.250.233","stop_bits":2,"baud_rate":2400,"data_bits":6,"port":"9600","check_mode":"NONE"}', '120');
|
|
|
|
-- ----------------------------
|
|
-- Primary Key structure for table protocol_product_info
|
|
-- ----------------------------
|
|
ALTER TABLE "public"."protocol_product_info" ADD CONSTRAINT "protocol_product_info_pkey" PRIMARY KEY ("product_name");
|