programs_info/无锡市生命线项目/其他文件/rq_jg_lhjcjl.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:13
*/


-- ----------------------------
-- Table structure for rq_jg_lhjcjl
-- ----------------------------
DROP TABLE IF EXISTS "ztfbk_sjg"."rq_jg_lhjcjl";
CREATE TABLE "ztfbk_sjg"."rq_jg_lhjcjl" (
  "bsm" varchar COLLATE "pg_catalog"."default",
  "xzqhdm" varchar COLLATE "pg_catalog"."default",
  "qtbm" varchar COLLATE "pg_catalog"."default",
  "cjbm" varchar COLLATE "pg_catalog"."default",
  "jcrq" varchar COLLATE "pg_catalog"."default",
  "jcxm" varchar COLLATE "pg_catalog"."default",
  "jcnr" varchar COLLATE "pg_catalog"."default",
  "jcjg" varchar COLLATE "pg_catalog"."default",
  "zrdw" varchar COLLATE "pg_catalog"."default",
  "jcry" varchar COLLATE "pg_catalog"."default",
  "xczp" varchar COLLATE "pg_catalog"."default",
  "bz" varchar COLLATE "pg_catalog"."default"
)
;
COMMENT ON COLUMN "ztfbk_sjg"."rq_jg_lhjcjl"."bsm" IS '标识码';
COMMENT ON COLUMN "ztfbk_sjg"."rq_jg_lhjcjl"."xzqhdm" IS '行政区划代码';
COMMENT ON COLUMN "ztfbk_sjg"."rq_jg_lhjcjl"."qtbm" IS '牵头部门';
COMMENT ON COLUMN "ztfbk_sjg"."rq_jg_lhjcjl"."cjbm" IS '参检部门';
COMMENT ON COLUMN "ztfbk_sjg"."rq_jg_lhjcjl"."jcrq" IS '检查日期';
COMMENT ON COLUMN "ztfbk_sjg"."rq_jg_lhjcjl"."jcxm" IS '检查项目';
COMMENT ON COLUMN "ztfbk_sjg"."rq_jg_lhjcjl"."jcnr" IS '检查内容';
COMMENT ON COLUMN "ztfbk_sjg"."rq_jg_lhjcjl"."jcjg" IS '检查结果';
COMMENT ON COLUMN "ztfbk_sjg"."rq_jg_lhjcjl"."zrdw" IS '责任单位';
COMMENT ON COLUMN "ztfbk_sjg"."rq_jg_lhjcjl"."jcry" IS '检查人员';
COMMENT ON COLUMN "ztfbk_sjg"."rq_jg_lhjcjl"."xczp" IS '现场照片';
COMMENT ON COLUMN "ztfbk_sjg"."rq_jg_lhjcjl"."bz" IS '备注';
COMMENT ON TABLE "ztfbk_sjg"."rq_jg_lhjcjl" IS '联合检查记录';