/*
 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:30:25
*/


-- ----------------------------
-- Table structure for rq_js_rqyh
-- ----------------------------
DROP TABLE IF EXISTS "public"."rq_js_rqyh";
CREATE TABLE "public"."rq_js_rqyh" (
  "bsm" varchar(32) COLLATE "pg_catalog"."default" NOT NULL,
  "xzqhdm" varchar(6) COLLATE "pg_catalog"."default" NOT NULL,
  "yhlx" int4 NOT NULL,
  "fjmyhlx" int4,
  "yhxx" varchar(100) COLLATE "pg_catalog"."default" NOT NULL,
  "xxdz" varchar(255) COLLATE "pg_catalog"."default" NOT NULL,
  "szjdhsq" varchar(50) COLLATE "pg_catalog"."default",
  "qyrq" date,
  "yqfw" varchar(255) COLLATE "pg_catalog"."default",
  "qyzl" int4 NOT NULL,
  "yhqpzl" int4,
  "yhqcps" int4,
  "yqgm" numeric(12,2),
  "gqdw" varchar(100) COLLATE "pg_catalog"."default" NOT NULL,
  "sbssqk" varchar(255) COLLATE "pg_catalog"."default",
  "sfzdyqcs" bool NOT NULL,
  "bjq" int4 NOT NULL,
  "sfyqdzz" bool NOT NULL,
  "bz" varchar(255) COLLATE "pg_catalog"."default",
  "yskzjbz" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
  "sjtbzt" varchar(16) COLLATE "pg_catalog"."default" NOT NULL,
  "tbsj" timestamp(6) NOT NULL,
  "kjxx" "public"."geometry"
)
;
COMMENT ON COLUMN "public"."rq_js_rqyh"."bsm" IS '标识码';
COMMENT ON COLUMN "public"."rq_js_rqyh"."xzqhdm" IS '行政区划代码';
COMMENT ON COLUMN "public"."rq_js_rqyh"."yhlx" IS '用户类型';
COMMENT ON COLUMN "public"."rq_js_rqyh"."fjmyhlx" IS '非居民用户类型';
COMMENT ON COLUMN "public"."rq_js_rqyh"."yhxx" IS '用户信息';
COMMENT ON COLUMN "public"."rq_js_rqyh"."xxdz" IS '详细地址';
COMMENT ON COLUMN "public"."rq_js_rqyh"."szjdhsq" IS '所在街道和社区';
COMMENT ON COLUMN "public"."rq_js_rqyh"."qyrq" IS '启用日期';
COMMENT ON COLUMN "public"."rq_js_rqyh"."yqfw" IS '用气范围';
COMMENT ON COLUMN "public"."rq_js_rqyh"."qyzl" IS '气源种类';
COMMENT ON COLUMN "public"."rq_js_rqyh"."yhqpzl" IS '液化气瓶种类';
COMMENT ON COLUMN "public"."rq_js_rqyh"."yhqcps" IS '液化气存瓶数';
COMMENT ON COLUMN "public"."rq_js_rqyh"."yqgm" IS '用气规模';
COMMENT ON COLUMN "public"."rq_js_rqyh"."gqdw" IS '供气单位';
COMMENT ON COLUMN "public"."rq_js_rqyh"."sbssqk" IS '设备设施情况';
COMMENT ON COLUMN "public"."rq_js_rqyh"."sfzdyqcs" IS '是否重点用气场所';
COMMENT ON COLUMN "public"."rq_js_rqyh"."bjq" IS '报警器';
COMMENT ON COLUMN "public"."rq_js_rqyh"."sfyqdzz" IS '是否有切断装置';
COMMENT ON COLUMN "public"."rq_js_rqyh"."bz" IS '备注';
COMMENT ON COLUMN "public"."rq_js_rqyh"."yskzjbz" IS '原始库主键标志';
COMMENT ON COLUMN "public"."rq_js_rqyh"."sjtbzt" IS '数据同步状态';
COMMENT ON COLUMN "public"."rq_js_rqyh"."tbsj" IS '同步时间';
COMMENT ON COLUMN "public"."rq_js_rqyh"."kjxx" IS '空间信息';
COMMENT ON TABLE "public"."rq_js_rqyh" IS '燃气用户属性结构表';

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