programs_info/无锡市生命线项目/其他文件/新增表/sg_jc_jcsb.sql

/*
 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:27
*/


-- ----------------------------
-- Table structure for sg_jc_jcsb
-- ----------------------------
DROP TABLE IF EXISTS "public"."sg_jc_jcsb";
CREATE TABLE "public"."sg_jc_jcsb" (
  "bsm" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
  "dwbsm" varchar(32) COLLATE "pg_catalog"."default",
  "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,
  "jcssid" varchar(32) COLLATE "pg_catalog"."default",
  "xmbh" varchar(32) COLLATE "pg_catalog"."default",
  "jcssqsqy" varchar(100) COLLATE "pg_catalog"."default"
)
;
COMMENT ON COLUMN "public"."sg_jc_jcsb"."bsm" IS '标识码';
COMMENT ON COLUMN "public"."sg_jc_jcsb"."dwbsm" IS '点位标识码';
COMMENT ON COLUMN "public"."sg_jc_jcsb"."sblx" IS '设备类型';
COMMENT ON COLUMN "public"."sg_jc_jcsb"."sbmc" IS '设备名称';
COMMENT ON COLUMN "public"."sg_jc_jcsb"."sbxh" IS '设备型号';
COMMENT ON COLUMN "public"."sg_jc_jcsb"."jczb" IS '监测指标';
COMMENT ON COLUMN "public"."sg_jc_jcsb"."cjpl" IS '采集频率';
COMMENT ON COLUMN "public"."sg_jc_jcsb"."scpl" IS '上传频率';
COMMENT ON COLUMN "public"."sg_jc_jcsb"."sbzt" IS '设备状态';
COMMENT ON COLUMN "public"."sg_jc_jcsb"."csmc" IS '厂商名称';
COMMENT ON COLUMN "public"."sg_jc_jcsb"."xdgd" IS '相对高度';
COMMENT ON COLUMN "public"."sg_jc_jcsb"."azsj" IS '安装时间';
COMMENT ON COLUMN "public"."sg_jc_jcsb"."azwhdw" IS '安装维护单位';
COMMENT ON COLUMN "public"."sg_jc_jcsb"."gdfs" IS '供电方式';
COMMENT ON COLUMN "public"."sg_jc_jcsb"."bz" IS '备注';
COMMENT ON COLUMN "public"."sg_jc_jcsb"."yskzjbz" IS '原始库主键标志';
COMMENT ON COLUMN "public"."sg_jc_jcsb"."sjtbzt" IS '数据同步状态';
COMMENT ON COLUMN "public"."sg_jc_jcsb"."tbsj" IS '同步时间';
COMMENT ON COLUMN "public"."sg_jc_jcsb"."jcssid" IS '监测设施编号';
COMMENT ON COLUMN "public"."sg_jc_jcsb"."xmbh" IS '项目编号';
COMMENT ON COLUMN "public"."sg_jc_jcsb"."jcssqsqy" IS '监测设施权属企业';
COMMENT ON TABLE "public"."sg_jc_jcsb" IS '监测设备属性结构表';

-- ----------------------------
-- Primary Key structure for table sg_jc_jcsb
-- ----------------------------
ALTER TABLE "public"."sg_jc_jcsb" ADD CONSTRAINT "sg_jc_jcsb_pkey" PRIMARY KEY ("bsm");