programs_info/无锡市生命线项目/其他文件/新增表/ps_jc_jcxyz.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:01
*/


-- ----------------------------
-- Table structure for ps_jc_jcxyz
-- ----------------------------
DROP TABLE IF EXISTS "public"."ps_jc_jcxyz";
CREATE TABLE "public"."ps_jc_jcxyz" (
  "bsm" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
  "sbbsm" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
  "sblx" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
  "jczb" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
  "bjyz" numeric(13,3) NOT NULL,
  "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 DEFAULT 1
)
;
COMMENT ON COLUMN "public"."ps_jc_jcxyz"."bsm" IS '标识码';
COMMENT ON COLUMN "public"."ps_jc_jcxyz"."sbbsm" IS '设备标识码';
COMMENT ON COLUMN "public"."ps_jc_jcxyz"."sblx" IS '设备类型';
COMMENT ON COLUMN "public"."ps_jc_jcxyz"."jczb" IS '监测指标';
COMMENT ON COLUMN "public"."ps_jc_jcxyz"."bjyz" IS '报警阈值';
COMMENT ON COLUMN "public"."ps_jc_jcxyz"."bz" IS '备注';
COMMENT ON COLUMN "public"."ps_jc_jcxyz"."yskzjbz" IS '原始库主键标志';
COMMENT ON COLUMN "public"."ps_jc_jcxyz"."sjtbzt" IS '数据同步状态';
COMMENT ON COLUMN "public"."ps_jc_jcxyz"."tbsj" IS '同步时间';
COMMENT ON COLUMN "public"."ps_jc_jcxyz"."lb" IS '类别：1(雨水)/2(污水)/3(合流)';
COMMENT ON TABLE "public"."ps_jc_jcxyz" IS '监测项阈值属性结构表';

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