/* 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 '联合检查记录';