49 lines
1.8 KiB
SQL
49 lines
1.8 KiB
SQL
/*
|
|
Navicat Premium Data Transfer
|
|
|
|
Source Server : 115.238.53.59
|
|
Source Server Type : PostgreSQL
|
|
Source Server Version : 120012
|
|
Source Host : 115.238.53.59:5432
|
|
Source Catalog : xiuosiot
|
|
Source Schema : public
|
|
|
|
Target Server Type : PostgreSQL
|
|
Target Server Version : 120012
|
|
File Encoding : 65001
|
|
|
|
Date: 20/10/2022 17:05:04
|
|
*/
|
|
|
|
|
|
-- ----------------------------
|
|
-- Table structure for device_log_info
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS "public"."device_log_info";
|
|
CREATE TABLE "public"."device_log_info" (
|
|
"device_no" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
|
|
"log_time" timestamp(6) NOT NULL,
|
|
"device_type" varchar(32) COLLATE "pg_catalog"."default",
|
|
"thread_no" varchar(32) COLLATE "pg_catalog"."default",
|
|
"log_level" int4,
|
|
"device_log" varchar(500) COLLATE "pg_catalog"."default",
|
|
"org" varchar(32) COLLATE "pg_catalog"."default"
|
|
)
|
|
;
|
|
COMMENT ON COLUMN "public"."device_log_info"."device_no" IS '设备编号';
|
|
COMMENT ON COLUMN "public"."device_log_info"."log_time" IS '日志时间';
|
|
COMMENT ON COLUMN "public"."device_log_info"."device_type" IS '设备类型';
|
|
COMMENT ON COLUMN "public"."device_log_info"."thread_no" IS '线程号';
|
|
COMMENT ON COLUMN "public"."device_log_info"."log_level" IS '0=info 1=worring 2= error';
|
|
COMMENT ON COLUMN "public"."device_log_info"."device_log" IS '日志内容';
|
|
COMMENT ON COLUMN "public"."device_log_info"."org" IS '所属公司';
|
|
|
|
-- ----------------------------
|
|
-- Records of device_log_info
|
|
-- ----------------------------
|
|
|
|
-- ----------------------------
|
|
-- Primary Key structure for table device_log_info
|
|
-- ----------------------------
|
|
ALTER TABLE "public"."device_log_info" ADD CONSTRAINT "device_log_info_pkey" PRIMARY KEY ("device_no", "log_time");
|