59 lines
2.5 KiB
SQL
59 lines
2.5 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:51
|
||
*/
|
||
|
||
|
||
-- ----------------------------
|
||
-- Table structure for lora_device_info
|
||
-- ----------------------------
|
||
DROP TABLE IF EXISTS "public"."lora_device_info";
|
||
CREATE TABLE "public"."lora_device_info" (
|
||
"dev_eui" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
|
||
"join_eui" varchar(32) COLLATE "pg_catalog"."default",
|
||
"name" varchar(32) COLLATE "pg_catalog"."default",
|
||
"app_key" varchar(32) COLLATE "pg_catalog"."default",
|
||
"support_otaa" bool,
|
||
"support_classc" bool,
|
||
"gatewayid" varchar(32) COLLATE "pg_catalog"."default",
|
||
"remark1" varchar(32) COLLATE "pg_catalog"."default",
|
||
"remark2" varchar(32) COLLATE "pg_catalog"."default",
|
||
"org" varchar(32) COLLATE "pg_catalog"."default",
|
||
"remark3" varchar(32) COLLATE "pg_catalog"."default",
|
||
"remark4" varchar(32) COLLATE "pg_catalog"."default",
|
||
"status" int4,
|
||
"remark5" varchar(32) COLLATE "pg_catalog"."default"
|
||
)
|
||
;
|
||
COMMENT ON COLUMN "public"."lora_device_info"."dev_eui" IS '终端ID';
|
||
COMMENT ON COLUMN "public"."lora_device_info"."join_eui" IS '应用ID';
|
||
COMMENT ON COLUMN "public"."lora_device_info"."name" IS '节点名称';
|
||
COMMENT ON COLUMN "public"."lora_device_info"."app_key" IS '应用密钥';
|
||
COMMENT ON COLUMN "public"."lora_device_info"."support_otaa" IS '是否支持OTAA';
|
||
COMMENT ON COLUMN "public"."lora_device_info"."support_classc" IS '是否支持ClassC';
|
||
COMMENT ON COLUMN "public"."lora_device_info"."gatewayid" IS '所属网关';
|
||
COMMENT ON COLUMN "public"."lora_device_info"."remark1" IS '预留字段1';
|
||
COMMENT ON COLUMN "public"."lora_device_info"."remark2" IS '预留字段2';
|
||
COMMENT ON COLUMN "public"."lora_device_info"."org" IS '所属企业';
|
||
COMMENT ON COLUMN "public"."lora_device_info"."remark3" IS '预留字段3';
|
||
COMMENT ON COLUMN "public"."lora_device_info"."remark4" IS '预留字段4';
|
||
COMMENT ON COLUMN "public"."lora_device_info"."status" IS '1-在线，2-离线，0-从未连接';
|
||
COMMENT ON COLUMN "public"."lora_device_info"."remark5" IS '预留字段5';
|
||
|
||
-- ----------------------------
|
||
-- Primary Key structure for table lora_device_info
|
||
-- ----------------------------
|
||
ALTER TABLE "public"."lora_device_info" ADD CONSTRAINT "lora_device_info_pkey" PRIMARY KEY ("dev_eui");
|