美文网首页
基于TBDS的数据迁移(postgreSQL到hive)第一部分

基于TBDS的数据迁移(postgreSQL到hive)第一部分

作者: yayooo | 来源:发表于2020-09-07 17:41 被阅读0次
    • 前提:tbds现有功能只有postgrel到hdfs,再从hdfs到hive。
      tbds面向客户:政务人员

    • 样例数据
      1.bmk_second.cqsxfjyzd

    CREATE TABLE `cqsxfjyzd` (
      `table_name` varchar(255) DEFAULT NULL,
      `field` varchar(255) DEFAULT NULL,
      `field_type` varchar(255) DEFAULT NULL,
      `is_string` varchar(255) DEFAULT NULL,
      `field_number` int(255) DEFAULT NULL,
      `field_comment` varchar(255) DEFAULT NULL,
      `table_comment` varchar(255) DEFAULT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'cqdc_uuid', 'character varying(32)', '是', 1, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'id', 'character varying(32)', '是', 2, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'djzbbm', 'character varying(50)', '是', 3, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'zbmc', 'character varying(50)', '是', 4, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'zbbm', 'character varying(50)', '是', 5, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'sjzbbm', 'character varying(50)', '是', 6, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'zblxdm', 'character varying(8)', '是', 7, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'djzbzkdm', 'character varying(8)', '是', 8, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'ssxfjg', 'character varying(32)', '是', 9, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'gpsbh', 'character varying(100)', '是', 10, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'cldjdm', 'character varying(8)', '是', 11, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'cphm', 'character varying(20)', '是', 12, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'gghm', 'character varying(50)', '是', 13, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'zcbh', 'character varying(32)', '是', 14, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'ckj', 'numeric(22,6)', '否', 15, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'sb', 'character varying(32)', '是', 16, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'ys', 'character varying(20)', '是', 17, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'gbdm', 'character varying(32)', '是', 18, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'sccjdm', 'character varying(32)', '是', 19, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'sccjmc', 'character varying(100)', '是', 20, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'jkzbgndls', 'character varying(50)', '是', 21, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'shfw', 'character varying(50)', '是', 22, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'zrrid', 'character varying(32)', '是', 23, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'zrrxm', 'character varying(40)', '是', 24, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'ccrq', 'date', '否', 25, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'zbrq', 'date', '否', 26, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'bfrq', 'date', '否', 27, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'yxqz', 'date', '否', 28, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'ljyssj', 'numeric(22,6)', '否', 29, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'ljsycs', 'numeric(22,6)', '否', 30, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'bcbyrq', 'date', '否', 31, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'xcbyrq', 'date', '否', 32, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'cjh', 'character varying(50)', '是', 33, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'fdjbh', 'character varying(100)', '是', 34, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'pch', 'character varying(32)', '是', 35, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'jldwdm', 'character varying(8)', '是', 36, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'sfyyyl', 'character varying(1)', '是', 37, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'sdzt', 'integer', '否', 38, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'clztdm_mh', 'character varying(32)', '是', 39, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'jlzt', 'integer', '否', 40, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'cszt', 'integer', '否', 41, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'sjc', 'date', '否', 42, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'bz', 'character varying(400)', '是', 43, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'dthh', 'character varying(30)', '是', 44, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'ajbh', 'character varying(32)', '是', 45, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'sfzp', 'integer', '否', 46, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'sfkzhid', 'integer', '否', 47, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'sfkzd', 'integer', '否', 48, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'clbh', 'integer', '否', 49, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'cjsj', 'date', '否', 50, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'sjbb', 'numeric(22,6)', '否', 51, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'ywxtbs', 'character varying(100)', '是', 52, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'jcjgzt', 'character varying(8)', '是', 53, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'cljc', 'character varying(200)', '是', 54, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'jksjbb', 'numeric(22,6)', '否', 55, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'zjhm', 'character varying(25)', '是', 56, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'zjlx', 'character varying(10)', '是', 57, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'cqdc_sjgxsj', 'timestamp without time zone', '否', 58, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfcl', 'cqdc_sjscbs', 'character(1)', '是', 59, NULL, NULL);
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjgxx', 'cqdc_uuid', 'character varying(32)', '是', 1, '唯一主键', '消防机构信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjgxx', 'id', 'character varying(32)', '是', 2, 'id', '消防机构信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjgxx', 'jgmc', 'character varying(100)', '是', 3, '机构名称', '消防机构信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjgxx', 'jgjc', 'character varying(50)', '是', 4, '机构简称', '消防机构信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjgxx', 'jgnbid', 'character varying(32)', '是', 5, '机构内部id', '消防机构信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjgxx', 'jglb', 'character varying(1)', '是', 6, '机构类别', '消防机构信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjgxx', 'jgdm', 'character varying(25)', '是', 7, '机构代码', '消防机构信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjgxx', 'xzqdm', 'character varying(8)', '是', 8, '行政区代码', '消防机构信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjgxx', 'jgdz', 'character varying(200)', '是', 9, '机构地址', '消防机构信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjgxx', 'yzbm', 'character varying(6)', '是', 10, '邮政编码', '消防机构信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjgxx', 'lxdh', 'character varying(30)', '是', 11, '联系电话', '消防机构信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjgxx', 'czhm', 'character varying(30)', '是', 12, '传真号码', '消防机构信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjgxx', 'lxr', 'character varying(100)', '是', 13, '联系人', '消防机构信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjgxx', 'sjjg_id', 'character varying(32)', '是', 14, '上级机构_id', '消防机构信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjgxx', 'jglx', 'character varying(8)', '是', 15, '机构类型', '消防机构信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjgxx', 'jgxzdm', 'character varying(8)', '是', 16, '机构性质代码', '消防机构信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjgxx', 'jgs', 'character varying(100)', '是', 17, '机构树', '消防机构信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjgxx', 'jgqz', 'integer', '否', 18, '机构权重', '消防机构信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjgxx', 'jgms', 'character varying(1000)', '是', 19, '机构描述', '消防机构信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjgxx', 'gis_x', 'numeric(22,6)', '否', 20, 'gis_x', '消防机构信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjgxx', 'gis_y', 'numeric(22,6)', '否', 21, 'gis_y', '消防机构信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjgxx', 'gis_h', 'numeric(22,6)', '否', 22, 'gis_h', '消防机构信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjgxx', 'glwzid', 'character varying(32)', '是', 23, '关联位置id', '消防机构信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjgxx', 'xqglid', 'character varying(32)', '是', 24, '辖区管理id', '消防机构信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjgxx', 'ssym', 'character varying(200)', '是', 25, '所属域名', '消防机构信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjgxx', 'zp', 'character varying(100)', '是', 26, '照片', '消防机构信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjgxx', 'jlzt', 'integer', '否', 27, '记录状态', '消防机构信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjgxx', 'cszt', 'integer', '否', 28, '传输状态', '消防机构信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjgxx', 'sjc', 'date', '否', 29, '时间戳', '消防机构信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjgxx', 'bz', 'character varying(400)', '是', 30, '备注', '消防机构信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjgxx', 'zqdwbz', 'integer', '否', 31, '执勤单位标志', '消防机构信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjgxx', 'xqmj', 'character varying(10)', '是', 32, '辖区面积', '消防机构信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjgxx', 'xqfw', 'character varying(10)', '是', 33, '辖区范围', '消防机构信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjgxx', 'dddh', 'character varying(20)', '是', 34, '调度电话', '消防机构信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjgxx', 'jgcxzt', 'character varying(8)', '是', 35, '机构撤销状态', '消防机构信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjgxx', 'ywxtbsid', 'character varying(100)', '是', 36, '业务系统部署id', '消防机构信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjgxx', 'cjsj', 'date', '否', 37, '创建时间', '消防机构信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjgxx', 'sjbb', 'numeric(22,6)', '否', 38, '数据版本', '消防机构信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjgxx', 'jgcxsj', 'date', '否', 39, '机构撤销时间', '消防机构信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjgxx', 'jksjbb', 'numeric(22,6)', '否', 40, '基库数据版本', '消防机构信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjgxx', 'zjhm', 'character varying(25)', '是', 41, '证件号码', '消防机构信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjgxx', 'tyshxydm', 'character varying(18)', '是', 42, '统一社会信用代码', '消防机构信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjgxx', 'zjlx', 'character varying(10)', '是', 43, '证件类型', '消防机构信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjgxx', 'cqdc_sjgxsj', 'timestamp without time zone', '否', 44, '数据更新时间', '消防机构信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjgxx', 'cqdc_sjscbs', 'character(1)', '是', 45, '数据删除标识', '消防机构信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'cqdc_uuid', 'character varying(32)', '是', 1, '唯一主键', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'id', 'character varying(32)', '是', 2, 'id', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'jlzt', 'integer', '否', 3, '记录状态', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'cszt', 'integer', '否', 4, '传输状态', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'sjc', 'date', '否', 5, '时间戳', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'ajbh', 'character varying(32)', '是', 6, '案件编号', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'jjjlid', 'character varying(32)', '是', 7, '接警记录id', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'blajbh', 'character varying(32)', '是', 8, '保留案件编号', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'lajjxh', 'character varying(32)', '是', 9, '立案接警序号', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'zgjgbh', 'character varying(32)', '是', 10, '主管机构编号', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'ywqkdm', 'character varying(32)', '是', 11, '烟雾情况代码', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'xzqybh', 'character varying(32)', '是', 12, '行政区域编号', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'jzjglxdm', 'character varying(32)', '是', 13, '建筑结构类型代码', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'lafsdm', 'character varying(32)', '是', 14, '立案方式代码', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'lasj', 'date', '否', 15, '立案时间', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'afdz', 'character varying(200)', '是', 16, '案发地址', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'ajlxdm', 'character varying(32)', '是', 17, '案件类型代码', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'gis_x', 'numeric(22,6)', '否', 18, 'gis_x', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'gis_y', 'numeric(22,6)', '否', 19, 'gis_y', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'ajdjdm', 'character varying(32)', '是', 20, '案件等级代码', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'czdxdm', 'character varying(32)', '是', 21, '处置对象代码', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'bcxx', 'character varying(400)', '是', 22, '补充信息', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'zysx', 'character varying(200)', '是', 23, '注意事项', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'qxxxms', 'character varying(400)', '是', 24, '气象信息描述', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'lfcs', 'integer', '否', 25, '楼房层数', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'jsmlsj', 'date', '否', 26, '接收命令时间', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'cdsj', 'date', '否', 27, '出动时间', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'ddxcsj', 'date', '否', 28, '到达现场时间', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'zdzksj', 'date', '否', 29, '战斗展开时间', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'dccssj', 'date', '否', 30, '到场出水时间', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'hskzsj', 'date', '否', 31, '火势控制时间', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'jbpmsj', 'date', '否', 32, '基本扑灭时间', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'gdsj', 'date', '否', 33, '归队时间', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'rslc', 'integer', '否', 34, '燃烧楼层', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'zdyrs', 'integer', '否', 35, '战斗员人数', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'ccrs', 'integer', '否', 36, '撤出人数', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'shusrs', 'integer', '否', 37, '疏散人数', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'jcrs', 'integer', '否', 38, '救出人数', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'qzswrs', 'integer', '否', 39, '群众死亡人数', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'bdswrs', 'integer', '否', 40, '部队死亡人数', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'zhyy', 'character varying(1000)', '是', 41, '灾害原因', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'ssrs', 'integer', '否', 42, '受伤人数', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'bdssrs', 'integer', '否', 43, '部队受伤人数', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'rsmj', 'integer', '否', 44, '燃烧面积', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'bhmj', 'integer', '否', 45, '保护面积', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'ccss', 'text', '是', 46, '财产损失', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'zzbh', 'character varying(32)', '是', 47, '作战编号', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'bz', 'character varying(400)', '是', 48, '备注', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'ajztdm', 'character varying(32)', '是', 49, '案件状态代码', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'ajxz', 'integer', '否', 50, '案件性质', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'hbzt', 'character varying(32)', '是', 51, '合并状态', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'zddwid', 'character varying(32)', '是', 52, '战斗单位id', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'rybks', 'character varying(20)', '是', 53, '人员被困数', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'jjyxm', 'character varying(32)', '是', 54, '接警员姓名', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'zhcs', 'text', '是', 55, '灾害场所', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'hzsj', 'date', '否', 56, '回执时间', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'xdsj', 'date', '否', 57, '下达时间', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'zjhm', 'character varying(25)', '是', 58, '证件号码', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'zjlx', 'character varying(10)', '是', 59, '证件类型', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'jssj', 'timestamp without time zone', '否', 60, '接收时间', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'cqdc_sjgxsj', 'timestamp without time zone', '否', 61, '数据更新时间', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfjq', 'cqdc_sjscbs', 'character(1)', '是', 62, '数据删除标识', '消防警情');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfmtxx', 'cqdc_uuid', 'character varying(32)', '是', 1, '唯一主键', '消防码头信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfmtxx', 'id', 'character varying(32)', '是', 2, 'id', '消防码头信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfmtxx', 'trsyid', 'character varying(32)', '是', 3, '天然水源id', '消防码头信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfmtxx', 'sybgc', 'numeric(22,6)', '否', 4, '水源标高差', '消防码头信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfmtxx', 'tcwz', 'character varying(100)', '是', 5, '停车位置', '消防码头信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfmtxx', 'tcsl', 'integer', '否', 6, '停车数量', '消防码头信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfmtxx', 'ssxfjgid', 'character varying(32)', '是', 7, '所属消防机构id', '消防码头信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfmtxx', 'sjbb', 'numeric(22,6)', '否', 8, '数据版本', '消防码头信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfmtxx', 'cjsj', 'date', '否', 9, '创建时间', '消防码头信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfmtxx', 'bjsj', 'date', '否', 10, '编辑时间', '消防码头信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfmtxx', 'ywxtbsid', 'character varying(32)', '是', 11, '业务系统部署id', '消防码头信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfmtxx', 'jlzt', 'character varying(1)', '是', 12, '记录状态', '消防码头信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfmtxx', 'sjc', 'date', '否', 13, '时间戳', '消防码头信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfmtxx', 'bz', 'character varying(401)', '是', 14, '备注', '消防码头信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfmtxx', 'cqdc_sjgxsj', 'timestamp without time zone', '否', 15, '数据更新时间', '消防码头信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfmtxx', 'cqdc_sjscbs', 'character(1)', '是', 16, '数据删除标识', '消防码头信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfscxx', 'cqdc_uuid', 'character varying(32)', '是', 1, '唯一主键', '消防水池信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfscxx', 'id', 'character varying(32)', '是', 2, 'id', '消防水池信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfscxx', 'sybgc', 'numeric(22,6)', '否', 3, '水源标高差', '消防水池信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfscxx', 'csl', 'numeric(22,6)', '否', 4, '储水量', '消防水池信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfscxx', 'jsll', 'numeric(22,6)', '否', 5, '进水流量', '消防水池信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfscxx', 'gwxs', 'character varying(8)', '是', 6, '管网形式', '消防水池信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfscxx', 'tcwz', 'character varying(100)', '是', 7, '停车位置', '消防水池信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfscxx', 'tcsl', 'integer', '否', 8, '停车数量', '消防水池信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfscxx', 'ssxfjgid', 'character varying(32)', '是', 9, '所属消防机构id', '消防水池信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfscxx', 'sjbb', 'numeric(22,6)', '否', 10, '数据版本', '消防水池信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfscxx', 'cjsj', 'date', '否', 11, '创建时间', '消防水池信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfscxx', 'bjsj', 'date', '否', 12, '编辑时间', '消防水池信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfscxx', 'ywxtbsid', 'character varying(32)', '是', 13, '业务系统部署id', '消防水池信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfscxx', 'jlzt', 'character varying(1)', '是', 14, '记录状态', '消防水池信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfscxx', 'sjc', 'date', '否', 15, '时间戳', '消防水池信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfscxx', 'bz', 'character varying(400)', '是', 16, '备注', '消防水池信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfscxx', 'cqdc_sjgxsj', 'timestamp without time zone', '否', 17, '数据更新时间', '消防水池信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfscxx', 'cqdc_sjscbs', 'character(1)', '是', 18, '数据删除标识', '消防水池信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfsyjbxx', 'cqdc_uuid', 'character varying(32)', '是', 1, '唯一主键', '消防水源基本信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfsyjbxx', 'id', 'character varying(32)', '是', 2, 'id', '消防水源基本信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfsyjbxx', 'sybh', 'character varying(20)', '是', 3, '水源编号', '消防水源基本信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfsyjbxx', 'sydz', 'character varying(100)', '是', 4, '水源地址', '消防水源基本信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfsyjbxx', 'sylxsylx', 'character varying(8)', '是', 5, '水源类型#sylx', '消防水源基本信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfsyjbxx', 'sysxxxid', 'character varying(32)', '是', 6, '水源属性信息id', '消防水源基本信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfsyjbxx', 'ssxfjgid', 'character varying(32)', '是', 7, '所属消防机构id', '消防水源基本信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfsyjbxx', 'qsxs', 'character varying(50)', '是', 8, '取水形式', '消防水源基本信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfsyjbxx', 'kyztsykyzt', 'character varying(8)', '是', 9, '可用状态#sykyzt', '消防水源基本信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfsyjbxx', 'syztsyzt', 'character varying(8)', '是', 10, '水源状态#syzt', '消防水源基本信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfsyjbxx', 'xzsylx', 'character varying(8)', '是', 11, '性质#sylx', '消防水源基本信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfsyjbxx', 'czyid', 'character varying(32)', '是', 12, '操作员id', '消防水源基本信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfsyjbxx', 'shztsyshzt', 'character varying(8)', '是', 13, '审核状态#syshzt', '消防水源基本信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfsyjbxx', 'zpslt', 'character varying(100)', '是', 14, '照片缩略图', '消防水源基本信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfsyjbxx', 'zpwjurl', 'character varying(200)', '是', 15, '照片文件url', '消防水源基本信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfsyjbxx', 'gis_x', 'numeric(22,6)', '否', 16, 'gis_x', '消防水源基本信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfsyjbxx', 'gis_y', 'numeric(22,6)', '否', 17, 'gis_y', '消防水源基本信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfsyjbxx', 'gis_h', 'numeric(22,6)', '否', 18, 'gis_h', '消防水源基本信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfsyjbxx', 'gisglid', 'character varying(32)', '是', 19, 'gis关联id <', '消防水源基本信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfsyjbxx', 'ssldid', 'character varying(32)', '是', 20, '所属路段id', '消防水源基本信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfsyjbxx', 'jzsj', 'date', '否', 21, '建造时间', '消防水源基本信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfsyjbxx', 'qysj', 'date', '否', 22, '启用时间', '消防水源基本信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfsyjbxx', 'fwtd_url', 'character varying(200)', '是', 23, '方位图东(url)', '消防水源基本信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfsyjbxx', 'fwtn_url', 'character varying(200)', '是', 24, '方位图南(url)', '消防水源基本信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfsyjbxx', 'fwtx_url', 'character varying(200)', '是', 25, '方位图西(url)', '消防水源基本信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfsyjbxx', 'fwtb_url', 'character varying(200)', '是', 26, '方位图北(url)', '消防水源基本信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfsyjbxx', 'plgx_d', 'character varying(200)', '是', 27, '毗邻关系(东)', '消防水源基本信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfsyjbxx', 'plgx_n', 'character varying(200)', '是', 28, '毗邻关系(南)', '消防水源基本信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfsyjbxx', 'plgx_x', 'character varying(200)', '是', 29, '毗邻关系(西)', '消防水源基本信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfsyjbxx', 'plgx_b', 'character varying(200)', '是', 30, '毗邻关系(北)', '消防水源基本信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfsyjbxx', 'sjbb', 'numeric(22,6)', '否', 31, '数据版本', '消防水源基本信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfsyjbxx', 'cjsj', 'date', '否', 32, '创建时间', '消防水源基本信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfsyjbxx', 'bjsj', 'date', '否', 33, '编辑时间', '消防水源基本信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfsyjbxx', 'ywxtbsid', 'character varying(32)', '是', 34, '业务系统部署id', '消防水源基本信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfsyjbxx', 'jlzt', 'character varying(1)', '是', 35, '记录状态', '消防水源基本信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfsyjbxx', 'sjc', 'date', '否', 36, '时间戳', '消防水源基本信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfsyjbxx', 'bz', 'character varying(400)', '是', 37, '备注', '消防水源基本信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfsyjbxx', 'symc', 'character varying(100)', '是', 38, '水源名称', '消防水源基本信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfsyjbxx', 'cqdc_sjgxsj', 'timestamp without time zone', '否', 39, '数据更新时间', '消防水源基本信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xfsyjbxx', 'cqdc_sjscbs', 'character(1)', '是', 40, '数据删除标识', '消防水源基本信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xhsxx', 'cqdc_uuid', 'character varying(32)', '是', 1, '唯一主键', '消火栓信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xhsxx', 'id', 'character varying(32)', '是', 2, 'id', '消火栓信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xhsxx', 'ssgw', 'character varying(32)', '是', 3, '所属管网', '消火栓信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xhsxx', 'szxs', 'character varying(7)', '是', 4, '设置形式', '消火栓信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xhsxx', 'gsdw', 'character varying(100)', '是', 5, '供水单位', '消火栓信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xhsxx', 'lxfs', 'character varying(30)', '是', 6, '联系方式', '消火栓信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xhsxx', 'gwxs', 'character varying(8)', '是', 7, '管网形式', '消火栓信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xhsxx', 'gwzj', 'numeric(22,6)', '否', 8, '管网直径', '消火栓信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xhsxx', 'gwyl', 'numeric(22,6)', '否', 9, '管网压力', '消火栓信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xhsxx', 'jkxs', 'character varying(8)', '是', 10, '接口形式', '消火栓信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xhsxx', 'll', 'numeric(22,6)', '否', 11, '流量', '消火栓信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xhsxx', 'ssxfjgid', 'character varying(32)', '是', 12, '所属消防机构id', '消火栓信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xhsxx', 'sjbb', 'numeric(22,6)', '否', 13, '数据版本', '消火栓信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xhsxx', 'cjsj', 'date', '否', 14, '创建时间', '消火栓信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xhsxx', 'bjsj', 'date', '否', 15, '编辑时间', '消火栓信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xhsxx', 'ywxtbsid', 'character varying(32)', '是', 16, '业务系统部署id', '消火栓信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xhsxx', 'jlzt', 'character varying(1)', '是', 17, '记录状态', '消火栓信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xhsxx', 'sjc', 'date', '否', 18, '时间戳', '消火栓信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xhsxx', 'bz', 'character varying(400)', '是', 19, '备注', '消火栓信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xhsxx', 'tyshxydm', 'character varying(18)', '是', 20, '统一社会信用代码', '消火栓信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xhsxx', 'cqdc_sjgxsj', 'timestamp without time zone', '否', 21, '数据更新时间', '消火栓信息');
    INSERT INTO `cqsxfjyzd`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('xhsxx', 'cqdc_sjscbs', 'character(1)', '是', 22, '数据删除标识', '消火栓信息');
    
    
    1. bmk_second.cqtlbsc
    CREATE TABLE `cqtlbsc` (
      `table_name` varchar(255) DEFAULT NULL,
      `field` varchar(255) DEFAULT NULL,
      `field_type` varchar(255) DEFAULT NULL,
      `is_string` varchar(255) DEFAULT NULL,
      `field_number` int(255) DEFAULT NULL,
      `field_comment` varchar(255) DEFAULT NULL,
      `table_comment` varchar(255) DEFAULT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
    
    
    INSERT INTO `cqtlbsc`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('cwztgcpccd', 'cqdc_uuid', 'character varying(32)', '是', 1, '唯一主键', '持伪造、涂改车票乘车的');
    INSERT INTO `cqtlbsc`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('cwztgcpccd', 'jdswh', 'character varying(128)', '是', 2, '决定书文号', '持伪造、涂改车票乘车的');
    INSERT INTO `cqtlbsc`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('cwztgcpccd', 'sxmc', 'character varying(256)', '是', 3, '事项名称', '持伪造、涂改车票乘车的');
    INSERT INTO `cqtlbsc`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('cwztgcpccd', 'sxlb', 'character varying(64)', '是', 4, '事项类别', '持伪造、涂改车票乘车的');
    INSERT INTO `cqtlbsc`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('cwztgcpccd', 'sxnr', 'text', '是', 5, '事项内容', '持伪造、涂改车票乘车的');
    INSERT INTO `cqtlbsc`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('cwztgcpccd', 'xzxdrmc', 'character varying(256)', '是', 6, '行政相对人名称', '持伪造、涂改车票乘车的');
    INSERT INTO `cqtlbsc`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('cwztgcpccd', 'xzxdrdm1tyshxydm', 'character varying(64)', '是', 7, '行政相对人代码_1(统一社会信用代码)', '持伪造、涂改车票乘车的');
    INSERT INTO `cqtlbsc`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('cwztgcpccd', 'xzxdrdm2zzjgdm', 'character varying(64)', '是', 8, '行政相对人代码_2(组织机构代码)', '持伪造、涂改车票乘车的');
    INSERT INTO `cqtlbsc`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('cwztgcpccd', 'xzxdrdm3gsdjm', 'character varying(64)', '是', 9, '行政相对人代码_3(工商登记码)', '持伪造、涂改车票乘车的');
    INSERT INTO `cqtlbsc`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('cwztgcpccd', 'xzxdrdm4swdjh', 'character varying(64)', '是', 10, '行政相对人代码_4(税务登记号)', '持伪造、涂改车票乘车的');
    INSERT INTO `cqtlbsc`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('cwztgcpccd', 'xzxdrdm5jmsfzh', 'character varying(64)', '是', 11, '行政相对人代码_5(居民身份证号)', '持伪造、涂改车票乘车的');
    INSERT INTO `cqtlbsc`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('cwztgcpccd', 'fddbrxm', 'character varying(256)', '是', 12, '法定代表人姓名', '持伪造、涂改车票乘车的');
    INSERT INTO `cqtlbsc`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('cwztgcpccd', 'jdrq', 'date', '否', 13, '决定日期', '持伪造、涂改车票乘车的');
    INSERT INTO `cqtlbsc`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('cwztgcpccd', 'jzq', 'date', '否', 14, '截止期', '持伪造、涂改车票乘车的');
    INSERT INTO `cqtlbsc`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('cwztgcpccd', 'ssjg', 'character varying(64)', '是', 15, '所属机关', '持伪造、涂改车票乘车的');
    INSERT INTO `cqtlbsc`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('cwztgcpccd', 'dqzt', 'character varying(1)', '是', 16, '当前状态', '持伪造、涂改车票乘车的');
    INSERT INTO `cqtlbsc`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('cwztgcpccd', 'dfbm', 'character varying(6)', '是', 17, '地方编码', '持伪造、涂改车票乘车的');
    INSERT INTO `cqtlbsc`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('cwztgcpccd', 'sjgxsjc', 'date', '否', 18, '数据更新时间戳', '持伪造、涂改车票乘车的');
    INSERT INTO `cqtlbsc`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('cwztgcpccd', 'bz', 'character varying(512)', '是', 19, '备注', '持伪造、涂改车票乘车的');
    INSERT INTO `cqtlbsc`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('cwztgcpccd', 'cqdc_sjgxsj', 'timestamp without time zone', '否', 20, '数据更新时间', '持伪造、涂改车票乘车的');
    INSERT INTO `cqtlbsc`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('cwztgcpccd', 'cqdc_sjscbs', 'character(1)', '是', 21, '数据删除标识', '持伪造、涂改车票乘车的');
    INSERT INTO `cqtlbsc`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('jyxszcjjrzdgmxpzgmdcpbccd', 'cqdc_uuid', 'character varying(32)', '是', 1, '唯一主键', '借用、冒用、伪造、涂改的学生证、残疾军人证、伤残人民警察证、残疾人证等购买须凭证购买的车票并乘车的');
    INSERT INTO `cqtlbsc`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('jyxszcjjrzdgmxpzgmdcpbccd', 'jdswh', 'character varying(128)', '是', 2, '决定书文号', '借用、冒用、伪造、涂改的学生证、残疾军人证、伤残人民警察证、残疾人证等购买须凭证购买的车票并乘车的');
    INSERT INTO `cqtlbsc`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('jyxszcjjrzdgmxpzgmdcpbccd', 'sxmc', 'character varying(256)', '是', 3, '事项名称', '借用、冒用、伪造、涂改的学生证、残疾军人证、伤残人民警察证、残疾人证等购买须凭证购买的车票并乘车的');
    INSERT INTO `cqtlbsc`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('jyxszcjjrzdgmxpzgmdcpbccd', 'sxlb', 'character varying(64)', '是', 4, '事项类别', '借用、冒用、伪造、涂改的学生证、残疾军人证、伤残人民警察证、残疾人证等购买须凭证购买的车票并乘车的');
    INSERT INTO `cqtlbsc`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('jyxszcjjrzdgmxpzgmdcpbccd', 'sxnr', 'text', '是', 5, '事项内容', '借用、冒用、伪造、涂改的学生证、残疾军人证、伤残人民警察证、残疾人证等购买须凭证购买的车票并乘车的');
    INSERT INTO `cqtlbsc`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('jyxszcjjrzdgmxpzgmdcpbccd', 'xzxdrmc', 'character varying(256)', '是', 6, '行政相对人名称', '借用、冒用、伪造、涂改的学生证、残疾军人证、伤残人民警察证、残疾人证等购买须凭证购买的车票并乘车的');
    INSERT INTO `cqtlbsc`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('jyxszcjjrzdgmxpzgmdcpbccd', 'xzxdrdm1tyshxydm', 'character varying(64)', '是', 7, '行政相对人代码_1(统一社会信用代码)', '借用、冒用、伪造、涂改的学生证、残疾军人证、伤残人民警察证、残疾人证等购买须凭证购买的车票并乘车的');
    INSERT INTO `cqtlbsc`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('jyxszcjjrzdgmxpzgmdcpbccd', 'xzxdrdm2zzjgdm', 'character varying(64)', '是', 8, '行政相对人代码_2(组织机构代码)', '借用、冒用、伪造、涂改的学生证、残疾军人证、伤残人民警察证、残疾人证等购买须凭证购买的车票并乘车的');
    INSERT INTO `cqtlbsc`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('jyxszcjjrzdgmxpzgmdcpbccd', 'xzxdrdm3gsdjm', 'character varying(64)', '是', 9, '行政相对人代码_3(工商登记码)', '借用、冒用、伪造、涂改的学生证、残疾军人证、伤残人民警察证、残疾人证等购买须凭证购买的车票并乘车的');
    INSERT INTO `cqtlbsc`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('jyxszcjjrzdgmxpzgmdcpbccd', 'xzxdrdm4swdjh', 'character varying(64)', '是', 10, '行政相对人代码_4(税务登记号)', '借用、冒用、伪造、涂改的学生证、残疾军人证、伤残人民警察证、残疾人证等购买须凭证购买的车票并乘车的');
    INSERT INTO `cqtlbsc`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('jyxszcjjrzdgmxpzgmdcpbccd', 'xzxdrdm5jmsfzh', 'character varying(64)', '是', 11, '行政相对人代码_5(居民身份证号)', '借用、冒用、伪造、涂改的学生证、残疾军人证、伤残人民警察证、残疾人证等购买须凭证购买的车票并乘车的');
    INSERT INTO `cqtlbsc`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('jyxszcjjrzdgmxpzgmdcpbccd', 'fddbrxm', 'character varying(256)', '是', 12, '法定代表人姓名', '借用、冒用、伪造、涂改的学生证、残疾军人证、伤残人民警察证、残疾人证等购买须凭证购买的车票并乘车的');
    INSERT INTO `cqtlbsc`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('jyxszcjjrzdgmxpzgmdcpbccd', 'jdrq', 'date', '否', 13, '决定日期', '借用、冒用、伪造、涂改的学生证、残疾军人证、伤残人民警察证、残疾人证等购买须凭证购买的车票并乘车的');
    INSERT INTO `cqtlbsc`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('jyxszcjjrzdgmxpzgmdcpbccd', 'jzq', 'date', '否', 14, '截止期', '借用、冒用、伪造、涂改的学生证、残疾军人证、伤残人民警察证、残疾人证等购买须凭证购买的车票并乘车的');
    INSERT INTO `cqtlbsc`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('jyxszcjjrzdgmxpzgmdcpbccd', 'ssjg', 'character varying(64)', '是', 15, '所属机关', '借用、冒用、伪造、涂改的学生证、残疾军人证、伤残人民警察证、残疾人证等购买须凭证购买的车票并乘车的');
    INSERT INTO `cqtlbsc`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('jyxszcjjrzdgmxpzgmdcpbccd', 'dqzt', 'character varying(1)', '是', 16, '当前状态', '借用、冒用、伪造、涂改的学生证、残疾军人证、伤残人民警察证、残疾人证等购买须凭证购买的车票并乘车的');
    INSERT INTO `cqtlbsc`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('jyxszcjjrzdgmxpzgmdcpbccd', 'dfbm', 'character varying(6)', '是', 17, '地方编码', '借用、冒用、伪造、涂改的学生证、残疾军人证、伤残人民警察证、残疾人证等购买须凭证购买的车票并乘车的');
    INSERT INTO `cqtlbsc`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('jyxszcjjrzdgmxpzgmdcpbccd', 'sjgxsjc', 'date', '否', 18, '数据更新时间戳', '借用、冒用、伪造、涂改的学生证、残疾军人证、伤残人民警察证、残疾人证等购买须凭证购买的车票并乘车的');
    INSERT INTO `cqtlbsc`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('jyxszcjjrzdgmxpzgmdcpbccd', 'bz', 'character varying(512)', '是', 19, '备注', '借用、冒用、伪造、涂改的学生证、残疾军人证、伤残人民警察证、残疾人证等购买须凭证购买的车票并乘车的');
    INSERT INTO `cqtlbsc`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('jyxszcjjrzdgmxpzgmdcpbccd', 'cqdc_sjgxsj', 'timestamp without time zone', '否', 20, '数据更新时间', '借用、冒用、伪造、涂改的学生证、残疾军人证、伤残人民警察证、残疾人证等购买须凭证购买的车票并乘车的');
    INSERT INTO `cqtlbsc`(`table_name`, `field`, `field_type`, `is_string`, `field_number`, `field_comment`, `table_comment`) VALUES ('jyxszcjjrzdgmxpzgmdcpbccd', 'cqdc_sjscbs', 'character(1)', '是', 21, '数据删除标识', '借用、冒用、伪造、涂改的学生证、残疾军人证、伤残人民警察证、残疾人证等购买须凭证购买的车票并乘车的');
    
    

    相关文章

      网友评论

          本文标题:基于TBDS的数据迁移(postgreSQL到hive)第一部分

          本文链接:https://www.haomeiwen.com/subject/tnelektx.html