| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970 |
- /*
- 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:32:53
- */
- -- ----------------------------
- -- Table structure for ps_jc_jcsb
- -- ----------------------------
- DROP TABLE IF EXISTS "public"."ps_jc_jcsb";
- CREATE TABLE "public"."ps_jc_jcsb" (
- "bsm" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
- "dwbsm" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
- "sblx" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
- "sbmc" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
- "sbxh" varchar(32) 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 NOT NULL,
- "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,
- "lb" int4 NOT NULL DEFAULT 1
- )
- ;
- COMMENT ON COLUMN "public"."ps_jc_jcsb"."bsm" IS '标识码';
- COMMENT ON COLUMN "public"."ps_jc_jcsb"."dwbsm" IS '点位标识码';
- COMMENT ON COLUMN "public"."ps_jc_jcsb"."sblx" IS '设备类型';
- COMMENT ON COLUMN "public"."ps_jc_jcsb"."sbmc" IS '设备名称';
- COMMENT ON COLUMN "public"."ps_jc_jcsb"."sbxh" IS '设备型号';
- COMMENT ON COLUMN "public"."ps_jc_jcsb"."jczb" IS '监测指标';
- COMMENT ON COLUMN "public"."ps_jc_jcsb"."cjpl" IS '采集频率';
- COMMENT ON COLUMN "public"."ps_jc_jcsb"."scpl" IS '上传频率';
- COMMENT ON COLUMN "public"."ps_jc_jcsb"."sbzt" IS '设备状态';
- COMMENT ON COLUMN "public"."ps_jc_jcsb"."csmc" IS '厂商名称';
- COMMENT ON COLUMN "public"."ps_jc_jcsb"."xdgd" IS '相对高度';
- COMMENT ON COLUMN "public"."ps_jc_jcsb"."azsj" IS '安装时间';
- COMMENT ON COLUMN "public"."ps_jc_jcsb"."azwhdw" IS '安装维护单位';
- COMMENT ON COLUMN "public"."ps_jc_jcsb"."gdfs" IS '供电方式';
- COMMENT ON COLUMN "public"."ps_jc_jcsb"."bz" IS '备注';
- COMMENT ON COLUMN "public"."ps_jc_jcsb"."yskzjbz" IS '原始库主键标志';
- COMMENT ON COLUMN "public"."ps_jc_jcsb"."sjtbzt" IS '数据同步状态';
- COMMENT ON COLUMN "public"."ps_jc_jcsb"."tbsj" IS '同步时间';
- COMMENT ON COLUMN "public"."ps_jc_jcsb"."lb" IS '类别：1(雨水)/2(污水)/3(合流)';
- COMMENT ON TABLE "public"."ps_jc_jcsb" IS '监测设备属性结构表';
- -- ----------------------------
- -- Primary Key structure for table ps_jc_jcsb
- -- ----------------------------
- ALTER TABLE "public"."ps_jc_jcsb" ADD CONSTRAINT "ps_jc_jcsb_pkey" PRIMARY KEY ("bsm");
|
