| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768 |
- /*
- Navicat Premium Data Transfer
- Source Server : 生命线前置数据库47.113.226.116
- Source Server Type : PostgreSQL
- Source Server Version : 140009
- Source Host : 47.113.226.116:5333
- Source Catalog : citylifeline_db
- Source Schema : public
- Target Server Type : PostgreSQL
- Target Server Version : 140009
- File Encoding : 65001
- Date: 27/11/2023 11:33:10
- */
- -- ----------------------------
- -- Table structure for gs_jc_jcsb
- -- ----------------------------
- DROP TABLE IF EXISTS "public"."gs_jc_jcsb";
- CREATE TABLE "public"."gs_jc_jcsb" (
- "bsm" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
- "dwbsm" varchar(32) COLLATE "pg_catalog"."default",
- "sblx" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
- "sbmc" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
- "sbxh" varchar(50) COLLATE "pg_catalog"."default",
- "jczb" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
- "cjpl" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
- "scpl" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
- "sbzt" int4,
- "csmc" varchar(50) COLLATE "pg_catalog"."default",
- "xdgd" numeric(10,3),
- "azsj" date,
- "azwhdw" varchar(100) COLLATE "pg_catalog"."default",
- "gdfs" varchar(32) COLLATE "pg_catalog"."default",
- "bz" varchar(255) COLLATE "pg_catalog"."default",
- "yskzjbz" varchar(64) COLLATE "pg_catalog"."default",
- "sjtbzt" varchar(16) COLLATE "pg_catalog"."default" NOT NULL,
- "tbsj" timestamp(6) NOT NULL
- )
- ;
- COMMENT ON COLUMN "public"."gs_jc_jcsb"."bsm" IS '标识码';
- COMMENT ON COLUMN "public"."gs_jc_jcsb"."dwbsm" IS '点位标识码';
- COMMENT ON COLUMN "public"."gs_jc_jcsb"."sblx" IS '设备类型';
- COMMENT ON COLUMN "public"."gs_jc_jcsb"."sbmc" IS '设备名称';
- COMMENT ON COLUMN "public"."gs_jc_jcsb"."sbxh" IS '设备型号';
- COMMENT ON COLUMN "public"."gs_jc_jcsb"."jczb" IS '监测指标';
- COMMENT ON COLUMN "public"."gs_jc_jcsb"."cjpl" IS '采集频率';
- COMMENT ON COLUMN "public"."gs_jc_jcsb"."scpl" IS '上传频率';
- COMMENT ON COLUMN "public"."gs_jc_jcsb"."sbzt" IS '设备状态';
- COMMENT ON COLUMN "public"."gs_jc_jcsb"."csmc" IS '厂商名称';
- COMMENT ON COLUMN "public"."gs_jc_jcsb"."xdgd" IS '相对高度';
- COMMENT ON COLUMN "public"."gs_jc_jcsb"."azsj" IS '安装时间';
- COMMENT ON COLUMN "public"."gs_jc_jcsb"."azwhdw" IS '安装维护单位';
- COMMENT ON COLUMN "public"."gs_jc_jcsb"."gdfs" IS '供电方式';
- COMMENT ON COLUMN "public"."gs_jc_jcsb"."bz" IS '备注';
- COMMENT ON COLUMN "public"."gs_jc_jcsb"."yskzjbz" IS '原始库主键标志';
- COMMENT ON COLUMN "public"."gs_jc_jcsb"."sjtbzt" IS '数据同步状态';
- COMMENT ON COLUMN "public"."gs_jc_jcsb"."tbsj" IS '同步时间';
- COMMENT ON TABLE "public"."gs_jc_jcsb" IS '监测设备属性结构表';
- -- ----------------------------
- -- Primary Key structure for table gs_jc_jcsb
- -- ----------------------------
- ALTER TABLE "public"."gs_jc_jcsb" ADD CONSTRAINT "gs_jc_jcsb_pkey" PRIMARY KEY ("bsm");
|
