programs_info/无锡市生命线项目/数据库备份/删除前备份/政务网同步到外网/jcss_rqcz.sql

/*
 Navicat Premium Data Transfer

 Source Server         : 政务网生命线(内网)2.21.138.148
 Source Server Type    : PostgreSQL
 Source Server Version : 140009
 Source Host           : 2.21.138.148:5333
 Source Catalog        : citylifeline_db
 Source Schema         : public

 Target Server Type    : PostgreSQL
 Target Server Version : 140009
 File Encoding         : 65001

 Date: 06/03/2024 10:35:37
*/


-- ----------------------------
-- Table structure for jcss_rqcz
-- ----------------------------
DROP TABLE IF EXISTS "public"."jcss_rqcz";
CREATE TABLE "public"."jcss_rqcz" (
  "id" varchar(64) COLLATE "pg_catalog"."default" NOT NULL,
  "jcss_id" varchar(64) COLLATE "pg_catalog"."default",
  "czlx" varchar(16) COLLATE "pg_catalog"."default",
  "cqnl" varchar(50) COLLATE "pg_catalog"."default",
  "sjcql" varchar(50) COLLATE "pg_catalog"."default",
  "gznl" varchar(50) COLLATE "pg_catalog"."default",
  "ngql" numeric(10,2),
  "xsgynl" numeric(10,2),
  "zps" numeric(10,2),
  "yl" numeric(10,2),
  "ll" numeric(10,2),
  "yw" numeric(10,2),
  "wd" numeric(10,2),
  "jgrq" timestamp(6),
  "remark" varchar(500) COLLATE "pg_catalog"."default",
  "defined" int4,
  "deleted" int4,
  "created_at" timestamp(6),
  "created_by" varchar(100) COLLATE "pg_catalog"."default",
  "updated_at" timestamp(6),
  "updated_by" varchar(100) COLLATE "pg_catalog"."default"
)
;
COMMENT ON COLUMN "public"."jcss_rqcz"."jcss_id" IS '基础设施id';
COMMENT ON COLUMN "public"."jcss_rqcz"."czlx" IS '场站类型 0-气化站、1-门站、2-储配站、3-加气站、4-调压站、5-瓶装供应站、6-LNG站';
COMMENT ON COLUMN "public"."jcss_rqcz"."cqnl" IS '储气能力 单位：万立方米';
COMMENT ON COLUMN "public"."jcss_rqcz"."sjcql" IS '实际储气量 单位：万立方米';
COMMENT ON COLUMN "public"."jcss_rqcz"."gznl" IS '灌装能力 单位：万立方米';
COMMENT ON COLUMN "public"."jcss_rqcz"."ngql" IS '年供气量 单位：万立方米';
COMMENT ON COLUMN "public"."jcss_rqcz"."xsgynl" IS '小时供应能力 单位：万立方米；场站类型为门站、调压站、气化站、加气站时填写';
COMMENT ON COLUMN "public"."jcss_rqcz"."zps" IS '重瓶数';
COMMENT ON COLUMN "public"."jcss_rqcz"."yl" IS '压力 单位：Mpa 当场站类型为气化站、门站、储配站、加气站、调压站时填写，取场站整体运行数据';
COMMENT ON COLUMN "public"."jcss_rqcz"."ll" IS '流量 单位：m³/h 当场站类型为门站、调压站时填写，取场站整体运行数据';
COMMENT ON COLUMN "public"."jcss_rqcz"."yw" IS '液位 单位：mm 当场站类型为储配站、LNG站时填写，取场站整体运行数据';
COMMENT ON COLUMN "public"."jcss_rqcz"."wd" IS '温度 单位：℃ 当场站类型为气化站、门站、储配站、加气站、调压站时填写，取场站整体运行数据';
COMMENT ON COLUMN "public"."jcss_rqcz"."jgrq" IS '竣工日期';
COMMENT ON COLUMN "public"."jcss_rqcz"."remark" IS '备注';
COMMENT ON TABLE "public"."jcss_rqcz" IS '燃气场站';

-- ----------------------------
-- Records of jcss_rqcz
-- ----------------------------
INSERT INTO "public"."jcss_rqcz" VALUES ('8e6af919aee294205890bc07c89bcb1f', 'rqcz_8e6af919aee294205890bc07c89bcb1f', '4', '0.3万方', '0.3万方', '无', 103.00, 0.10, NULL, 20.00, NULL, NULL, 40.00, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:00.032', '-1');
INSERT INTO "public"."jcss_rqcz" VALUES ('0dd9b659b84c6e3901c3a65bc0ed89f2', 'rqcz_0dd9b659b84c6e3901c3a65bc0ed89f2', '4', '0.3万方', '0.3万方', '无', 440.00, 0.10, NULL, 20.00, NULL, NULL, 40.00, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:00.071', '-1');
INSERT INTO "public"."jcss_rqcz" VALUES ('18797b5b3283495b51ffb6d2ddbc6be0', 'rqcz_18797b5b3283495b51ffb6d2ddbc6be0', '4', '0.24万方', '0.24万方', '无', 247.00, 0.10, NULL, 20.00, NULL, NULL, 40.00, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:00.085', '-1');
INSERT INTO "public"."jcss_rqcz" VALUES ('cb26369e6ad54c169ca4ae5c399ca67f', 'rqcz_cb26369e6ad54c169ca4ae5c399ca67f', '4', '0.2万方', '0.2万方', '无', 456.00, 0.10, NULL, 20.00, NULL, NULL, 40.00, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:00.093', '-1');
INSERT INTO "public"."jcss_rqcz" VALUES ('431eefed063bd895178334140965a82a', 'rqcz_431eefed063bd895178334140965a82a', '4', '0.33万方', '0.33万方', '无', 434.00, 0.10, NULL, 20.00, NULL, NULL, 40.00, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:00.099', '-1');
INSERT INTO "public"."jcss_rqcz" VALUES ('8032b4b2836964ee19ecc7baa0ebe454', 'rqcz_8032b4b2836964ee19ecc7baa0ebe454', '4', '0.2万方', '0.2万方', '无', 257.00, 0.10, NULL, 20.00, NULL, NULL, 40.00, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:00.106', '-1');
INSERT INTO "public"."jcss_rqcz" VALUES ('9fff6a4366c213cadfb4486106704e0e', 'rqcz_9fff6a4366c213cadfb4486106704e0e', '4', '0.3万方', '0.3万方', '无', 414.00, 0.10, NULL, 20.00, NULL, NULL, 40.00, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:00.118', '-1');
INSERT INTO "public"."jcss_rqcz" VALUES ('aac32e209b1f7eda8a02ad8ca5dafebc', 'rqcz_aac32e209b1f7eda8a02ad8ca5dafebc', '4', '0.23万方', '0.23万方', '无', 247.00, 0.10, NULL, 20.00, NULL, NULL, 40.00, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:00.123', '-1');
INSERT INTO "public"."jcss_rqcz" VALUES ('717d8fd5388e9ed55f271d58220bb96b', 'rqcz_717d8fd5388e9ed55f271d58220bb96b', '4', '0.23万方', '0.23万方', '无', 78.00, 0.10, NULL, 20.00, NULL, NULL, 40.00, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:00.129', '-1');
INSERT INTO "public"."jcss_rqcz" VALUES ('5d822edb0295cfe4750abca3ad750863', 'rqcz_5d822edb0295cfe4750abca3ad750863', '4', '0.23万方', '0.23万方', '无', 93.00, 0.10, NULL, 20.00, NULL, NULL, 40.00, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:00.135', '-1');
INSERT INTO "public"."jcss_rqcz" VALUES ('2afa32421f562049c43ebb34832f76e4', 'rqcz_2afa32421f562049c43ebb34832f76e4', '99', '0.23万方', '0.23万方', '无', 77.00, 0.10, NULL, 20.00, NULL, NULL, 40.00, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:00.141', '-1');
INSERT INTO "public"."jcss_rqcz" VALUES ('26c9cb601000d196cb3bbdf586857410', 'rqcz_26c9cb601000d196cb3bbdf586857410', '3', '72万方', '72万方', '罐装杜瓦罐410L的，一天两百个', 5.50, NULL, NULL, 2.50, 6.80, 56000.00, 5.00, NULL, NULL, NULL, 1, NULL, NULL, '2024-03-06 00:00:00.147', '-1');

-- ----------------------------
-- Primary Key structure for table jcss_rqcz
-- ----------------------------
ALTER TABLE "public"."jcss_rqcz" ADD CONSTRAINT "jcss_rqcz_pkey" PRIMARY KEY ("id");