53 lines
2.2 KiB
SQL
53 lines
2.2 KiB
SQL
/*
|
||
Navicat Premium Data Transfer
|
||
|
||
Source Server : localxiuos
|
||
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: 12/12/2023 10:33:59
|
||
*/
|
||
|
||
|
||
-- ----------------------------
|
||
-- Table structure for lora_gateway_info
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS "public"."lora_gateway_info";
|
||
CREATE TABLE "public"."lora_gateway_info" (
|
||
"name" varchar(32) COLLATE "pg_catalog"."default",
|
||
"gatewayid" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
|
||
"device_num" int4,
|
||
"last_connect" timestamp(6),
|
||
"status" int4,
|
||
"org" varchar(32) COLLATE "pg_catalog"."default",
|
||
"remark1" varchar(32) COLLATE "pg_catalog"."default",
|
||
"remark2" varchar(32) COLLATE "pg_catalog"."default",
|
||
"remark3" varchar(32) COLLATE "pg_catalog"."default",
|
||
"remark4" varchar(32) COLLATE "pg_catalog"."default",
|
||
"remark5" varchar(32) COLLATE "pg_catalog"."default"
|
||
)
|
||
;
|
||
COMMENT ON COLUMN "public"."lora_gateway_info"."name" IS '网关名称';
|
||
COMMENT ON COLUMN "public"."lora_gateway_info"."gatewayid" IS '网关id';
|
||
COMMENT ON COLUMN "public"."lora_gateway_info"."device_num" IS '所属设备数量';
|
||
COMMENT ON COLUMN "public"."lora_gateway_info"."last_connect" IS '上次连接时间';
|
||
COMMENT ON COLUMN "public"."lora_gateway_info"."status" IS '1-在线，2-离线，0-从未连接';
|
||
COMMENT ON COLUMN "public"."lora_gateway_info"."org" IS '所属企业';
|
||
COMMENT ON COLUMN "public"."lora_gateway_info"."remark1" IS '预留字段1';
|
||
COMMENT ON COLUMN "public"."lora_gateway_info"."remark2" IS '预留字段2';
|
||
COMMENT ON COLUMN "public"."lora_gateway_info"."remark3" IS '预留字段3';
|
||
COMMENT ON COLUMN "public"."lora_gateway_info"."remark4" IS '预留字段4';
|
||
COMMENT ON COLUMN "public"."lora_gateway_info"."remark5" IS '预留字段5';
|
||
|
||
-- ----------------------------
|
||
-- Primary Key structure for table lora_gateway_info
|
||
-- ----------------------------
|
||
ALTER TABLE "public"."lora_gateway_info" ADD CONSTRAINT "lora_gateway_info_pkey" PRIMARY KEY ("gatewayid");
|