programs_info/无锡市生命线项目/其他文件/rq_jg_aqzxjcjl.sql

/*
 Navicat Premium Data Transfer

 Source Server         : 2.21.138.129 发布库 sjg
 Source Server Type    : PostgreSQL
 Source Server Version : 100023
 Source Host           : 2.21.138.129:5432
 Source Catalog        : ztfbk_db
 Source Schema         : ztfbk_sjg

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

 Date: 05/12/2023 16:42:03
*/


-- ----------------------------
-- Table structure for rq_jg_aqzxjcjl
-- ----------------------------
DROP TABLE IF EXISTS "ztfbk_sjg"."rq_jg_aqzxjcjl";
CREATE TABLE "ztfbk_sjg"."rq_jg_aqzxjcjl" (
  "bsm" varchar COLLATE "pg_catalog"."default",
  "xzqhdm" varchar COLLATE "pg_catalog"."default",
  "jcdx" varchar COLLATE "pg_catalog"."default",
  "lx" varchar COLLATE "pg_catalog"."default",
  "jcdy" varchar COLLATE "pg_catalog"."default",
  "jcxm" varchar COLLATE "pg_catalog"."default",
  "jcff" varchar COLLATE "pg_catalog"."default",
  "jcnr" varchar COLLATE "pg_catalog"."default",
  "jcjg" varchar COLLATE "pg_catalog"."default",
  "czyh" varchar COLLATE "pg_catalog"."default",
  "jcrq" varchar COLLATE "pg_catalog"."default",
  "jcry" varchar COLLATE "pg_catalog"."default",
  "jcdw" varchar COLLATE "pg_catalog"."default",
  "ssqsdw" varchar COLLATE "pg_catalog"."default",
  "zgdw" varchar COLLATE "pg_catalog"."default",
  "fj" varchar COLLATE "pg_catalog"."default",
  "bz" varchar COLLATE "pg_catalog"."default"
)
;
COMMENT ON COLUMN "ztfbk_sjg"."rq_jg_aqzxjcjl"."bsm" IS '标识码';
COMMENT ON COLUMN "ztfbk_sjg"."rq_jg_aqzxjcjl"."xzqhdm" IS '行政区划代码';
COMMENT ON COLUMN "ztfbk_sjg"."rq_jg_aqzxjcjl"."jcdx" IS '检查对象';
COMMENT ON COLUMN "ztfbk_sjg"."rq_jg_aqzxjcjl"."lx" IS '类型';
COMMENT ON COLUMN "ztfbk_sjg"."rq_jg_aqzxjcjl"."jcdy" IS '检查单元';
COMMENT ON COLUMN "ztfbk_sjg"."rq_jg_aqzxjcjl"."jcxm" IS '检查项目';
COMMENT ON COLUMN "ztfbk_sjg"."rq_jg_aqzxjcjl"."jcff" IS '检查方法';
COMMENT ON COLUMN "ztfbk_sjg"."rq_jg_aqzxjcjl"."jcnr" IS '检查内容';
COMMENT ON COLUMN "ztfbk_sjg"."rq_jg_aqzxjcjl"."jcjg" IS '检查结果';
COMMENT ON COLUMN "ztfbk_sjg"."rq_jg_aqzxjcjl"."czyh" IS '存在隐患';
COMMENT ON COLUMN "ztfbk_sjg"."rq_jg_aqzxjcjl"."jcrq" IS '检查日期';
COMMENT ON COLUMN "ztfbk_sjg"."rq_jg_aqzxjcjl"."jcry" IS '检查人员';
COMMENT ON COLUMN "ztfbk_sjg"."rq_jg_aqzxjcjl"."jcdw" IS '检查单位';
COMMENT ON COLUMN "ztfbk_sjg"."rq_jg_aqzxjcjl"."ssqsdw" IS '设施权属单位';
COMMENT ON COLUMN "ztfbk_sjg"."rq_jg_aqzxjcjl"."zgdw" IS '主管单位';
COMMENT ON COLUMN "ztfbk_sjg"."rq_jg_aqzxjcjl"."fj" IS '附件';
COMMENT ON COLUMN "ztfbk_sjg"."rq_jg_aqzxjcjl"."bz" IS '备注';
COMMENT ON TABLE "ztfbk_sjg"."rq_jg_aqzxjcjl" IS '安全专项检查记录';