| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778 |
- /*
- 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");
|
