/*
 Navicat Premium Data Transfer

 Source Server         : mysql
 Source Server Type    : MySQL
 Source Server Version : 50718
 Source Host           : 127.0.0.1
 Source Schema         : rygl

 Target Server Type    : MySQL
 Target Server Version : 50718
 File Encoding         : 65001

 Date: 13/05/2022 15:12:54
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for a_child
-- ----------------------------
DROP TABLE IF EXISTS `a_child`;
CREATE TABLE `a_child`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pid` int(11) NULL DEFAULT NULL COMMENT '妇女表id',
  `syznxm` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `sflset` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `cydsznz` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `dsznzh` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `dbflqqk` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `zcsx` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `lqrq` date NULL DEFAULT NULL,
  `bz` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `bscid` int(11) NOT NULL,
  `sqid` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `pid`(`pid`) USING BTREE,
  INDEX `cydsznz`(`cydsznz`(191)) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of a_child
-- ----------------------------

-- ----------------------------
-- Table structure for a_cjrgl
-- ----------------------------
DROP TABLE IF EXISTS `a_cjrgl`;
CREATE TABLE `a_cjrgl`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `sfzh` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `bscid` int(11) NOT NULL,
  `sqid` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `cjlx` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `cjdj` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `cjzh` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `cjzlqsj` date NULL DEFAULT NULL,
  `sfxydb` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `jhr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `lxfs` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `bz` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `sfjd` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `a_cjrgl_sfzh_index`(`sfzh`) USING BTREE,
  INDEX `a_cjrgl_bscid_index`(`bscid`) USING BTREE,
  INDEX `a_cjrgl_sqid_index`(`sqid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of a_cjrgl
-- ----------------------------

-- ----------------------------
-- Table structure for a_dbrygl
-- ----------------------------
DROP TABLE IF EXISTS `a_dbrygl`;
CREATE TABLE `a_dbrygl`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `sfzh` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `bscid` int(11) NOT NULL,
  `sqid` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `sqdbyy` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `a_dbrygl_sfzh_index`(`sfzh`) USING BTREE,
  INDEX `a_dbrygl_bscid_index`(`bscid`) USING BTREE,
  INDEX `a_dbrygl_sqid_index`(`sqid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of a_dbrygl
-- ----------------------------

-- ----------------------------
-- Table structure for a_dyxxgl
-- ----------------------------
DROP TABLE IF EXISTS `a_dyxxgl`;
CREATE TABLE `a_dyxxgl`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `sfzh` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `bscid` int(11) NOT NULL,
  `sqid` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `rdrq` date NULL DEFAULT NULL,
  `dzzgxszd` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `cjzyzhdqk` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `bz` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `dyqk` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `sfcjzzsh` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `a_dyxxgl_sfzh_index`(`sfzh`) USING BTREE,
  INDEX `a_dyxxgl_bscid_index`(`bscid`) USING BTREE,
  INDEX `a_dyxxgl_sqid_index`(`sqid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of a_dyxxgl
-- ----------------------------

-- ----------------------------
-- Table structure for a_fdxx
-- ----------------------------
DROP TABLE IF EXISTS `a_fdxx`;
CREATE TABLE `a_fdxx`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `sfzh` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `bscid` int(11) NOT NULL,
  `sqid` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `fzxm` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `fzxb` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `mz` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `jg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `hjdz` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `sjzz` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `sfzh6` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `lxdh` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `hh` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `a_fdxx_sfzh_index`(`sfzh`) USING BTREE,
  INDEX `a_fdxx_bscid_index`(`bscid`) USING BTREE,
  INDEX `a_fdxx_sqid_index`(`sqid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of a_fdxx
-- ----------------------------

-- ----------------------------
-- Table structure for a_hybd
-- ----------------------------
DROP TABLE IF EXISTS `a_hybd`;
CREATE TABLE `a_hybd`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `sfzh` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `bscid` int(11) NOT NULL,
  `sqid` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `bdsj` date NULL DEFAULT NULL,
  `bdlx` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `bdsm` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `a_hybd_sfzh_index`(`sfzh`) USING BTREE,
  INDEX `a_hybd_bscid_index`(`bscid`) USING BTREE,
  INDEX `a_hybd_sqid_index`(`sqid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of a_hybd
-- ----------------------------

-- ----------------------------
-- Table structure for a_jmshbx
-- ----------------------------
DROP TABLE IF EXISTS `a_jmshbx`;
CREATE TABLE `a_jmshbx`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `sfzh` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `bscid` int(11) NOT NULL,
  `sqid` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `ybfyjnszd` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `ybjnqk` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `ylbxjjnszd` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `ylbxjjnqk` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `yblx` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `yllx` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `a_jmshbx_sfzh_index`(`sfzh`) USING BTREE,
  INDEX `a_jmshbx_bscid_index`(`bscid`) USING BTREE,
  INDEX `a_jmshbx_sqid_index`(`sqid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of a_jmshbx
-- ----------------------------

-- ----------------------------
-- Table structure for a_jmxxgl
-- ----------------------------
DROP TABLE IF EXISTS `a_jmxxgl`;
CREATE TABLE `a_jmxxgl`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `sfzh` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `bscid` int(11) NOT NULL,
  `sqid` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `hh` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `yhzgx` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `xm` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `xb` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `mz` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `csrq` date NULL DEFAULT NULL,
  `whcd` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `yhtc` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `xx` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `zzmm` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `hyzk` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `jhrq` date NULL DEFAULT NULL,
  `cyzk` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `gzdw` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `hjszd` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `hb` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `jzxz` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `jtzz` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `cxdrrddbzxwyjqtshzz` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `zyfw` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `jtkncd` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `sfdy` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `sfyln` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `sfcj` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `xsdb` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `sfglry` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `jmshbx` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `sfyfdx` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `jwtlry` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `sffy` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `jyss` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `sfxj` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `sfzdgz` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `lxfs` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `bz` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `shjz` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `jzlx` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `fdxm` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `fddh` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `fdsfzh` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `lrsj` date NULL DEFAULT NULL,
  `lcsj` date NULL DEFAULT NULL,
  `gtgsh` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `cslx` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `spaqyh` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `gnlx` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `yycl` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `zfxz` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `yhzc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `hybd` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `zb` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `wgy` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `zjr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `hnum` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `a_jmxxgl_sfzh_index`(`sfzh`) USING BTREE,
  INDEX `a_jmxxgl_bscid_index`(`bscid`) USING BTREE,
  INDEX `a_jmxxgl_sqid_index`(`sqid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of a_jmxxgl
-- ----------------------------

-- ----------------------------
-- Table structure for a_jwrygl
-- ----------------------------
DROP TABLE IF EXISTS `a_jwrygl`;
CREATE TABLE `a_jwrygl`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `sfzh` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `bscid` int(11) NOT NULL,
  `sqid` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `zwxm` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `wwxm` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `xb` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `csrq` date NULL DEFAULT NULL,
  `gj` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `lxfs` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `qzzl` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `qzhm` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `qzyxq` date NULL DEFAULT NULL,
  `qzjg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `rylx` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `rjrq` date NULL DEFAULT NULL,
  `gzjg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `tlsy` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `nlrq` date NULL DEFAULT NULL,
  `gnyqr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `lxfs16` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `a_jwrygl_bscid_index`(`bscid`) USING BTREE,
  INDEX `a_jwrygl_sqid_index`(`sqid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of a_jwrygl
-- ----------------------------

-- ----------------------------
-- Table structure for a_jyssgl
-- ----------------------------
DROP TABLE IF EXISTS `a_jyssgl`;
CREATE TABLE `a_jyssgl`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `sfzh` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `bscid` int(11) NOT NULL,
  `sqid` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `jyss` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `a_jyssgl_sfzh_index`(`sfzh`) USING BTREE,
  INDEX `a_jyssgl_bscid_index`(`bscid`) USING BTREE,
  INDEX `a_jyssgl_sqid_index`(`sqid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of a_jyssgl
-- ----------------------------

-- ----------------------------
-- Table structure for a_llxxgl
-- ----------------------------
DROP TABLE IF EXISTS `a_llxxgl`;
CREATE TABLE `a_llxxgl`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `sfzh` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `bscid` int(11) NOT NULL,
  `sqid` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `sfkclr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `snzt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `glbtlqqk` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `jgsydwqyyljlqqk` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `syr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `lxfs` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `bz` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `a_llxxgl_sfzh_index`(`sfzh`) USING BTREE,
  INDEX `a_llxxgl_bscid_index`(`bscid`) USING BTREE,
  INDEX `a_llxxgl_sqid_index`(`sqid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of a_llxxgl
-- ----------------------------

-- ----------------------------
-- Table structure for a_qtdpgl
-- ----------------------------
DROP TABLE IF EXISTS `a_qtdpgl`;
CREATE TABLE `a_qtdpgl`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `sfzh` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `bscid` int(11) NOT NULL,
  `sqid` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `hzdp` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `a_qtdpgl_sfzh_index`(`sfzh`) USING BTREE,
  INDEX `a_qtdpgl_bscid_index`(`bscid`) USING BTREE,
  INDEX `a_qtdpgl_sqid_index`(`sqid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of a_qtdpgl
-- ----------------------------

-- ----------------------------
-- Table structure for a_shjl
-- ----------------------------
DROP TABLE IF EXISTS `a_shjl`;
CREATE TABLE `a_shjl`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `sfzh` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `bscid` int(11) NOT NULL,
  `sqid` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `xydbrs` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `dbsqyy` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `lqjzje` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `xymbqk` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `jtnsr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `bz` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `a_shjl_sfzh_index`(`sfzh`) USING BTREE,
  INDEX `a_shjl_bscid_index`(`bscid`) USING BTREE,
  INDEX `a_shjl_sqid_index`(`sqid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of a_shjl
-- ----------------------------

-- ----------------------------
-- Table structure for a_wfxxgl
-- ----------------------------
DROP TABLE IF EXISTS `a_wfxxgl`;
CREATE TABLE `a_wfxxgl`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `sfzh` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `bscid` int(11) NOT NULL,
  `sqid` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `wfqk` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `fzyy` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `wxbz` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `a_wfxxgl_sfzh_index`(`sfzh`) USING BTREE,
  INDEX `a_wfxxgl_bscid_index`(`bscid`) USING BTREE,
  INDEX `a_wfxxgl_sqid_index`(`sqid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of a_wfxxgl
-- ----------------------------

-- ----------------------------
-- Table structure for a_xjrygl
-- ----------------------------
DROP TABLE IF EXISTS `a_xjrygl`;
CREATE TABLE `a_xjrygl`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `sfzh` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `bscid` int(11) NOT NULL,
  `sqid` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `zzmc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `a_xjrygl_sfzh_index`(`sfzh`) USING BTREE,
  INDEX `a_xjrygl_bscid_index`(`bscid`) USING BTREE,
  INDEX `a_xjrygl_sqid_index`(`sqid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of a_xjrygl
-- ----------------------------

-- ----------------------------
-- Table structure for a_xqqygl
-- ----------------------------
DROP TABLE IF EXISTS `a_xqqygl`;
CREATE TABLE `a_xqqygl`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `bscid` int(11) NOT NULL,
  `sqid` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `gsmc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `fr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `gsdz` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `lxfs` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `a_xqqygl_bscid_index`(`bscid`) USING BTREE,
  INDEX `a_xqqygl_sqid_index`(`sqid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of a_xqqygl
-- ----------------------------

-- ----------------------------
-- Table structure for a_xtygl
-- ----------------------------
DROP TABLE IF EXISTS `a_xtygl`;
CREATE TABLE `a_xtygl`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `sfzh` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `bscid` int(11) NOT NULL,
  `sqid` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `fyzt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `rwrq` date NULL DEFAULT NULL,
  `tyrq` date NULL DEFAULT NULL,
  `jz` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `fyd` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `tyd` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `qsxm` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `lgqk` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `cjmbzz` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `nl` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `bz` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `a_xtygl_sfzh_index`(`sfzh`) USING BTREE,
  INDEX `a_xtygl_bscid_index`(`bscid`) USING BTREE,
  INDEX `a_xtygl_sqid_index`(`sqid`) USING BTREE,
  INDEX `fyzt`(`fyzt`(191)) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of a_xtygl
-- ----------------------------

-- ----------------------------
-- Table structure for a_yfdxgl
-- ----------------------------
DROP TABLE IF EXISTS `a_yfdxgl`;
CREATE TABLE `a_yfdxgl`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `sfzh` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `bscid` int(11) NOT NULL,
  `sqid` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `lxfs` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `yfjbqk` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `bz` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `a_yfdxgl_sfzh_index`(`sfzh`) USING BTREE,
  INDEX `a_yfdxgl_bscid_index`(`bscid`) USING BTREE,
  INDEX `a_yfdxgl_sqid_index`(`sqid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of a_yfdxgl
-- ----------------------------

-- ----------------------------
-- Table structure for a_yhzc
-- ----------------------------
DROP TABLE IF EXISTS `a_yhzc`;
CREATE TABLE `a_yhzc`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `sfzh` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `bscid` int(11) NOT NULL,
  `sqid` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `zclx` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `bzje` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `bzsmxx` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `a_yhzc_sfzh_index`(`sfzh`) USING BTREE,
  INDEX `a_yhzc_bscid_index`(`bscid`) USING BTREE,
  INDEX `a_yhzc_sqid_index`(`sqid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of a_yhzc
-- ----------------------------

-- ----------------------------
-- Table structure for a_ylfngl
-- ----------------------------
DROP TABLE IF EXISTS `a_ylfngl`;
CREATE TABLE `a_ylfngl`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `sfzh` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `bscid` int(11) NOT NULL,
  `sqid` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `chrq` date NULL DEFAULT NULL,
  `sfsdjt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `syznxm` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `sflset` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `cydsznz` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `dsznzh` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `dbflqqk` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `zcsx` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `byzt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `hyzk` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `bz` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `lqrq` date NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `a_ylfngl_sfzh_index`(`sfzh`) USING BTREE,
  INDEX `a_ylfngl_bscid_index`(`bscid`) USING BTREE,
  INDEX `a_ylfngl_sqid_index`(`sqid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of a_ylfngl
-- ----------------------------

-- ----------------------------
-- Table structure for a_zdgzgl
-- ----------------------------
DROP TABLE IF EXISTS `a_zdgzgl`;
CREATE TABLE `a_zdgzgl`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `sfzh` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `bscid` int(11) NOT NULL,
  `sqid` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `gzyy` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `bz` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `a_zdgzgl_sfzh_index`(`sfzh`) USING BTREE,
  INDEX `a_zdgzgl_bscid_index`(`bscid`) USING BTREE,
  INDEX `a_zdgzgl_sqid_index`(`sqid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of a_zdgzgl
-- ----------------------------

-- ----------------------------
-- Table structure for autofields
-- ----------------------------
DROP TABLE IF EXISTS `autofields`;
CREATE TABLE `autofields`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `aid` int(11) NULL DEFAULT NULL COMMENT '上级id',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文字',
  `field` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '字段',
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '类型，input,radio,select,checkbox,date,textarea',
  `check` int(1) NULL DEFAULT NULL COMMENT '0-不显示，1-显示',
  `values` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '选项值',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `showarea` int(1) NULL DEFAULT NULL COMMENT '0-不显示，1-显示',
  `default` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '默认选中',
  `require` int(1) NULL DEFAULT 0 COMMENT '0-非必填，1-必填',
  `head` int(1) NULL DEFAULT 0 COMMENT '0-非表头，1-显示在表头',
  `relation` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '关联表',
  `width` int(10) NULL DEFAULT 150 COMMENT '文字宽度',
  `bscid` int(11) NULL DEFAULT 0 COMMENT '办事处id',
  `showorder` int(10) NULL DEFAULT 0 COMMENT '显示顺序',
  `base` int(1) NULL DEFAULT 0 COMMENT '0-非基础，1-基础信息',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 769 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of autofields
-- ----------------------------
INSERT INTO `autofields` VALUES (1, 1, '户号', 'hh', 'input', 1, NULL, '2019-10-18 18:06:47', '2019-10-18 18:06:47', 0, NULL, 1, 0, NULL, 150, 0, 190, 1);
INSERT INTO `autofields` VALUES (2, 1, '与户主关系', 'yhzgx', 'select', 1, '户主，配偶，父亲，母亲，儿子，女儿，其它', '2019-10-18 18:06:47', '2019-10-18 18:06:47', 1, '户主', 1, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (3, 1, '姓名', 'xm', 'input', 1, NULL, '2019-10-18 18:06:47', '2019-10-18 18:06:47', 0, NULL, 1, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (4, 1, '性别', 'xb', 'radio', 1, '男，女', '2019-10-18 18:06:47', '2019-10-18 18:06:47', 1, '男', 1, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (5, 1, '民族', 'mz', 'input', 1, NULL, '2019-10-18 18:06:47', '2019-10-18 18:06:47', 0, NULL, 1, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (6, 1, '出生日期', 'csrq', 'date', 1, NULL, '2019-10-18 18:06:47', '2019-10-18 18:06:47', 0, NULL, 1, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (7, 1, '身份证号', 'sfzh', 'input', 1, NULL, '2019-10-18 18:06:48', '2019-10-18 18:06:48', 0, NULL, 1, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (8, 1, '文化程度', 'whcd', 'select', 1, '小学，初中，高中，专科，本科，研究生，其它', '2019-10-18 18:06:48', '2019-10-18 18:06:48', 1, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (9, 1, '有何特长', 'yhtc', 'textarea', 1, NULL, '2019-10-18 18:06:48', '2019-10-18 18:06:48', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (10, 1, '血型', 'xx', 'select', 1, 'A，B，AB，O', '2019-10-18 18:06:48', '2019-10-18 18:06:48', 1, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (11, 1, '政治面貌', 'zzmm', 'select', 1, '党员，团员，群众，其它民主党派', '2019-10-18 18:06:48', '2019-10-18 18:06:48', 1, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (12, 1, '婚姻状况', 'hyzk', 'select', 1, '初婚，未婚，再婚，离异，丧偶，其它', '2019-10-18 18:06:48', '2019-10-18 18:06:48', 1, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (13, 1, '结婚日期', 'jhrq', 'date', 1, NULL, '2019-10-18 18:06:48', '2019-10-18 18:06:48', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (14, 1, '从业状况', 'cyzk', 'select', 1, '就业，待业，退休，其它', '2019-10-18 18:06:48', '2019-10-18 18:06:48', 1, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (15, 1, '工作单位', 'gzdw', 'input', 1, NULL, '2019-10-18 18:06:48', '2019-10-18 18:06:48', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (16, 1, '户籍地址', 'hjszd', 'input', 1, NULL, '2019-10-18 18:06:48', '2019-10-18 18:06:48', 0, NULL, 0, 0, NULL, 150, 0, 70, 1);
INSERT INTO `autofields` VALUES (17, 1, '户口性质', 'hb', 'select', 1, '农业，非农，集体', '2019-10-18 18:06:48', '2019-10-18 18:06:48', 1, NULL, 0, 0, NULL, 150, 0, 170, 1);
INSERT INTO `autofields` VALUES (18, 1, '住户类型', 'jzxz', 'select', 1, '常住，流动', '2019-10-18 18:06:48', '2019-10-18 18:06:48', 1, NULL, 0, 0, NULL, 150, 0, 180, 1);
INSERT INTO `autofields` VALUES (19, 1, '现住址', 'jtzz', 'input', 1, NULL, '2019-10-18 18:06:48', '2019-10-18 18:06:48', 0, NULL, 0, 0, NULL, 150, 0, 60, 1);
INSERT INTO `autofields` VALUES (22, 1, '家庭困难程度', 'jtkncd', 'select', 1, '特殊困难家庭，一般困难家庭，非困难家庭，困难家庭', '2019-10-18 18:06:49', '2019-10-18 18:06:49', 1, '非困难家庭', 0, 0, NULL, 150, 0, 100, 1);
INSERT INTO `autofields` VALUES (23, 1, '是否党员', 'sfdy', 'radio', 1, '是，否', '2019-10-18 18:06:49', '2019-10-18 18:06:49', 1, '否', 0, 1, 'a_dyxxgl', 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (24, 1, '是否育龄妇女', 'sfyln', 'radio', 1, '是，否', '2019-10-18 18:06:49', '2019-10-18 18:06:49', 1, '否', 0, 1, 'a_ylfngl', 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (25, 1, '是否残疾', 'sfcj', 'radio', 1, '是，否', '2019-10-18 18:06:49', '2019-10-18 18:06:49', 1, '否', 0, 1, 'a_cjrgl', 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (27, 1, '是否高龄人员', 'sfglry', 'radio', 1, '是，否', '2019-10-18 18:06:49', '2019-10-18 18:06:49', 1, '否', 0, 1, 'a_llxxgl', 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (28, 1, '居民社会保险', 'jmshbx', 'radio', 1, '是，否', '2019-10-18 18:06:49', '2019-10-18 18:06:49', 1, '否', 0, 1, 'a_jmshbx', 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (29, 1, '是否优抚对象', 'sfyfdx', 'radio', 1, '是，否', '2019-10-18 18:06:49', '2019-10-18 18:06:49', 1, '否', 0, 1, 'a_yfdxgl', 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (31, 1, '是否服役', 'sffy', 'radio', 1, '是，否', '2019-10-18 18:06:49', '2019-10-18 18:06:49', 1, '否', 0, 1, 'a_xtygl', 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (33, 4, '入党日期', 'rdrq', 'date', 1, NULL, '2019-10-18 18:08:35', '2019-10-18 18:08:35', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (34, 4, '党组织关系所在地', 'dzzgxszd', 'input', 1, NULL, '2019-10-18 18:08:35', '2019-10-18 18:08:35', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (35, 4, '参加志愿者活动情况', 'cjzyzhdqk', 'input', 1, NULL, '2019-10-18 18:08:35', '2019-10-18 18:08:35', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (36, 4, '备注', 'bz', 'textarea', 1, NULL, '2019-10-18 18:08:36', '2019-10-18 18:08:36', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (37, 5, '何种党派', 'hzdp', 'input', 1, NULL, '2019-10-18 18:08:45', '2019-10-18 18:08:45', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (38, 6, '初婚日期', 'chrq', 'date', 1, NULL, '2019-10-18 18:11:36', '2019-10-18 18:11:36', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (39, 6, '是否失独家庭', 'sfsdjt', 'radio', 1, '是，否', '2019-10-18 18:11:36', '2019-10-18 18:11:36', 1, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (40, 6, '生育子女姓名', 'syznxm', 'input', 1, NULL, '2019-10-18 18:11:36', '2019-10-18 18:11:36', 0, NULL, 0, 0, 'a_child', 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (41, 6, '是否留守儿童', 'sflset', 'radio', 1, '是，否', '2019-10-18 18:11:36', '2019-10-18 18:11:36', 1, NULL, 0, 0, 'a_child', 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (42, 6, '持有独生子女证', 'cydsznz', 'radio', 1, '是，否', '2019-10-18 18:11:36', '2019-10-18 18:11:36', 1, NULL, 0, 0, 'a_child', 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (43, 6, '独生子女证号', 'dsznzh', 'input', 1, NULL, '2019-10-18 18:11:36', '2019-10-18 18:11:36', 0, NULL, 0, 0, 'a_child', 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (44, 6, '独保费领取情况', 'dbflqqk', 'input', 1, NULL, '2019-10-18 18:11:36', '2019-10-18 18:11:36', 0, NULL, 0, 0, 'a_child', 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (45, 6, '政策属性', 'zcsx', 'input', 1, NULL, '2019-10-18 18:11:36', '2019-10-18 18:11:36', 0, NULL, 0, 0, 'a_child', 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (46, 6, '避孕状态', 'byzt', 'radio', 1, '药具，结扎，皮埋，上环', '2019-10-18 18:11:36', '2019-10-18 18:11:36', 1, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (47, 6, '婚姻状况', 'hyzk', 'radio', 1, '已婚，未婚，离异，丧偶，再婚', '2019-10-18 18:11:37', '2019-10-18 18:11:37', 1, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (48, 6, '备注', 'bz', 'textarea', 1, NULL, '2019-10-18 18:11:37', '2019-10-18 18:11:37', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (49, 8, '是否空巢老人', 'sfkclr', 'radio', 1, '是，否', '2019-10-18 18:13:54', '2019-10-18 18:13:54', 1, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (50, 8, '失能状态', 'snzt', 'radio', 1, '失能，半失能', '2019-10-18 18:13:54', '2019-10-18 18:13:54', 1, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (51, 8, '高龄补贴领取情况', 'glbtlqqk', 'input', 1, NULL, '2019-10-18 18:13:54', '2019-10-18 18:13:54', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (52, 8, '机关事业单位、企业养老金领取情况', 'jgsydwqyyljlqqk', 'input', 1, NULL, '2019-10-18 18:13:55', '2019-10-18 18:13:55', 0, NULL, 0, 0, NULL, 290, 0, 0, 0);
INSERT INTO `autofields` VALUES (53, 8, '赡养人', 'syr', 'input', 1, NULL, '2019-10-18 18:13:55', '2019-10-18 18:13:55', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (54, 8, '联系方式', 'lxfs', 'input', 1, NULL, '2019-10-18 18:13:55', '2019-10-18 18:13:55', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (55, 8, '备注', 'bz', 'textarea', 1, NULL, '2019-10-18 18:13:55', '2019-10-18 18:13:55', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (56, 9, '服役状态', 'fyzt', 'radio', 1, '现役，退役', '2019-10-18 18:16:48', '2019-10-18 18:16:48', 1, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (57, 9, '入伍日期', 'rwrq', 'date', 1, NULL, '2019-10-18 18:16:48', '2019-10-18 18:16:48', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (58, 9, '退役日期', 'tyrq', 'date', 1, NULL, '2019-10-18 18:16:48', '2019-10-18 18:16:48', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (59, 9, '军种', 'jz', 'input', 1, NULL, '2019-10-18 18:16:48', '2019-10-18 18:16:48', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (60, 9, '服役地', 'fyd', 'input', 1, NULL, '2019-10-18 18:16:48', '2019-10-18 18:16:48', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (61, 9, '退役地', 'tyd', 'input', 1, NULL, '2019-10-18 18:16:48', '2019-10-18 18:16:48', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (62, 9, '亲属姓名', 'qsxm', 'input', 1, NULL, '2019-10-18 18:16:49', '2019-10-18 18:16:49', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (63, 9, '立功情况', 'lgqk', 'input', 1, NULL, '2019-10-18 18:16:49', '2019-10-18 18:16:49', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (64, 9, '参加民兵组织', 'cjmbzz', 'radio', 1, '是，否', '2019-10-18 18:16:49', '2019-10-18 18:16:49', 1, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (65, 9, '年龄', 'nl', 'input', 1, NULL, '2019-10-18 18:16:49', '2019-10-18 18:16:49', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (66, 10, '申请低保原因', 'sqdbyy', 'textarea', 1, NULL, '2019-10-18 18:17:28', '2019-10-18 18:17:28', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (67, 11, '联系方式', 'lxfs', 'input', 1, NULL, '2019-10-18 18:19:21', '2019-10-18 18:19:21', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (68, 11, '优抚基本情况', 'yfjbqk', 'input', 1, NULL, '2019-10-18 18:19:21', '2019-10-18 18:19:21', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (69, 11, '备注', 'bz', 'textarea', 1, NULL, '2019-10-18 18:19:21', '2019-10-18 18:19:21', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (70, 21, '享有低保人数', 'xydbrs', 'input', 1, NULL, '2019-10-18 18:20:21', '2019-10-18 18:20:21', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (71, 21, '低保申请原因', 'dbsqyy', 'input', 1, NULL, '2019-10-18 18:20:21', '2019-10-18 18:20:21', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (72, 21, '领取救助金额', 'lqjzje', 'input', 1, NULL, '2019-10-18 18:20:21', '2019-10-18 18:20:21', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (73, 21, '享有慢保情况', 'xymbqk', 'input', 1, NULL, '2019-10-18 18:20:21', '2019-10-18 18:20:21', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (74, 21, '家庭年收入', 'jtnsr', 'input', 1, NULL, '2019-10-18 18:20:22', '2019-10-18 18:20:22', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (75, 21, '备注', 'bz', 'textarea', 1, NULL, '2019-10-18 18:20:22', '2019-10-18 18:20:22', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (76, 12, '残疾类型', 'cjlx', 'input', 1, NULL, '2019-10-18 18:22:50', '2019-10-18 18:22:50', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (77, 12, '残疾等级', 'cjdj', 'select', 1, '一级，二级，三级，四级，五级，六级，七级，八级，九级，十级', '2019-10-18 18:22:50', '2019-10-18 18:22:50', 1, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (78, 12, '残疾证号', 'cjzh', 'input', 1, NULL, '2019-10-18 18:22:50', '2019-10-18 18:22:50', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (79, 12, '残疾证领取时间', 'cjzlqsj', 'date', 1, NULL, '2019-10-18 18:22:50', '2019-10-18 18:22:50', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (80, 12, '是否享有低保', 'sfxydb', 'radio', 1, '是，否', '2019-10-18 18:22:50', '2019-10-18 18:22:50', 1, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (81, 12, '监护人', 'jhr', 'input', 1, NULL, '2019-10-18 18:22:50', '2019-10-18 18:22:50', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (82, 12, '联系方式', 'lxfs', 'input', 1, NULL, '2019-10-18 18:22:50', '2019-10-18 18:22:50', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (83, 12, '备注', 'bz', 'textarea', 1, NULL, '2019-10-18 18:22:50', '2019-10-18 18:22:50', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (84, 13, '违法情况', 'wfqk', 'select', 1, '社区矫正人员，安置帮教人员，两释人员，吸毒人员', '2019-10-18 18:23:45', '2019-10-18 18:23:45', 1, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (85, 13, '犯罪原因', 'fzyy', 'textarea', 1, NULL, '2019-10-18 18:23:45', '2019-10-18 18:23:45', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (86, 14, '组织名称', 'zzmc', 'select', 1, '门徒会，全能神，法轮功，其它', '2019-10-18 18:24:33', '2019-10-18 18:24:33', 1, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (87, 15, '关注原因', 'gzyy', 'select', 1, '失独，老党员，重点帮扶家庭，重点管理人群，社区矫正人员，其它', '2019-10-18 18:25:09', '2019-10-18 18:25:09', 1, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (88, 15, '备注', 'bz', 'textarea', 1, NULL, '2019-10-18 18:25:09', '2019-10-18 18:25:09', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (89, 16, '医保费用缴纳所在地', 'ybfyjnszd', 'input', 1, NULL, '2019-10-18 18:26:29', '2019-10-18 18:26:29', 0, NULL, 0, 0, NULL, 200, 0, 0, 0);
INSERT INTO `autofields` VALUES (90, 16, '医保缴纳情况', 'ybjnqk', 'input', 1, NULL, '2019-10-18 18:26:29', '2019-10-18 18:26:29', 0, NULL, 0, 0, NULL, 200, 0, 0, 0);
INSERT INTO `autofields` VALUES (91, 16, '养老保险金缴纳所在地', 'ylbxjjnszd', 'input', 1, NULL, '2019-10-18 18:26:29', '2019-10-18 18:26:29', 0, NULL, 0, 0, NULL, 200, 0, 0, 0);
INSERT INTO `autofields` VALUES (92, 16, '养老保险金缴纳情况', 'ylbxjjnqk', 'input', 1, NULL, '2019-10-18 18:26:29', '2019-10-18 18:26:29', 0, NULL, 0, 0, NULL, 200, 0, 0, 0);
INSERT INTO `autofields` VALUES (93, 17, '中文姓名', 'zwxm', 'input', 1, NULL, '2019-10-18 18:29:02', '2019-10-18 18:29:02', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (94, 17, '外文姓名', 'wwxm', 'input', 1, NULL, '2019-10-18 18:29:02', '2019-10-18 18:29:02', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (95, 17, '性别', 'xb', 'radio', 1, '男，女', '2019-10-18 18:29:02', '2019-10-18 18:29:02', 1, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (96, 17, '出生日期', 'csrq', 'date', 1, NULL, '2019-10-18 18:29:02', '2019-10-18 18:29:02', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (97, 17, '国籍', 'gj', 'input', 1, NULL, '2019-10-18 18:29:02', '2019-10-18 18:29:02', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (98, 17, '联系方式', 'lxfs', 'input', 1, NULL, '2019-10-18 18:29:02', '2019-10-18 18:29:02', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (99, 17, '签证种类', 'qzzl', 'input', 1, NULL, '2019-10-18 18:29:02', '2019-10-18 18:29:02', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (100, 17, '签证号码', 'qzhm', 'input', 1, NULL, '2019-10-18 18:29:02', '2019-10-18 18:29:02', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (101, 17, '签证有效期', 'qzyxq', 'date', 1, NULL, '2019-10-18 18:29:02', '2019-10-18 18:29:02', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (102, 17, '签证机关', 'qzjg', 'input', 1, NULL, '2019-10-18 18:29:02', '2019-10-18 18:29:02', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (103, 17, '人员类型', 'rylx', 'select', 1, '外国停留人员，华侨停留人员，港澳地区停拘留人员，台湾地区停拘留人员，其它', '2019-10-18 18:29:02', '2019-10-18 18:29:02', 1, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (104, 17, '入境日期', 'rjrq', 'date', 1, NULL, '2019-10-18 18:29:03', '2019-10-18 18:29:03', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (105, 17, '工作机构', 'gzjg', 'input', 1, NULL, '2019-10-18 18:29:03', '2019-10-18 18:29:03', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (106, 17, '停留事由', 'tlsy', 'input', 1, NULL, '2019-10-18 18:29:03', '2019-10-18 18:29:03', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (107, 17, '拟离日期', 'nlrq', 'date', 1, NULL, '2019-10-18 18:29:03', '2019-10-18 18:29:03', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (108, 17, '国内邀请人', 'gnyqr', 'input', 1, NULL, '2019-10-18 18:29:03', '2019-10-18 18:29:03', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (109, 17, '联系方式', 'lxfs16', 'input', 1, NULL, '2019-10-18 18:29:03', '2019-10-18 18:29:03', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (110, 18, '公司名称', 'gsmc', 'input', 1, NULL, '2019-10-18 18:29:57', '2019-10-18 18:29:57', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (111, 18, '法人', 'fr', 'input', 1, NULL, '2019-10-18 18:29:57', '2019-10-18 18:29:57', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (112, 18, '公司地址', 'gsdz', 'input', 1, NULL, '2019-10-18 18:29:57', '2019-10-18 18:29:57', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (113, 18, '联系方式', 'lxfs', 'input', 1, NULL, '2019-10-18 18:29:57', '2019-10-18 18:29:57', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (114, 20, '建议诉讼', 'jyss', 'textarea', 1, NULL, '2019-10-18 18:30:42', '2019-10-18 18:30:42', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (457, 4, '党员情况', 'dyqk', 'select', 1, '流动党员，居民党员，离退休党员，干部职工党员，困难党员，机关支部党员，其它', '2019-10-25 15:33:06', '2019-10-25 15:33:06', 1, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (458, 1, '是否邪教', 'sfxj', 'radio', 1, '是，否', '2019-10-28 18:34:25', '2019-10-28 18:34:25', 1, '否', 0, 1, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (459, 1, '是否重点关注', 'sfzdgz', 'radio', 1, '是，否', '2019-10-28 18:38:20', '2019-10-28 18:38:20', 1, '否', 0, 1, 'a_zdgzgl', 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (460, 1, '联系方式', 'lxfs', 'input', 1, NULL, '2019-10-29 10:31:37', '2019-10-29 10:31:37', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (461, 1, '备注', 'bz', 'textarea', 1, NULL, '2019-10-29 10:31:38', '2019-10-29 10:31:38', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (462, 1, '社会救助', 'shjz', 'radio', 1, '是，否', '2019-10-29 15:34:05', '2019-10-29 15:34:05', 1, '否', 0, 1, 'a_shjl', 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (583, 13, '危险标注', 'wxbz', 'upload', 1, NULL, '2019-10-30 15:12:28', '2019-10-30 15:12:28', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (585, 9, '备注', 'bz', 'textarea', 1, NULL, '2019-11-01 14:58:47', '2019-11-01 14:58:47', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (587, 1, '是否租户', 'jzlx', 'radio', 1, '是，否', '2019-12-04 18:03:48', '2019-12-04 18:03:48', 1, '否', 0, 1, 'a_fdxx', 150, 0, 50, 1);
INSERT INTO `autofields` VALUES (595, 46, '房主姓名', 'fzxm', 'input', 1, NULL, '2021-05-19 11:21:36', '2021-05-19 11:21:36', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (596, 46, '房主性别', 'fzxb', 'radio', 1, '男，女', '2021-05-19 11:21:36', '2021-05-19 11:21:36', 1, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (597, 46, '民族', 'mz', 'input', 1, NULL, '2021-05-19 11:21:36', '2021-05-19 11:21:36', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (598, 46, '籍贯', 'jg', 'input', 1, NULL, '2021-05-19 11:21:36', '2021-05-19 11:21:36', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (599, 46, '户籍地址', 'hjdz', 'input', 1, NULL, '2021-05-19 11:21:36', '2021-05-19 11:21:36', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (600, 46, '实际住址', 'sjzz', 'input', 1, NULL, '2021-05-19 11:21:36', '2021-05-19 11:21:36', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (601, 46, '身份证号', 'sfzh6', 'input', 1, NULL, '2021-05-19 11:21:36', '2021-05-19 11:21:36', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (602, 46, '联系电话', 'lxdh', 'input', 1, NULL, '2021-05-19 11:21:36', '2021-05-19 11:21:36', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (603, 1, '流入时间', 'lrsj', 'date', 1, NULL, '2021-05-19 11:28:57', '2021-05-19 11:28:57', 0, NULL, 0, 0, NULL, 150, 0, 90, 1);
INSERT INTO `autofields` VALUES (604, 1, '流出时间', 'lcsj', 'date', 1, NULL, '2021-05-19 11:28:58', '2021-05-19 11:28:58', 0, NULL, 0, 0, NULL, 150, 0, 80, 1);
INSERT INTO `autofields` VALUES (605, 1, '个体工商户', 'gtgsh', 'radio', 1, '是，否', '2021-05-19 11:28:58', '2021-05-19 11:28:58', 1, NULL, 0, 0, NULL, 150, 0, 160, 1);
INSERT INTO `autofields` VALUES (606, 1, '厕所类型', 'cslx', 'select', 1, '水厕，旱厕', '2021-05-19 11:28:58', '2021-05-19 11:28:58', 1, NULL, 0, 0, NULL, 150, 0, 150, 1);
INSERT INTO `autofields` VALUES (607, 1, '食品安全隐患', 'spaqyh', 'radio', 1, '是，否', '2021-05-19 11:28:58', '2021-05-19 11:28:58', 1, NULL, 0, 0, NULL, 150, 0, 140, 1);
INSERT INTO `autofields` VALUES (608, 1, '供暖类型', 'gnlx', 'select', 1, '天然气，无烟煤，有烟煤', '2021-05-19 11:28:58', '2021-05-19 11:28:58', 1, NULL, 0, 0, NULL, 150, 0, 130, 1);
INSERT INTO `autofields` VALUES (609, 1, '拥有车辆', 'yycl', 'radio', 1, '是，否', '2021-05-19 11:28:58', '2021-05-19 11:28:58', 1, NULL, 0, 0, NULL, 150, 0, 120, 1);
INSERT INTO `autofields` VALUES (610, 1, '住房性质', 'zfxz', 'select', 1, '商品房，平房，门面房，其他', '2021-05-19 11:28:58', '2021-05-19 11:28:58', 1, NULL, 0, 0, NULL, 150, 0, 110, 1);
INSERT INTO `autofields` VALUES (611, 4, '是否参加组织生活', 'sfcjzzsh', 'radio', 1, '是，否', '2021-05-19 11:31:09', '2021-05-19 11:31:09', 1, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (612, 12, '是否建档', 'sfjd', 'radio', 1, '是，否', '2021-05-19 11:31:54', '2021-05-19 11:31:54', 1, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (613, 16, '医保类型', 'yblx', 'select', 1, '职工，居民，合疗', '2021-05-19 11:35:24', '2021-05-19 11:35:24', 1, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (614, 16, '养老类型', 'yllx', 'select', 1, '职工，基本', '2021-05-19 11:35:24', '2021-05-19 11:35:24', 1, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (615, 47, '政策类型', 'zclx', 'select', 1, '独生子女报检费记录，独生子女父母补助金，特别扶助，低保，大病救助，临时救助，失独家庭，计生伤残家庭，其他', '2021-05-19 11:36:52', '2021-05-19 11:36:52', 1, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (616, 47, '补助金额', 'bzje', 'input', 1, NULL, '2021-05-19 11:36:52', '2021-05-19 11:36:52', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (617, 47, '补助说明信息', 'bzsmxx', 'textarea', 1, NULL, '2021-05-19 11:36:52', '2021-05-19 11:36:52', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (618, 1, '优惠政策', 'yhzc', 'radio', 1, '是，否', '2021-05-19 11:37:38', '2021-05-19 11:37:38', 1, '否', 0, 1, 'a_yhzc', 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (619, 1, '婚姻变动', 'hybd', 'radio', 1, '是，否', '2021-05-19 11:37:38', '2021-05-19 11:37:38', 1, '否', 0, 1, 'a_hybd', 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (620, 48, '变动时间', 'bdsj', 'date', 1, NULL, '2021-05-19 11:41:44', '2021-05-19 11:41:44', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (621, 48, '变动类型', 'bdlx', 'select', 1, '已婚，离异，丧偶，复婚', '2021-05-19 11:41:44', '2021-05-19 11:41:44', 1, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (622, 48, '变动说明', 'bdsm', 'textarea', 1, NULL, '2021-05-19 11:41:44', '2021-05-19 11:41:44', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (623, 6, '领取日期', 'lqrq', 'date', 1, NULL, '2021-05-19 11:55:26', '2021-05-19 11:55:26', 0, NULL, 0, 0, 'a_child', 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (625, 49, '户号', 'hh', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 1, 0, NULL, 150, 25, 190, 1);
INSERT INTO `autofields` VALUES (626, 49, '与户主关系', 'yhzgx', 'select', 1, '户主，配偶，父亲，母亲，儿子，女儿，其它', '2021-05-20 00:00:00', '2021-05-20 00:00:00', 1, '户主', 1, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (627, 49, '姓名', 'xm', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 1, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (628, 49, '性别', 'xb', 'radio', 1, '男，女', '2021-05-20 00:00:00', '2021-05-20 00:00:00', 1, '男', 1, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (629, 49, '民族', 'mz', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 1, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (630, 49, '出生日期', 'csrq', 'date', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 1, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (631, 49, '身份证号', 'sfzh', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 1, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (632, 49, '文化程度', 'whcd', 'select', 1, '小学，初中，高中，专科，本科，研究生，其它', '2021-05-20 00:00:00', '2021-05-20 00:00:00', 1, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (633, 49, '有何特长', 'yhtc', 'textarea', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (634, 49, '血型', 'xx', 'select', 1, 'A，B，AB，O', '2021-05-20 00:00:00', '2021-05-20 00:00:00', 1, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (635, 49, '政治面貌', 'zzmm', 'select', 1, '党员，团员，群众，其它民主党派', '2021-05-20 00:00:00', '2021-05-20 00:00:00', 1, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (636, 49, '婚姻状况', 'hyzk', 'select', 1, '初婚，未婚，再婚，离异，丧偶，其它', '2021-05-20 00:00:00', '2021-05-20 00:00:00', 1, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (637, 49, '结婚日期', 'jhrq', 'date', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (638, 49, '从业状况', 'cyzk', 'select', 1, '就业，待业，退休，其它', '2021-05-20 00:00:00', '2021-05-20 00:00:00', 1, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (639, 49, '工作单位', 'gzdw', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (640, 49, '户籍地址', 'hjszd', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 70, 1);
INSERT INTO `autofields` VALUES (641, 49, '户口性质', 'hb', 'select', 1, '农业，非农，集体', '2021-05-20 00:00:00', '2021-05-20 00:00:00', 1, NULL, 0, 0, NULL, 150, 25, 170, 1);
INSERT INTO `autofields` VALUES (642, 49, '住户类型', 'jzxz', 'select', 1, '常住，流动', '2021-05-20 00:00:00', '2021-05-20 00:00:00', 1, NULL, 0, 0, NULL, 150, 25, 180, 1);
INSERT INTO `autofields` VALUES (643, 49, '现住址', 'jtzz', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 60, 1);
INSERT INTO `autofields` VALUES (644, 49, '家庭困难程度', 'jtkncd', 'select', 1, '特殊困难家庭，一般困难家庭，非困难家庭，困难家庭', '2021-05-20 00:00:00', '2021-05-20 00:00:00', 1, '非困难家庭', 0, 0, NULL, 150, 25, 100, 1);
INSERT INTO `autofields` VALUES (645, 49, '是否党员', 'sfdy', 'radio', 1, '是，否', '2021-05-20 00:00:00', '2021-05-20 00:00:00', 1, '否', 0, 1, 'a_dyxxgl', 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (646, 49, '是否育龄妇女', 'sfyln', 'radio', 1, '是，否', '2021-05-20 00:00:00', '2021-05-20 00:00:00', 1, '否', 0, 1, 'a_ylfngl', 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (647, 49, '是否残疾', 'sfcj', 'radio', 1, '是，否', '2021-05-20 00:00:00', '2021-05-20 00:00:00', 1, '否', 0, 1, 'a_cjrgl', 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (648, 49, '是否高龄人员', 'sfglry', 'radio', 1, '是，否', '2021-05-20 00:00:00', '2021-05-20 00:00:00', 1, '否', 0, 1, 'a_llxxgl', 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (649, 49, '居民社会保险', 'jmshbx', 'radio', 1, '是，否', '2021-05-20 00:00:00', '2021-05-20 00:00:00', 1, '否', 0, 1, 'a_jmshbx', 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (650, 49, '是否优抚对象', 'sfyfdx', 'radio', 1, '是，否', '2021-05-20 00:00:00', '2021-05-20 00:00:00', 1, '否', 0, 1, 'a_yfdxgl', 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (651, 49, '是否服役', 'sffy', 'radio', 1, '是，否', '2021-05-20 00:00:00', '2021-05-20 00:00:00', 1, '否', 0, 1, 'a_xtygl', 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (652, 49, '是否邪教', 'sfxj', 'radio', 1, '是，否', '2021-05-20 00:00:00', '2021-05-20 00:00:00', 1, '否', 0, 1, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (653, 49, '是否重点关注', 'sfzdgz', 'radio', 1, '是，否', '2021-05-20 00:00:00', '2021-05-20 00:00:00', 1, '否', 0, 1, 'a_zdgzgl', 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (654, 49, '联系方式', 'lxfs', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (655, 49, '备注', 'bz', 'textarea', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (656, 49, '社会救助', 'shjz', 'radio', 1, '是，否', '2021-05-20 00:00:00', '2021-05-20 00:00:00', 1, '否', 0, 1, 'a_shjl', 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (657, 49, '是否租户', 'jzlx', 'radio', 1, '是，否', '2021-05-20 00:00:00', '2021-05-20 00:00:00', 1, '否', 0, 1, 'a_fdxx', 150, 25, 50, 1);
INSERT INTO `autofields` VALUES (658, 49, '流入时间', 'lrsj', 'date', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 90, 1);
INSERT INTO `autofields` VALUES (659, 49, '流出时间', 'lcsj', 'date', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 80, 1);
INSERT INTO `autofields` VALUES (660, 49, '个体工商户', 'gtgsh', 'radio', 1, '是，否', '2021-05-20 00:00:00', '2021-05-20 00:00:00', 1, NULL, 0, 0, NULL, 150, 25, 160, 1);
INSERT INTO `autofields` VALUES (661, 49, '厕所类型', 'cslx', 'select', 1, '水厕，旱厕', '2021-05-20 00:00:00', '2021-05-20 00:00:00', 1, NULL, 0, 0, NULL, 150, 25, 150, 1);
INSERT INTO `autofields` VALUES (662, 49, '食品安全隐患', 'spaqyh', 'radio', 1, '是，否', '2021-05-20 00:00:00', '2021-05-20 00:00:00', 1, NULL, 0, 0, NULL, 150, 25, 140, 1);
INSERT INTO `autofields` VALUES (663, 49, '供暖类型', 'gnlx', 'select', 1, '天然气，无烟煤，有烟煤', '2021-05-20 00:00:00', '2021-05-20 00:00:00', 1, NULL, 0, 0, NULL, 150, 25, 130, 1);
INSERT INTO `autofields` VALUES (664, 49, '拥有车辆', 'yycl', 'radio', 1, '是，否', '2021-05-20 00:00:00', '2021-05-20 00:00:00', 1, NULL, 0, 0, NULL, 150, 25, 120, 1);
INSERT INTO `autofields` VALUES (665, 49, '住房性质', 'zfxz', 'select', 1, '商品房，平房，门面房，其他', '2021-05-20 00:00:00', '2021-05-20 00:00:00', 1, NULL, 0, 0, NULL, 150, 25, 110, 1);
INSERT INTO `autofields` VALUES (666, 49, '优惠政策', 'yhzc', 'radio', 1, '是，否', '2021-05-20 00:00:00', '2021-05-20 00:00:00', 1, '否', 0, 1, 'a_yhzc', 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (667, 49, '婚姻变动', 'hybd', 'radio', 1, '是，否', '2021-05-20 00:00:00', '2021-05-20 00:00:00', 1, '否', 0, 1, 'a_hybd', 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (669, 52, '房主姓名', 'fzxm', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (670, 52, '房主性别', 'fzxb', 'radio', 1, '男，女', '2021-05-20 00:00:00', '2021-05-20 00:00:00', 1, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (671, 52, '民族', 'mz', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (672, 52, '籍贯', 'jg', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (673, 52, '户籍地址', 'hjdz', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (674, 52, '实际住址', 'sjzz', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (675, 52, '身份证号', 'sfzh6', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (676, 52, '联系电话', 'lxdh', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (677, 53, '入党日期', 'rdrq', 'date', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (678, 53, '党组织关系所在地', 'dzzgxszd', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (679, 53, '参加志愿者活动情况', 'cjzyzhdqk', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (680, 53, '备注', 'bz', 'textarea', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (681, 53, '党员情况', 'dyqk', 'select', 1, '流动党员，居民党员，离退休党员，干部职工党员，困难党员，机关支部党员，其它', '2021-05-20 00:00:00', '2021-05-20 00:00:00', 1, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (682, 53, '是否参加组织生活', 'sfcjzzsh', 'radio', 1, '是，否', '2021-05-20 00:00:00', '2021-05-20 00:00:00', 1, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (683, 54, '何种党派', 'hzdp', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (684, 55, '初婚日期', 'chrq', 'date', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (685, 55, '是否失独家庭', 'sfsdjt', 'radio', 1, '是，否', '2021-05-20 00:00:00', '2021-05-20 00:00:00', 1, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (686, 55, '生育子女姓名', 'syznxm', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, 'a_child', 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (687, 55, '是否留守儿童', 'sflset', 'radio', 1, '是，否', '2021-05-20 00:00:00', '2021-05-20 00:00:00', 1, NULL, 0, 0, 'a_child', 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (688, 55, '持有独生子女证', 'cydsznz', 'radio', 1, '是，否', '2021-05-20 00:00:00', '2021-05-20 00:00:00', 1, NULL, 0, 0, 'a_child', 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (689, 55, '独生子女证号', 'dsznzh', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, 'a_child', 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (690, 55, '独保费领取情况', 'dbflqqk', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, 'a_child', 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (691, 55, '政策属性', 'zcsx', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, 'a_child', 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (692, 55, '避孕状态', 'byzt', 'radio', 1, '药具，结扎，皮埋，上环', '2021-05-20 00:00:00', '2021-05-20 00:00:00', 1, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (693, 55, '婚姻状况', 'hyzk', 'radio', 1, '已婚，未婚，离异，丧偶，再婚', '2021-05-20 00:00:00', '2021-05-20 00:00:00', 1, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (694, 55, '备注', 'bz', 'textarea', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (695, 55, '领取日期', 'lqrq', 'date', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, 'a_child', 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (696, 56, '是否空巢老人', 'sfkclr', 'radio', 1, '是，否', '2021-05-20 00:00:00', '2021-05-20 00:00:00', 1, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (697, 56, '失能状态', 'snzt', 'radio', 1, '失能，半失能', '2021-05-20 00:00:00', '2021-05-20 00:00:00', 1, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (698, 56, '高龄补贴领取情况', 'glbtlqqk', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (699, 56, '机关事业单位、企业养老金领取情况', 'jgsydwqyyljlqqk', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 290, 25, 0, 0);
INSERT INTO `autofields` VALUES (700, 56, '赡养人', 'syr', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (701, 56, '联系方式', 'lxfs', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (702, 56, '备注', 'bz', 'textarea', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (703, 57, '服役状态', 'fyzt', 'radio', 1, '现役，退役', '2021-05-20 00:00:00', '2021-05-20 00:00:00', 1, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (704, 57, '入伍日期', 'rwrq', 'date', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (705, 57, '退役日期', 'tyrq', 'date', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (706, 57, '军种', 'jz', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (707, 57, '服役地', 'fyd', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (708, 57, '退役地', 'tyd', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (709, 57, '亲属姓名', 'qsxm', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (710, 57, '立功情况', 'lgqk', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (711, 57, '参加民兵组织', 'cjmbzz', 'radio', 1, '是，否', '2021-05-20 00:00:00', '2021-05-20 00:00:00', 1, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (712, 57, '年龄', 'nl', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (713, 57, '备注', 'bz', 'textarea', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (714, 58, '申请低保原因', 'sqdbyy', 'textarea', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (715, 59, '联系方式', 'lxfs', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (716, 59, '优抚基本情况', 'yfjbqk', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (717, 59, '备注', 'bz', 'textarea', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (718, 60, '享有低保人数', 'xydbrs', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (719, 60, '低保申请原因', 'dbsqyy', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (720, 60, '领取救助金额', 'lqjzje', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (721, 60, '享有慢保情况', 'xymbqk', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (722, 60, '家庭年收入', 'jtnsr', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (723, 60, '备注', 'bz', 'textarea', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (724, 61, '政策类型', 'zclx', 'select', 1, '独生子女报检费记录，独生子女父母补助金，特别扶助，低保，大病救助，临时救助，失独家庭，计生伤残家庭，其他', '2021-05-20 00:00:00', '2021-05-20 00:00:00', 1, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (725, 61, '补助金额', 'bzje', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (726, 61, '补助说明信息', 'bzsmxx', 'textarea', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (727, 62, '变动时间', 'bdsj', 'date', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (728, 62, '变动类型', 'bdlx', 'select', 1, '已婚，离异，丧偶，复婚', '2021-05-20 00:00:00', '2021-05-20 00:00:00', 1, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (729, 62, '变动说明', 'bdsm', 'textarea', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (730, 63, '残疾类型', 'cjlx', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (731, 63, '残疾等级', 'cjdj', 'select', 1, '一级，二级，三级，四级，五级，六级，七级，八级，九级，十级', '2021-05-20 00:00:00', '2021-05-20 00:00:00', 1, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (732, 63, '残疾证号', 'cjzh', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (733, 63, '残疾证领取时间', 'cjzlqsj', 'date', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (734, 63, '是否享有低保', 'sfxydb', 'radio', 1, '是，否', '2021-05-20 00:00:00', '2021-05-20 00:00:00', 1, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (735, 63, '监护人', 'jhr', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (736, 63, '联系方式', 'lxfs', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (737, 63, '备注', 'bz', 'textarea', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (738, 63, '是否建档', 'sfjd', 'radio', 1, '是，否', '2021-05-20 00:00:00', '2021-05-20 00:00:00', 1, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (739, 64, '组织名称', 'zzmc', 'select', 1, '门徒会，全能神，法轮功，其它', '2021-05-20 00:00:00', '2021-05-20 00:00:00', 1, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (740, 65, '关注原因', 'gzyy', 'select', 1, '失独，老党员，重点帮扶家庭，重点管理人群，社区矫正人员，其它', '2021-05-20 00:00:00', '2021-05-20 00:00:00', 1, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (741, 65, '备注', 'bz', 'textarea', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (742, 66, '医保费用缴纳所在地', 'ybfyjnszd', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 200, 25, 0, 0);
INSERT INTO `autofields` VALUES (743, 66, '医保缴纳情况', 'ybjnqk', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 200, 25, 0, 0);
INSERT INTO `autofields` VALUES (744, 66, '养老保险金缴纳所在地', 'ylbxjjnszd', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 200, 25, 0, 0);
INSERT INTO `autofields` VALUES (745, 66, '养老保险金缴纳情况', 'ylbxjjnqk', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 200, 25, 0, 0);
INSERT INTO `autofields` VALUES (746, 66, '医保类型', 'yblx', 'select', 1, '职工，居民，合疗', '2021-05-20 00:00:00', '2021-05-20 00:00:00', 1, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (747, 66, '养老类型', 'yllx', 'select', 1, '职工，基本', '2021-05-20 00:00:00', '2021-05-20 00:00:00', 1, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (748, 67, '中文姓名', 'zwxm', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (749, 67, '外文姓名', 'wwxm', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (750, 67, '性别', 'xb', 'radio', 1, '男，女', '2021-05-20 00:00:00', '2021-05-20 00:00:00', 1, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (751, 67, '出生日期', 'csrq', 'date', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (752, 67, '国籍', 'gj', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (753, 67, '联系方式', 'lxfs', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (754, 67, '签证种类', 'qzzl', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (755, 67, '签证号码', 'qzhm', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (756, 67, '签证有效期', 'qzyxq', 'date', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (757, 67, '签证机关', 'qzjg', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (758, 67, '人员类型', 'rylx', 'select', 1, '外国停留人员，华侨停留人员，港澳地区停拘留人员，台湾地区停拘留人员，其它', '2021-05-20 00:00:00', '2021-05-20 00:00:00', 1, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (759, 67, '入境日期', 'rjrq', 'date', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (760, 67, '工作机构', 'gzjg', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (761, 67, '停留事由', 'tlsy', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (762, 67, '拟离日期', 'nlrq', 'date', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (763, 67, '国内邀请人', 'gnyqr', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (764, 67, '联系方式', 'lxfs16', 'input', 1, NULL, '2021-05-20 00:00:00', '2021-05-20 00:00:00', 0, NULL, 0, 0, NULL, 150, 25, 0, 0);
INSERT INTO `autofields` VALUES (765, 1, '网格员', 'wgy', 'input', 1, NULL, '2022-04-29 10:47:54', '2022-04-29 10:47:54', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (766, 1, '召集人', 'zjr', 'input', 1, NULL, '2022-04-29 10:47:54', '2022-04-29 10:47:54', 0, NULL, 0, 0, NULL, 150, 0, 0, 0);
INSERT INTO `autofields` VALUES (767, 49, '网格员', 'wgy', 'input', 1, NULL, '2022-04-29 11:10:42', '2022-04-29 11:10:45', 0, NULL, 0, 0, NULL, 150, 25, 0, 1);
INSERT INTO `autofields` VALUES (768, 49, '召集人', 'zjr', 'input', 1, NULL, '2022-04-29 11:10:47', '2022-04-29 11:10:49', 0, NULL, 0, 0, NULL, 150, 25, 0, 1);

-- ----------------------------
-- Table structure for autotables
-- ----------------------------
DROP TABLE IF EXISTS `autotables`;
CREATE TABLE `autotables`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '名称',
  `tbname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '生成的表名',
  `pid` int(11) NULL DEFAULT NULL COMMENT '权限id',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `showfield` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '显示的字段',
  `note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `state` int(1) NULL DEFAULT 1 COMMENT '0-删除，1-正常',
  `type` int(1) NULL DEFAULT NULL COMMENT '0-表单，1-功能页',
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '页面地址',
  `bscid` int(11) NULL DEFAULT 0 COMMENT '办事处id',
  `ext` int(1) NULL DEFAULT 1 COMMENT '0-非附属，1-附属',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 69 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of autotables
-- ----------------------------
INSERT INTO `autotables` VALUES (1, '居民信息管理', 'a_jmxxgl', 1, '2019-10-18 17:27:19', '2019-10-24 10:24:26', NULL, NULL, 1, 0, '/formtable/basic', 0, 1);
INSERT INTO `autotables` VALUES (2, '居民信息迁移', NULL, 1, '2019-10-18 17:27:43', '2019-10-18 17:27:43', NULL, NULL, 1, 1, '/user/move', 0, 0);
INSERT INTO `autotables` VALUES (3, '以户为单位管理', NULL, 1, '2019-10-18 17:27:56', '2019-10-18 17:27:56', NULL, NULL, 1, 1, '/user/homemanage', 0, 0);
INSERT INTO `autotables` VALUES (4, '党员信息管理', 'a_dyxxgl', 2, '2019-10-18 17:28:40', '2019-10-18 17:28:40', NULL, NULL, 1, 0, '/party/partymanage', 0, 1);
INSERT INTO `autotables` VALUES (5, '其它党派管理', 'a_qtdpgl', 2, '2019-10-18 17:29:03', '2019-10-18 17:29:03', NULL, NULL, 1, 0, NULL, 0, 1);
INSERT INTO `autotables` VALUES (6, '育龄妇女管理', 'a_ylfngl', 3, '2019-10-18 17:29:36', '2019-10-18 17:29:36', NULL, NULL, 1, 0, '/user/funvmanage', 0, 1);
INSERT INTO `autotables` VALUES (8, '老龄信息管理', 'a_llxxgl', 4, '2019-10-18 17:51:58', '2019-10-18 17:51:58', NULL, NULL, 1, 0, '/user/oldmanage', 0, 1);
INSERT INTO `autotables` VALUES (9, '现退役管理', 'a_xtygl', 4, '2019-10-18 17:52:14', '2019-10-18 17:52:14', NULL, NULL, 1, 0, '/party/soldier', 0, 1);
INSERT INTO `autotables` VALUES (10, '低保人员管理', 'a_dbrygl', 4, '2019-10-18 17:53:07', '2019-10-18 17:53:07', NULL, NULL, 1, 0, NULL, 0, 1);
INSERT INTO `autotables` VALUES (11, '优抚对象管理', 'a_yfdxgl', 4, '2019-10-18 17:53:13', '2019-10-18 17:53:13', NULL, NULL, 1, 0, NULL, 0, 1);
INSERT INTO `autotables` VALUES (12, '残疾人管理', 'a_cjrgl', 5, '2019-10-18 17:53:49', '2019-10-18 17:53:49', NULL, NULL, 1, 0, NULL, 0, 1);
INSERT INTO `autotables` VALUES (13, '司法管理', 'a_wfxxgl', 6, '2019-10-18 17:54:05', '2019-10-18 17:54:05', NULL, NULL, 1, 0, NULL, 0, 1);
INSERT INTO `autotables` VALUES (14, '邪教人员管理', 'a_xjrygl', 7, '2019-10-18 17:54:17', '2021-05-21 14:46:12', NULL, NULL, 0, 0, NULL, 0, 1);
INSERT INTO `autotables` VALUES (15, '重点关注管理', 'a_zdgzgl', 8, '2019-10-18 17:54:54', '2019-10-18 17:54:54', NULL, NULL, 1, 0, NULL, 0, 1);
INSERT INTO `autotables` VALUES (16, '居民社会保险', 'a_jmshbx', 9, '2019-10-18 17:55:32', '2019-10-18 17:55:32', NULL, NULL, 1, 0, NULL, 0, 1);
INSERT INTO `autotables` VALUES (17, '境外人员管理', 'a_jwrygl', 13, '2019-10-18 17:55:53', '2021-05-21 14:46:24', NULL, NULL, 0, 0, NULL, 0, 0);
INSERT INTO `autotables` VALUES (18, '辖区企业管理', 'a_xqqygl', 10, '2019-10-18 17:56:56', '2019-10-25 18:21:49', NULL, NULL, 1, 0, '/formtable/company', 0, 0);
INSERT INTO `autotables` VALUES (19, '居住证明打印', 'a_jmxxgl', 11, '2019-10-18 17:57:38', '2019-10-18 17:57:38', NULL, NULL, 1, 1, '/user/print', 0, 0);
INSERT INTO `autotables` VALUES (20, '建议诉讼管理', 'a_jyssgl', 12, '2019-10-18 17:57:56', '2019-10-18 17:57:56', NULL, NULL, 1, 0, '/user/suggest', 0, 1);
INSERT INTO `autotables` VALUES (21, '社会救助', 'a_shjl', 4, '2019-10-18 17:58:31', '2019-10-18 17:58:31', NULL, NULL, 1, 0, NULL, 0, 1);
INSERT INTO `autotables` VALUES (24, '数据统计', NULL, 14, '2019-10-28 10:37:26', '2019-10-28 10:37:26', NULL, NULL, 1, 1, '/formtable/analyze', 0, 0);
INSERT INTO `autotables` VALUES (46, '房东信息', 'a_fdxx', 1, '2021-05-19 11:20:19', '2021-05-19 11:20:19', NULL, NULL, 1, 0, NULL, 0, 1);
INSERT INTO `autotables` VALUES (47, '优惠政策', 'a_yhzc', 4, '2021-05-19 11:35:47', '2021-05-19 11:35:47', NULL, NULL, 1, 0, NULL, 0, 1);
INSERT INTO `autotables` VALUES (48, '婚姻变动', 'a_hybd', 4, '2021-05-19 11:40:57', '2021-05-19 11:40:57', NULL, NULL, 1, 0, NULL, 0, 1);
INSERT INTO `autotables` VALUES (49, '居民信息管理', 'a_jmxxgl', 29, '2021-05-20 09:45:48', '2021-05-20 09:45:48', NULL, NULL, 1, 0, '/formtable/basic', 25, 1);
INSERT INTO `autotables` VALUES (50, '居民信息迁移', NULL, 29, '2021-05-20 09:45:48', '2021-05-20 09:45:48', NULL, NULL, 1, 1, '/user/move', 25, 0);
INSERT INTO `autotables` VALUES (51, '以户为单位管理', NULL, 29, '2021-05-20 09:45:48', '2021-05-20 09:45:48', NULL, NULL, 1, 1, '/user/homemanage', 25, 0);
INSERT INTO `autotables` VALUES (52, '房东信息', 'a_fdxx', 29, '2021-05-20 09:45:48', '2021-05-20 09:45:48', NULL, NULL, 1, 0, NULL, 25, 1);
INSERT INTO `autotables` VALUES (53, '党员信息管理', 'a_dyxxgl', 30, '2021-05-20 09:45:48', '2021-05-20 09:45:48', NULL, NULL, 1, 0, '/party/partymanage', 25, 1);
INSERT INTO `autotables` VALUES (54, '其它党派管理', 'a_qtdpgl', 30, '2021-05-20 09:45:48', '2021-05-20 09:45:48', NULL, NULL, 1, 0, NULL, 25, 1);
INSERT INTO `autotables` VALUES (55, '育龄妇女管理', 'a_ylfngl', 31, '2021-05-20 09:45:48', '2021-05-20 09:45:48', NULL, NULL, 1, 0, '/user/funvmanage', 25, 1);
INSERT INTO `autotables` VALUES (56, '老龄信息管理', 'a_llxxgl', 32, '2021-05-20 09:45:48', '2021-05-20 09:45:48', NULL, NULL, 1, 0, '/user/oldmanage', 25, 1);
INSERT INTO `autotables` VALUES (57, '现退役管理', 'a_xtygl', 32, '2021-05-20 09:45:48', '2021-05-20 09:45:48', NULL, NULL, 1, 0, '/party/soldier', 25, 1);
INSERT INTO `autotables` VALUES (58, '低保人员管理', 'a_dbrygl', 32, '2021-05-20 09:45:48', '2021-05-20 09:45:48', NULL, NULL, 1, 0, NULL, 25, 1);
INSERT INTO `autotables` VALUES (59, '优抚对象管理', 'a_yfdxgl', 32, '2021-05-20 09:45:49', '2021-05-20 09:45:49', NULL, NULL, 1, 0, NULL, 25, 1);
INSERT INTO `autotables` VALUES (60, '社会救助', 'a_shjl', 32, '2021-05-20 09:45:49', '2021-05-20 09:45:49', NULL, NULL, 1, 0, NULL, 25, 1);
INSERT INTO `autotables` VALUES (61, '优惠政策', 'a_yhzc', 32, '2021-05-20 09:45:49', '2021-05-20 09:45:49', NULL, NULL, 1, 0, NULL, 25, 1);
INSERT INTO `autotables` VALUES (62, '婚姻变动', 'a_hybd', 32, '2021-05-20 09:45:49', '2021-05-20 09:45:49', NULL, NULL, 1, 0, NULL, 25, 1);
INSERT INTO `autotables` VALUES (63, '残疾人管理', 'a_cjrgl', 33, '2021-05-20 09:45:49', '2021-05-20 09:45:49', NULL, NULL, 1, 0, NULL, 25, 1);
INSERT INTO `autotables` VALUES (64, '邪教人员管理', 'a_xjrygl', 34, '2021-05-20 09:45:49', '2021-05-20 09:45:49', NULL, NULL, 1, 0, NULL, 25, 1);
INSERT INTO `autotables` VALUES (65, '重点关注管理', 'a_zdgzgl', 35, '2021-05-20 09:45:49', '2021-05-20 09:45:49', NULL, NULL, 1, 0, NULL, 25, 1);
INSERT INTO `autotables` VALUES (66, '居民社会保险', 'a_jmshbx', 36, '2021-05-20 09:45:49', '2021-05-20 09:45:49', NULL, NULL, 1, 0, NULL, 25, 1);
INSERT INTO `autotables` VALUES (67, '境外人员管理', 'a_jwrygl', 37, '2021-05-20 09:45:49', '2021-05-20 09:45:49', NULL, NULL, 1, 0, NULL, 25, 0);
INSERT INTO `autotables` VALUES (68, '数据统计', NULL, 38, '2021-05-20 09:45:49', '2021-05-20 09:45:49', NULL, NULL, 1, 1, '/formtable/analyze', 25, 0);

-- ----------------------------
-- Table structure for basic
-- ----------------------------
DROP TABLE IF EXISTS `basic`;
CREATE TABLE `basic`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `design` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '设计',
  `bscid` int(11) NULL DEFAULT NULL COMMENT '办事处id',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of basic
-- ----------------------------
INSERT INTO `basic` VALUES (4, 'a:15:{s:8:\"a_jmxxgl\";a:4:{s:4:\"name\";s:12:\"基本信息\";s:6:\"tbname\";s:8:\"a_jmxxgl\";s:4:\"show\";i:1;s:6:\"fields\";a:45:{s:2:\"hh\";a:3:{s:4:\"name\";s:6:\"户号\";s:5:\"field\";s:2:\"hh\";s:7:\"slength\";d:0.25;}s:4:\"jzxz\";a:3:{s:4:\"name\";s:12:\"住户类型\";s:5:\"field\";s:4:\"jzxz\";s:7:\"slength\";d:0.25;}s:2:\"hb\";a:3:{s:4:\"name\";s:12:\"户口性质\";s:5:\"field\";s:2:\"hb\";s:7:\"slength\";d:0.25;}s:5:\"gtgsh\";a:3:{s:4:\"name\";s:15:\"个体工商户\";s:5:\"field\";s:5:\"gtgsh\";s:7:\"slength\";d:0.25;}s:4:\"cslx\";a:3:{s:4:\"name\";s:12:\"厕所类型\";s:5:\"field\";s:4:\"cslx\";s:7:\"slength\";d:0.25;}s:6:\"spaqyh\";a:3:{s:4:\"name\";s:18:\"食品安全隐患\";s:5:\"field\";s:6:\"spaqyh\";s:7:\"slength\";d:0.25;}s:4:\"gnlx\";a:3:{s:4:\"name\";s:12:\"供暖类型\";s:5:\"field\";s:4:\"gnlx\";s:7:\"slength\";d:0.25;}s:4:\"yycl\";a:3:{s:4:\"name\";s:12:\"拥有车辆\";s:5:\"field\";s:4:\"yycl\";s:7:\"slength\";d:0.25;}s:4:\"zfxz\";a:3:{s:4:\"name\";s:12:\"住房性质\";s:5:\"field\";s:4:\"zfxz\";s:7:\"slength\";d:0.25;}s:6:\"jtkncd\";a:3:{s:4:\"name\";s:18:\"家庭困难程度\";s:5:\"field\";s:6:\"jtkncd\";s:7:\"slength\";d:0.25;}s:4:\"lrsj\";a:3:{s:4:\"name\";s:12:\"流入时间\";s:5:\"field\";s:4:\"lrsj\";s:7:\"slength\";d:0.25;}s:4:\"lcsj\";a:3:{s:4:\"name\";s:12:\"流出时间\";s:5:\"field\";s:4:\"lcsj\";s:7:\"slength\";d:0.25;}s:5:\"hjszd\";a:3:{s:4:\"name\";s:12:\"户籍地址\";s:5:\"field\";s:5:\"hjszd\";s:7:\"slength\";d:0.25;}s:4:\"jtzz\";a:3:{s:4:\"name\";s:9:\"现住址\";s:5:\"field\";s:4:\"jtzz\";s:7:\"slength\";d:0.25;}s:4:\"jzlx\";a:3:{s:4:\"name\";s:12:\"是否租户\";s:5:\"field\";s:4:\"jzlx\";s:7:\"slength\";d:0.25;}s:5:\"yhzgx\";a:3:{s:4:\"name\";s:15:\"与户主关系\";s:5:\"field\";s:5:\"yhzgx\";s:7:\"slength\";d:0.25;}s:2:\"xm\";a:3:{s:4:\"name\";s:6:\"姓名\";s:5:\"field\";s:2:\"xm\";s:7:\"slength\";d:0.25;}s:2:\"xb\";a:3:{s:4:\"name\";s:6:\"性别\";s:5:\"field\";s:2:\"xb\";s:7:\"slength\";d:0.25;}s:2:\"mz\";a:3:{s:4:\"name\";s:6:\"民族\";s:5:\"field\";s:2:\"mz\";s:7:\"slength\";d:0.25;}s:4:\"csrq\";a:3:{s:4:\"name\";s:12:\"出生日期\";s:5:\"field\";s:4:\"csrq\";s:7:\"slength\";d:0.25;}s:4:\"sfzh\";a:3:{s:4:\"name\";s:12:\"身份证号\";s:5:\"field\";s:4:\"sfzh\";s:7:\"slength\";d:0.25;}s:4:\"whcd\";a:3:{s:4:\"name\";s:12:\"文化程度\";s:5:\"field\";s:4:\"whcd\";s:7:\"slength\";d:0.25;}s:4:\"yhtc\";a:3:{s:4:\"name\";s:12:\"有何特长\";s:5:\"field\";s:4:\"yhtc\";s:7:\"slength\";i:1;}s:2:\"xx\";a:3:{s:4:\"name\";s:6:\"血型\";s:5:\"field\";s:2:\"xx\";s:7:\"slength\";d:0.25;}s:4:\"zzmm\";a:3:{s:4:\"name\";s:12:\"政治面貌\";s:5:\"field\";s:4:\"zzmm\";s:7:\"slength\";d:0.25;}s:4:\"hyzk\";a:3:{s:4:\"name\";s:12:\"婚姻状况\";s:5:\"field\";s:4:\"hyzk\";s:7:\"slength\";d:0.25;}s:4:\"jhrq\";a:3:{s:4:\"name\";s:12:\"结婚日期\";s:5:\"field\";s:4:\"jhrq\";s:7:\"slength\";d:0.25;}s:4:\"cyzk\";a:3:{s:4:\"name\";s:12:\"从业状况\";s:5:\"field\";s:4:\"cyzk\";s:7:\"slength\";d:0.25;}s:4:\"gzdw\";a:3:{s:4:\"name\";s:12:\"工作单位\";s:5:\"field\";s:4:\"gzdw\";s:7:\"slength\";d:0.25;}s:4:\"sfdy\";a:3:{s:4:\"name\";s:12:\"是否党员\";s:5:\"field\";s:4:\"sfdy\";s:7:\"slength\";d:0.25;}s:5:\"sfyln\";a:3:{s:4:\"name\";s:18:\"是否育龄妇女\";s:5:\"field\";s:5:\"sfyln\";s:7:\"slength\";d:0.25;}s:4:\"sfcj\";a:3:{s:4:\"name\";s:12:\"是否残疾\";s:5:\"field\";s:4:\"sfcj\";s:7:\"slength\";d:0.25;}s:6:\"sfglry\";a:3:{s:4:\"name\";s:18:\"是否高龄人员\";s:5:\"field\";s:6:\"sfglry\";s:7:\"slength\";d:0.25;}s:6:\"jmshbx\";a:3:{s:4:\"name\";s:18:\"居民社会保险\";s:5:\"field\";s:6:\"jmshbx\";s:7:\"slength\";d:0.25;}s:6:\"sfyfdx\";a:3:{s:4:\"name\";s:18:\"是否优抚对象\";s:5:\"field\";s:6:\"sfyfdx\";s:7:\"slength\";d:0.25;}s:4:\"sffy\";a:3:{s:4:\"name\";s:12:\"是否服役\";s:5:\"field\";s:4:\"sffy\";s:7:\"slength\";d:0.25;}s:4:\"yhzc\";a:3:{s:4:\"name\";s:12:\"优惠政策\";s:5:\"field\";s:4:\"yhzc\";s:7:\"slength\";d:0.25;}s:4:\"hybd\";a:3:{s:4:\"name\";s:12:\"婚姻变动\";s:5:\"field\";s:4:\"hybd\";s:7:\"slength\";d:0.25;}s:4:\"sfxj\";a:3:{s:4:\"name\";s:12:\"是否邪教\";s:5:\"field\";s:4:\"sfxj\";s:7:\"slength\";d:0.25;}s:6:\"sfzdgz\";a:3:{s:4:\"name\";s:18:\"是否重点关注\";s:5:\"field\";s:6:\"sfzdgz\";s:7:\"slength\";d:0.25;}s:4:\"lxfs\";a:3:{s:4:\"name\";s:12:\"联系方式\";s:5:\"field\";s:4:\"lxfs\";s:7:\"slength\";d:0.25;}s:2:\"bz\";a:3:{s:4:\"name\";s:6:\"备注\";s:5:\"field\";s:2:\"bz\";s:7:\"slength\";i:1;}s:4:\"shjz\";a:3:{s:4:\"name\";s:12:\"社会救助\";s:5:\"field\";s:4:\"shjz\";s:7:\"slength\";d:0.25;}s:3:\"wgy\";a:3:{s:4:\"name\";s:9:\"网格员\";s:5:\"field\";s:3:\"wgy\";s:7:\"slength\";d:0.25;}s:3:\"zjr\";a:3:{s:4:\"name\";s:9:\"召集人\";s:5:\"field\";s:3:\"zjr\";s:7:\"slength\";d:0.25;}}}s:6:\"a_fdxx\";a:4:{s:4:\"name\";s:12:\"房东信息\";s:6:\"tbname\";s:6:\"a_fdxx\";s:4:\"show\";i:1;s:6:\"fields\";a:8:{s:4:\"fzxm\";a:3:{s:4:\"name\";s:12:\"房主姓名\";s:5:\"field\";s:4:\"fzxm\";s:7:\"slength\";d:0.25;}s:4:\"fzxb\";a:3:{s:4:\"name\";s:12:\"房主性别\";s:5:\"field\";s:4:\"fzxb\";s:7:\"slength\";d:0.25;}s:2:\"mz\";a:3:{s:4:\"name\";s:6:\"民族\";s:5:\"field\";s:2:\"mz\";s:7:\"slength\";d:0.25;}s:2:\"jg\";a:3:{s:4:\"name\";s:6:\"籍贯\";s:5:\"field\";s:2:\"jg\";s:7:\"slength\";d:0.25;}s:4:\"hjdz\";a:3:{s:4:\"name\";s:12:\"户籍地址\";s:5:\"field\";s:4:\"hjdz\";s:7:\"slength\";d:0.25;}s:4:\"sjzz\";a:3:{s:4:\"name\";s:12:\"实际住址\";s:5:\"field\";s:4:\"sjzz\";s:7:\"slength\";d:0.25;}s:5:\"sfzh6\";a:3:{s:4:\"name\";s:12:\"身份证号\";s:5:\"field\";s:5:\"sfzh6\";s:7:\"slength\";d:0.25;}s:4:\"lxdh\";a:3:{s:4:\"name\";s:12:\"联系电话\";s:5:\"field\";s:4:\"lxdh\";s:7:\"slength\";d:0.25;}}}s:8:\"a_dyxxgl\";a:4:{s:4:\"name\";s:12:\"党员情况\";s:6:\"tbname\";s:8:\"a_dyxxgl\";s:4:\"show\";i:1;s:6:\"fields\";a:6:{s:4:\"rdrq\";a:3:{s:4:\"name\";s:12:\"入党日期\";s:5:\"field\";s:4:\"rdrq\";s:7:\"slength\";d:0.25;}s:8:\"dzzgxszd\";a:3:{s:4:\"name\";s:24:\"党组织关系所在地\";s:5:\"field\";s:8:\"dzzgxszd\";s:7:\"slength\";d:0.25;}s:9:\"cjzyzhdqk\";a:3:{s:4:\"name\";s:27:\"参加志愿者活动情况\";s:5:\"field\";s:9:\"cjzyzhdqk\";s:7:\"slength\";d:0.25;}s:2:\"bz\";a:3:{s:4:\"name\";s:6:\"备注\";s:5:\"field\";s:2:\"bz\";s:7:\"slength\";i:1;}s:8:\"sfcjzzsh\";a:3:{s:4:\"name\";s:24:\"是否参加组织生活\";s:5:\"field\";s:8:\"sfcjzzsh\";s:7:\"slength\";d:0.25;}s:4:\"dyqk\";a:3:{s:4:\"name\";s:12:\"党员情况\";s:5:\"field\";s:4:\"dyqk\";s:7:\"slength\";d:0.25;}}}s:8:\"a_qtdpgl\";a:4:{s:4:\"name\";N;s:6:\"tbname\";s:8:\"a_qtdpgl\";s:4:\"show\";i:0;s:6:\"fields\";a:1:{s:4:\"hzdp\";a:3:{s:4:\"name\";s:12:\"何种党派\";s:5:\"field\";s:4:\"hzdp\";s:7:\"slength\";d:0.25;}}}s:8:\"a_ylfngl\";a:4:{s:4:\"name\";s:18:\"育龄妇女情况\";s:6:\"tbname\";s:8:\"a_ylfngl\";s:4:\"show\";i:1;s:6:\"fields\";a:12:{s:4:\"chrq\";a:3:{s:4:\"name\";s:12:\"初婚日期\";s:5:\"field\";s:4:\"chrq\";s:7:\"slength\";d:0.25;}s:6:\"sfsdjt\";a:3:{s:4:\"name\";s:18:\"是否失独家庭\";s:5:\"field\";s:6:\"sfsdjt\";s:7:\"slength\";d:0.25;}s:6:\"syznxm\";a:3:{s:4:\"name\";s:18:\"生育子女姓名\";s:5:\"field\";s:6:\"syznxm\";s:7:\"slength\";d:0.25;}s:6:\"sflset\";a:3:{s:4:\"name\";s:18:\"是否留守儿童\";s:5:\"field\";s:6:\"sflset\";s:7:\"slength\";d:0.25;}s:7:\"cydsznz\";a:3:{s:4:\"name\";s:21:\"持有独生子女证\";s:5:\"field\";s:7:\"cydsznz\";s:7:\"slength\";d:0.25;}s:6:\"dsznzh\";a:3:{s:4:\"name\";s:18:\"独生子女证号\";s:5:\"field\";s:6:\"dsznzh\";s:7:\"slength\";d:0.25;}s:7:\"dbflqqk\";a:3:{s:4:\"name\";s:21:\"独保费领取情况\";s:5:\"field\";s:7:\"dbflqqk\";s:7:\"slength\";d:0.25;}s:4:\"zcsx\";a:3:{s:4:\"name\";s:12:\"政策属性\";s:5:\"field\";s:4:\"zcsx\";s:7:\"slength\";d:0.25;}s:4:\"byzt\";a:3:{s:4:\"name\";s:12:\"避孕状态\";s:5:\"field\";s:4:\"byzt\";s:7:\"slength\";d:0.5;}s:4:\"hyzk\";a:3:{s:4:\"name\";s:12:\"婚姻状况\";s:5:\"field\";s:4:\"hyzk\";s:7:\"slength\";d:0.5;}s:2:\"bz\";a:3:{s:4:\"name\";s:6:\"备注\";s:5:\"field\";s:2:\"bz\";s:7:\"slength\";i:1;}s:4:\"lqrq\";a:3:{s:4:\"name\";s:12:\"领取日期\";s:5:\"field\";s:4:\"lqrq\";s:7:\"slength\";d:0.25;}}}s:8:\"a_llxxgl\";a:4:{s:4:\"name\";s:12:\"高龄人员\";s:6:\"tbname\";s:8:\"a_llxxgl\";s:4:\"show\";i:1;s:6:\"fields\";a:7:{s:6:\"sfkclr\";a:3:{s:4:\"name\";s:18:\"是否空巢老人\";s:5:\"field\";s:6:\"sfkclr\";s:7:\"slength\";d:0.25;}s:4:\"snzt\";a:3:{s:4:\"name\";s:12:\"失能状态\";s:5:\"field\";s:4:\"snzt\";s:7:\"slength\";d:0.25;}s:8:\"glbtlqqk\";a:3:{s:4:\"name\";s:24:\"高龄补贴领取情况\";s:5:\"field\";s:8:\"glbtlqqk\";s:7:\"slength\";d:0.25;}s:15:\"jgsydwqyyljlqqk\";a:3:{s:4:\"name\";s:48:\"机关事业单位、企业养老金领取情况\";s:5:\"field\";s:15:\"jgsydwqyyljlqqk\";s:7:\"slength\";d:0.5;}s:3:\"syr\";a:3:{s:4:\"name\";s:9:\"赡养人\";s:5:\"field\";s:3:\"syr\";s:7:\"slength\";d:0.25;}s:4:\"lxfs\";a:3:{s:4:\"name\";s:12:\"联系方式\";s:5:\"field\";s:4:\"lxfs\";s:7:\"slength\";d:0.25;}s:2:\"bz\";a:3:{s:4:\"name\";s:6:\"备注\";s:5:\"field\";s:2:\"bz\";s:7:\"slength\";i:1;}}}s:7:\"a_xtygl\";a:4:{s:4:\"name\";s:12:\"兵役情况\";s:6:\"tbname\";s:7:\"a_xtygl\";s:4:\"show\";i:1;s:6:\"fields\";a:11:{s:4:\"fyzt\";a:3:{s:4:\"name\";s:12:\"服役状态\";s:5:\"field\";s:4:\"fyzt\";s:7:\"slength\";d:0.25;}s:4:\"rwrq\";a:3:{s:4:\"name\";s:12:\"入伍日期\";s:5:\"field\";s:4:\"rwrq\";s:7:\"slength\";d:0.25;}s:4:\"tyrq\";a:3:{s:4:\"name\";s:12:\"退役日期\";s:5:\"field\";s:4:\"tyrq\";s:7:\"slength\";d:0.25;}s:2:\"jz\";a:3:{s:4:\"name\";s:6:\"军种\";s:5:\"field\";s:2:\"jz\";s:7:\"slength\";d:0.25;}s:3:\"fyd\";a:3:{s:4:\"name\";s:9:\"服役地\";s:5:\"field\";s:3:\"fyd\";s:7:\"slength\";d:0.25;}s:3:\"tyd\";a:3:{s:4:\"name\";s:9:\"退役地\";s:5:\"field\";s:3:\"tyd\";s:7:\"slength\";d:0.25;}s:4:\"qsxm\";a:3:{s:4:\"name\";s:12:\"亲属姓名\";s:5:\"field\";s:4:\"qsxm\";s:7:\"slength\";d:0.25;}s:4:\"lgqk\";a:3:{s:4:\"name\";s:12:\"立功情况\";s:5:\"field\";s:4:\"lgqk\";s:7:\"slength\";d:0.25;}s:6:\"cjmbzz\";a:3:{s:4:\"name\";s:18:\"参加民兵组织\";s:5:\"field\";s:6:\"cjmbzz\";s:7:\"slength\";d:0.25;}s:2:\"nl\";a:3:{s:4:\"name\";s:6:\"年龄\";s:5:\"field\";s:2:\"nl\";s:7:\"slength\";d:0.25;}s:2:\"bz\";a:3:{s:4:\"name\";s:6:\"备注\";s:5:\"field\";s:2:\"bz\";s:7:\"slength\";i:1;}}}s:8:\"a_dbrygl\";a:4:{s:4:\"name\";N;s:6:\"tbname\";s:8:\"a_dbrygl\";s:4:\"show\";i:0;s:6:\"fields\";a:1:{s:6:\"sqdbyy\";a:3:{s:4:\"name\";s:18:\"申请低保原因\";s:5:\"field\";s:6:\"sqdbyy\";s:7:\"slength\";i:1;}}}s:8:\"a_yfdxgl\";a:4:{s:4:\"name\";s:12:\"优抚对象\";s:6:\"tbname\";s:8:\"a_yfdxgl\";s:4:\"show\";i:0;s:6:\"fields\";a:3:{s:4:\"lxfs\";a:3:{s:4:\"name\";s:12:\"联系方式\";s:5:\"field\";s:4:\"lxfs\";s:7:\"slength\";d:0.25;}s:6:\"yfjbqk\";a:3:{s:4:\"name\";s:18:\"优抚基本情况\";s:5:\"field\";s:6:\"yfjbqk\";s:7:\"slength\";d:0.25;}s:2:\"bz\";a:3:{s:4:\"name\";s:6:\"备注\";s:5:\"field\";s:2:\"bz\";s:7:\"slength\";i:1;}}}s:6:\"a_shjl\";a:4:{s:4:\"name\";s:12:\"社会救助\";s:6:\"tbname\";s:6:\"a_shjl\";s:4:\"show\";i:0;s:6:\"fields\";a:6:{s:6:\"xydbrs\";a:3:{s:4:\"name\";s:18:\"享有低保人数\";s:5:\"field\";s:6:\"xydbrs\";s:7:\"slength\";d:0.25;}s:6:\"dbsqyy\";a:3:{s:4:\"name\";s:18:\"低保申请原因\";s:5:\"field\";s:6:\"dbsqyy\";s:7:\"slength\";d:0.25;}s:6:\"lqjzje\";a:3:{s:4:\"name\";s:18:\"领取救助金额\";s:5:\"field\";s:6:\"lqjzje\";s:7:\"slength\";d:0.25;}s:6:\"xymbqk\";a:3:{s:4:\"name\";s:18:\"享有慢保情况\";s:5:\"field\";s:6:\"xymbqk\";s:7:\"slength\";d:0.25;}s:5:\"jtnsr\";a:3:{s:4:\"name\";s:15:\"家庭年收入\";s:5:\"field\";s:5:\"jtnsr\";s:7:\"slength\";d:0.25;}s:2:\"bz\";a:3:{s:4:\"name\";s:6:\"备注\";s:5:\"field\";s:2:\"bz\";s:7:\"slength\";i:1;}}}s:6:\"a_yhzc\";a:4:{s:4:\"name\";s:12:\"优惠政策\";s:6:\"tbname\";s:6:\"a_yhzc\";s:4:\"show\";i:1;s:6:\"fields\";a:3:{s:4:\"zclx\";a:3:{s:4:\"name\";s:12:\"政策类型\";s:5:\"field\";s:4:\"zclx\";s:7:\"slength\";d:0.25;}s:4:\"bzje\";a:3:{s:4:\"name\";s:12:\"补助金额\";s:5:\"field\";s:4:\"bzje\";s:7:\"slength\";d:0.25;}s:6:\"bzsmxx\";a:3:{s:4:\"name\";s:18:\"补助说明信息\";s:5:\"field\";s:6:\"bzsmxx\";s:7:\"slength\";i:1;}}}s:6:\"a_hybd\";a:4:{s:4:\"name\";s:12:\"婚姻变动\";s:6:\"tbname\";s:6:\"a_hybd\";s:4:\"show\";i:1;s:6:\"fields\";a:3:{s:4:\"bdsj\";a:3:{s:4:\"name\";s:12:\"变动时间\";s:5:\"field\";s:4:\"bdsj\";s:7:\"slength\";d:0.25;}s:4:\"bdlx\";a:3:{s:4:\"name\";s:12:\"变动类型\";s:5:\"field\";s:4:\"bdlx\";s:7:\"slength\";d:0.25;}s:4:\"bdsm\";a:3:{s:4:\"name\";s:12:\"变动说明\";s:5:\"field\";s:4:\"bdsm\";s:7:\"slength\";i:1;}}}s:7:\"a_cjrgl\";a:4:{s:4:\"name\";s:9:\"残疾人\";s:6:\"tbname\";s:7:\"a_cjrgl\";s:4:\"show\";i:1;s:6:\"fields\";a:9:{s:4:\"cjlx\";a:3:{s:4:\"name\";s:12:\"残疾类型\";s:5:\"field\";s:4:\"cjlx\";s:7:\"slength\";d:0.25;}s:4:\"cjdj\";a:3:{s:4:\"name\";s:12:\"残疾等级\";s:5:\"field\";s:4:\"cjdj\";s:7:\"slength\";d:0.25;}s:4:\"cjzh\";a:3:{s:4:\"name\";s:12:\"残疾证号\";s:5:\"field\";s:4:\"cjzh\";s:7:\"slength\";d:0.25;}s:7:\"cjzlqsj\";a:3:{s:4:\"name\";s:21:\"残疾证领取时间\";s:5:\"field\";s:7:\"cjzlqsj\";s:7:\"slength\";d:0.25;}s:6:\"sfxydb\";a:3:{s:4:\"name\";s:18:\"是否享有低保\";s:5:\"field\";s:6:\"sfxydb\";s:7:\"slength\";d:0.25;}s:3:\"jhr\";a:3:{s:4:\"name\";s:9:\"监护人\";s:5:\"field\";s:3:\"jhr\";s:7:\"slength\";d:0.25;}s:4:\"lxfs\";a:3:{s:4:\"name\";s:12:\"联系方式\";s:5:\"field\";s:4:\"lxfs\";s:7:\"slength\";d:0.25;}s:2:\"bz\";a:3:{s:4:\"name\";s:6:\"备注\";s:5:\"field\";s:2:\"bz\";s:7:\"slength\";i:1;}s:4:\"sfjd\";a:3:{s:4:\"name\";s:12:\"是否建档\";s:5:\"field\";s:4:\"sfjd\";s:7:\"slength\";d:0.25;}}}s:8:\"a_zdgzgl\";a:4:{s:4:\"name\";s:12:\"重点关注\";s:6:\"tbname\";s:8:\"a_zdgzgl\";s:4:\"show\";i:1;s:6:\"fields\";a:2:{s:4:\"gzyy\";a:3:{s:4:\"name\";s:12:\"关注原因\";s:5:\"field\";s:4:\"gzyy\";s:7:\"slength\";d:0.25;}s:2:\"bz\";a:3:{s:4:\"name\";s:6:\"备注\";s:5:\"field\";s:2:\"bz\";s:7:\"slength\";i:1;}}}s:8:\"a_jmshbx\";a:4:{s:4:\"name\";s:18:\"居民社会保险\";s:6:\"tbname\";s:8:\"a_jmshbx\";s:4:\"show\";i:1;s:6:\"fields\";a:6:{s:9:\"ybfyjnszd\";a:3:{s:4:\"name\";s:27:\"医保费用缴纳所在地\";s:5:\"field\";s:9:\"ybfyjnszd\";s:7:\"slength\";d:0.5;}s:6:\"ybjnqk\";a:3:{s:4:\"name\";s:18:\"医保缴纳情况\";s:5:\"field\";s:6:\"ybjnqk\";s:7:\"slength\";d:0.5;}s:10:\"ylbxjjnszd\";a:3:{s:4:\"name\";s:30:\"养老保险金缴纳所在地\";s:5:\"field\";s:10:\"ylbxjjnszd\";s:7:\"slength\";d:0.5;}s:9:\"ylbxjjnqk\";a:3:{s:4:\"name\";s:27:\"养老保险金缴纳情况\";s:5:\"field\";s:9:\"ylbxjjnqk\";s:7:\"slength\";d:0.5;}s:4:\"yblx\";a:3:{s:4:\"name\";s:12:\"医保类型\";s:5:\"field\";s:4:\"yblx\";s:7:\"slength\";d:0.25;}s:4:\"yllx\";a:3:{s:4:\"name\";s:12:\"养老类型\";s:5:\"field\";s:4:\"yllx\";s:7:\"slength\";d:0.25;}}}}', 0, '2019-10-18 18:40:16', '2022-04-29 10:54:27');
INSERT INTO `basic` VALUES (5, 'a:15:{s:8:\"a_jmxxgl\";a:4:{s:4:\"name\";N;s:6:\"tbname\";s:8:\"a_jmxxgl\";s:4:\"show\";i:1;s:6:\"fields\";a:45:{s:2:\"hh\";a:3:{s:4:\"name\";s:6:\"户号\";s:5:\"field\";s:2:\"hh\";s:7:\"slength\";d:0.25;}s:4:\"jzxz\";a:3:{s:4:\"name\";s:12:\"住户类型\";s:5:\"field\";s:4:\"jzxz\";s:7:\"slength\";d:0.25;}s:2:\"hb\";a:3:{s:4:\"name\";s:12:\"户口性质\";s:5:\"field\";s:2:\"hb\";s:7:\"slength\";d:0.25;}s:5:\"gtgsh\";a:3:{s:4:\"name\";s:15:\"个体工商户\";s:5:\"field\";s:5:\"gtgsh\";s:7:\"slength\";d:0.25;}s:4:\"cslx\";a:3:{s:4:\"name\";s:12:\"厕所类型\";s:5:\"field\";s:4:\"cslx\";s:7:\"slength\";d:0.25;}s:6:\"spaqyh\";a:3:{s:4:\"name\";s:18:\"食品安全隐患\";s:5:\"field\";s:6:\"spaqyh\";s:7:\"slength\";d:0.25;}s:4:\"gnlx\";a:3:{s:4:\"name\";s:12:\"供暖类型\";s:5:\"field\";s:4:\"gnlx\";s:7:\"slength\";d:0.25;}s:4:\"yycl\";a:3:{s:4:\"name\";s:12:\"拥有车辆\";s:5:\"field\";s:4:\"yycl\";s:7:\"slength\";d:0.25;}s:4:\"zfxz\";a:3:{s:4:\"name\";s:12:\"住房性质\";s:5:\"field\";s:4:\"zfxz\";s:7:\"slength\";d:0.25;}s:6:\"jtkncd\";a:3:{s:4:\"name\";s:18:\"家庭困难程度\";s:5:\"field\";s:6:\"jtkncd\";s:7:\"slength\";d:0.25;}s:4:\"lrsj\";a:3:{s:4:\"name\";s:12:\"流入时间\";s:5:\"field\";s:4:\"lrsj\";s:7:\"slength\";d:0.25;}s:4:\"lcsj\";a:3:{s:4:\"name\";s:12:\"流出时间\";s:5:\"field\";s:4:\"lcsj\";s:7:\"slength\";d:0.25;}s:5:\"hjszd\";a:3:{s:4:\"name\";s:12:\"户籍地址\";s:5:\"field\";s:5:\"hjszd\";s:7:\"slength\";d:0.25;}s:4:\"jtzz\";a:3:{s:4:\"name\";s:9:\"现住址\";s:5:\"field\";s:4:\"jtzz\";s:7:\"slength\";d:0.25;}s:4:\"jzlx\";a:3:{s:4:\"name\";s:12:\"是否租户\";s:5:\"field\";s:4:\"jzlx\";s:7:\"slength\";d:0.25;}s:3:\"zjr\";a:3:{s:4:\"name\";s:9:\"召集人\";s:5:\"field\";s:3:\"zjr\";s:7:\"slength\";d:0.25;}s:5:\"yhzgx\";a:3:{s:4:\"name\";s:15:\"与户主关系\";s:5:\"field\";s:5:\"yhzgx\";s:7:\"slength\";d:0.25;}s:2:\"xm\";a:3:{s:4:\"name\";s:6:\"姓名\";s:5:\"field\";s:2:\"xm\";s:7:\"slength\";d:0.25;}s:2:\"xb\";a:3:{s:4:\"name\";s:6:\"性别\";s:5:\"field\";s:2:\"xb\";s:7:\"slength\";d:0.25;}s:2:\"mz\";a:3:{s:4:\"name\";s:6:\"民族\";s:5:\"field\";s:2:\"mz\";s:7:\"slength\";d:0.25;}s:4:\"csrq\";a:3:{s:4:\"name\";s:12:\"出生日期\";s:5:\"field\";s:4:\"csrq\";s:7:\"slength\";d:0.25;}s:4:\"sfzh\";a:3:{s:4:\"name\";s:12:\"身份证号\";s:5:\"field\";s:4:\"sfzh\";s:7:\"slength\";d:0.25;}s:4:\"whcd\";a:3:{s:4:\"name\";s:12:\"文化程度\";s:5:\"field\";s:4:\"whcd\";s:7:\"slength\";d:0.25;}s:4:\"yhtc\";a:3:{s:4:\"name\";s:12:\"有何特长\";s:5:\"field\";s:4:\"yhtc\";s:7:\"slength\";d:0.25;}s:2:\"xx\";a:3:{s:4:\"name\";s:6:\"血型\";s:5:\"field\";s:2:\"xx\";s:7:\"slength\";d:0.25;}s:4:\"zzmm\";a:3:{s:4:\"name\";s:12:\"政治面貌\";s:5:\"field\";s:4:\"zzmm\";s:7:\"slength\";d:0.25;}s:4:\"hyzk\";a:3:{s:4:\"name\";s:12:\"婚姻状况\";s:5:\"field\";s:4:\"hyzk\";s:7:\"slength\";d:0.25;}s:4:\"jhrq\";a:3:{s:4:\"name\";s:12:\"结婚日期\";s:5:\"field\";s:4:\"jhrq\";s:7:\"slength\";d:0.25;}s:4:\"cyzk\";a:3:{s:4:\"name\";s:12:\"从业状况\";s:5:\"field\";s:4:\"cyzk\";s:7:\"slength\";d:0.25;}s:4:\"gzdw\";a:3:{s:4:\"name\";s:12:\"工作单位\";s:5:\"field\";s:4:\"gzdw\";s:7:\"slength\";d:0.25;}s:4:\"sfdy\";a:3:{s:4:\"name\";s:12:\"是否党员\";s:5:\"field\";s:4:\"sfdy\";s:7:\"slength\";d:0.25;}s:5:\"sfyln\";a:3:{s:4:\"name\";s:18:\"是否育龄妇女\";s:5:\"field\";s:5:\"sfyln\";s:7:\"slength\";d:0.25;}s:4:\"sfcj\";a:3:{s:4:\"name\";s:12:\"是否残疾\";s:5:\"field\";s:4:\"sfcj\";s:7:\"slength\";d:0.25;}s:6:\"sfglry\";a:3:{s:4:\"name\";s:18:\"是否高龄人员\";s:5:\"field\";s:6:\"sfglry\";s:7:\"slength\";d:0.25;}s:6:\"jmshbx\";a:3:{s:4:\"name\";s:18:\"居民社会保险\";s:5:\"field\";s:6:\"jmshbx\";s:7:\"slength\";d:0.25;}s:6:\"sfyfdx\";a:3:{s:4:\"name\";s:18:\"是否优抚对象\";s:5:\"field\";s:6:\"sfyfdx\";s:7:\"slength\";d:0.25;}s:4:\"sffy\";a:3:{s:4:\"name\";s:12:\"是否服役\";s:5:\"field\";s:4:\"sffy\";s:7:\"slength\";d:0.25;}s:4:\"sfxj\";a:3:{s:4:\"name\";s:12:\"是否邪教\";s:5:\"field\";s:4:\"sfxj\";s:7:\"slength\";d:0.25;}s:6:\"sfzdgz\";a:3:{s:4:\"name\";s:18:\"是否重点关注\";s:5:\"field\";s:6:\"sfzdgz\";s:7:\"slength\";d:0.25;}s:4:\"lxfs\";a:3:{s:4:\"name\";s:12:\"联系方式\";s:5:\"field\";s:4:\"lxfs\";s:7:\"slength\";d:0.25;}s:2:\"bz\";a:3:{s:4:\"name\";s:6:\"备注\";s:5:\"field\";s:2:\"bz\";s:7:\"slength\";d:0.25;}s:4:\"shjz\";a:3:{s:4:\"name\";s:12:\"社会救助\";s:5:\"field\";s:4:\"shjz\";s:7:\"slength\";d:0.25;}s:4:\"yhzc\";a:3:{s:4:\"name\";s:12:\"优惠政策\";s:5:\"field\";s:4:\"yhzc\";s:7:\"slength\";d:0.25;}s:4:\"hybd\";a:3:{s:4:\"name\";s:12:\"婚姻变动\";s:5:\"field\";s:4:\"hybd\";s:7:\"slength\";d:0.25;}s:3:\"wgy\";a:3:{s:4:\"name\";s:9:\"网格员\";s:5:\"field\";s:3:\"wgy\";s:7:\"slength\";d:0.25;}}}s:6:\"a_fdxx\";a:4:{s:4:\"name\";s:12:\"房东信息\";s:6:\"tbname\";s:6:\"a_fdxx\";s:4:\"show\";i:1;s:6:\"fields\";a:8:{s:4:\"fzxm\";a:3:{s:4:\"name\";s:12:\"房主姓名\";s:5:\"field\";s:4:\"fzxm\";s:7:\"slength\";d:0.25;}s:4:\"fzxb\";a:3:{s:4:\"name\";s:12:\"房主性别\";s:5:\"field\";s:4:\"fzxb\";s:7:\"slength\";d:0.25;}s:2:\"mz\";a:3:{s:4:\"name\";s:6:\"民族\";s:5:\"field\";s:2:\"mz\";s:7:\"slength\";d:0.25;}s:2:\"jg\";a:3:{s:4:\"name\";s:6:\"籍贯\";s:5:\"field\";s:2:\"jg\";s:7:\"slength\";d:0.25;}s:4:\"hjdz\";a:3:{s:4:\"name\";s:12:\"户籍地址\";s:5:\"field\";s:4:\"hjdz\";s:7:\"slength\";d:0.25;}s:4:\"sjzz\";a:3:{s:4:\"name\";s:12:\"实际住址\";s:5:\"field\";s:4:\"sjzz\";s:7:\"slength\";d:0.25;}s:5:\"sfzh6\";a:3:{s:4:\"name\";s:12:\"身份证号\";s:5:\"field\";s:5:\"sfzh6\";s:7:\"slength\";d:0.25;}s:4:\"lxdh\";a:3:{s:4:\"name\";s:12:\"联系电话\";s:5:\"field\";s:4:\"lxdh\";s:7:\"slength\";d:0.25;}}}s:8:\"a_dyxxgl\";a:4:{s:4:\"name\";s:12:\"党员信息\";s:6:\"tbname\";s:8:\"a_dyxxgl\";s:4:\"show\";i:1;s:6:\"fields\";a:6:{s:4:\"rdrq\";a:3:{s:4:\"name\";s:12:\"入党日期\";s:5:\"field\";s:4:\"rdrq\";s:7:\"slength\";d:0.25;}s:8:\"dzzgxszd\";a:3:{s:4:\"name\";s:24:\"党组织关系所在地\";s:5:\"field\";s:8:\"dzzgxszd\";s:7:\"slength\";d:0.25;}s:9:\"cjzyzhdqk\";a:3:{s:4:\"name\";s:27:\"参加志愿者活动情况\";s:5:\"field\";s:9:\"cjzyzhdqk\";s:7:\"slength\";d:0.25;}s:2:\"bz\";a:3:{s:4:\"name\";s:6:\"备注\";s:5:\"field\";s:2:\"bz\";s:7:\"slength\";d:0.25;}s:4:\"dyqk\";a:3:{s:4:\"name\";s:12:\"党员情况\";s:5:\"field\";s:4:\"dyqk\";s:7:\"slength\";d:0.25;}s:8:\"sfcjzzsh\";a:3:{s:4:\"name\";s:24:\"是否参加组织生活\";s:5:\"field\";s:8:\"sfcjzzsh\";s:7:\"slength\";d:0.25;}}}s:8:\"a_qtdpgl\";a:4:{s:4:\"name\";s:12:\"其它党派\";s:6:\"tbname\";s:8:\"a_qtdpgl\";s:4:\"show\";i:1;s:6:\"fields\";a:1:{s:4:\"hzdp\";a:3:{s:4:\"name\";s:12:\"何种党派\";s:5:\"field\";s:4:\"hzdp\";s:7:\"slength\";d:0.25;}}}s:8:\"a_ylfngl\";a:4:{s:4:\"name\";s:12:\"育龄妇女\";s:6:\"tbname\";s:8:\"a_ylfngl\";s:4:\"show\";i:1;s:6:\"fields\";a:12:{s:4:\"chrq\";a:3:{s:4:\"name\";s:12:\"初婚日期\";s:5:\"field\";s:4:\"chrq\";s:7:\"slength\";d:0.25;}s:6:\"sfsdjt\";a:3:{s:4:\"name\";s:18:\"是否失独家庭\";s:5:\"field\";s:6:\"sfsdjt\";s:7:\"slength\";d:0.25;}s:6:\"syznxm\";a:3:{s:4:\"name\";s:18:\"生育子女姓名\";s:5:\"field\";s:6:\"syznxm\";s:7:\"slength\";d:0.25;}s:6:\"sflset\";a:3:{s:4:\"name\";s:18:\"是否留守儿童\";s:5:\"field\";s:6:\"sflset\";s:7:\"slength\";d:0.25;}s:7:\"cydsznz\";a:3:{s:4:\"name\";s:21:\"持有独生子女证\";s:5:\"field\";s:7:\"cydsznz\";s:7:\"slength\";d:0.25;}s:6:\"dsznzh\";a:3:{s:4:\"name\";s:18:\"独生子女证号\";s:5:\"field\";s:6:\"dsznzh\";s:7:\"slength\";d:0.25;}s:7:\"dbflqqk\";a:3:{s:4:\"name\";s:21:\"独保费领取情况\";s:5:\"field\";s:7:\"dbflqqk\";s:7:\"slength\";d:0.25;}s:4:\"zcsx\";a:3:{s:4:\"name\";s:12:\"政策属性\";s:5:\"field\";s:4:\"zcsx\";s:7:\"slength\";d:0.25;}s:4:\"byzt\";a:3:{s:4:\"name\";s:12:\"避孕状态\";s:5:\"field\";s:4:\"byzt\";s:7:\"slength\";d:0.25;}s:4:\"hyzk\";a:3:{s:4:\"name\";s:12:\"婚姻状况\";s:5:\"field\";s:4:\"hyzk\";s:7:\"slength\";d:0.25;}s:2:\"bz\";a:3:{s:4:\"name\";s:6:\"备注\";s:5:\"field\";s:2:\"bz\";s:7:\"slength\";d:0.25;}s:4:\"lqrq\";a:3:{s:4:\"name\";s:12:\"领取日期\";s:5:\"field\";s:4:\"lqrq\";s:7:\"slength\";d:0.25;}}}s:8:\"a_llxxgl\";a:4:{s:4:\"name\";s:12:\"老龄信息\";s:6:\"tbname\";s:8:\"a_llxxgl\";s:4:\"show\";i:1;s:6:\"fields\";a:7:{s:6:\"sfkclr\";a:3:{s:4:\"name\";s:18:\"是否空巢老人\";s:5:\"field\";s:6:\"sfkclr\";s:7:\"slength\";d:0.25;}s:4:\"snzt\";a:3:{s:4:\"name\";s:12:\"失能状态\";s:5:\"field\";s:4:\"snzt\";s:7:\"slength\";d:0.25;}s:8:\"glbtlqqk\";a:3:{s:4:\"name\";s:24:\"高龄补贴领取情况\";s:5:\"field\";s:8:\"glbtlqqk\";s:7:\"slength\";d:0.25;}s:15:\"jgsydwqyyljlqqk\";a:3:{s:4:\"name\";s:48:\"机关事业单位、企业养老金领取情况\";s:5:\"field\";s:15:\"jgsydwqyyljlqqk\";s:7:\"slength\";d:0.25;}s:3:\"syr\";a:3:{s:4:\"name\";s:9:\"赡养人\";s:5:\"field\";s:3:\"syr\";s:7:\"slength\";d:0.25;}s:4:\"lxfs\";a:3:{s:4:\"name\";s:12:\"联系方式\";s:5:\"field\";s:4:\"lxfs\";s:7:\"slength\";d:0.25;}s:2:\"bz\";a:3:{s:4:\"name\";s:6:\"备注\";s:5:\"field\";s:2:\"bz\";s:7:\"slength\";d:0.25;}}}s:7:\"a_xtygl\";a:4:{s:4:\"name\";s:9:\"现退役\";s:6:\"tbname\";s:7:\"a_xtygl\";s:4:\"show\";i:1;s:6:\"fields\";a:11:{s:4:\"fyzt\";a:3:{s:4:\"name\";s:12:\"服役状态\";s:5:\"field\";s:4:\"fyzt\";s:7:\"slength\";d:0.25;}s:4:\"rwrq\";a:3:{s:4:\"name\";s:12:\"入伍日期\";s:5:\"field\";s:4:\"rwrq\";s:7:\"slength\";d:0.25;}s:4:\"tyrq\";a:3:{s:4:\"name\";s:12:\"退役日期\";s:5:\"field\";s:4:\"tyrq\";s:7:\"slength\";d:0.25;}s:2:\"jz\";a:3:{s:4:\"name\";s:6:\"军种\";s:5:\"field\";s:2:\"jz\";s:7:\"slength\";d:0.25;}s:3:\"fyd\";a:3:{s:4:\"name\";s:9:\"服役地\";s:5:\"field\";s:3:\"fyd\";s:7:\"slength\";d:0.25;}s:3:\"tyd\";a:3:{s:4:\"name\";s:9:\"退役地\";s:5:\"field\";s:3:\"tyd\";s:7:\"slength\";d:0.25;}s:4:\"qsxm\";a:3:{s:4:\"name\";s:12:\"亲属姓名\";s:5:\"field\";s:4:\"qsxm\";s:7:\"slength\";d:0.25;}s:4:\"lgqk\";a:3:{s:4:\"name\";s:12:\"立功情况\";s:5:\"field\";s:4:\"lgqk\";s:7:\"slength\";d:0.25;}s:6:\"cjmbzz\";a:3:{s:4:\"name\";s:18:\"参加民兵组织\";s:5:\"field\";s:6:\"cjmbzz\";s:7:\"slength\";d:0.25;}s:2:\"nl\";a:3:{s:4:\"name\";s:6:\"年龄\";s:5:\"field\";s:2:\"nl\";s:7:\"slength\";d:0.25;}s:2:\"bz\";a:3:{s:4:\"name\";s:6:\"备注\";s:5:\"field\";s:2:\"bz\";s:7:\"slength\";d:0.25;}}}s:8:\"a_dbrygl\";a:4:{s:4:\"name\";s:12:\"低保人员\";s:6:\"tbname\";s:8:\"a_dbrygl\";s:4:\"show\";i:1;s:6:\"fields\";a:1:{s:6:\"sqdbyy\";a:3:{s:4:\"name\";s:18:\"申请低保原因\";s:5:\"field\";s:6:\"sqdbyy\";s:7:\"slength\";d:0.25;}}}s:8:\"a_yfdxgl\";a:4:{s:4:\"name\";s:12:\"优抚对象\";s:6:\"tbname\";s:8:\"a_yfdxgl\";s:4:\"show\";i:1;s:6:\"fields\";a:3:{s:4:\"lxfs\";a:3:{s:4:\"name\";s:12:\"联系方式\";s:5:\"field\";s:4:\"lxfs\";s:7:\"slength\";d:0.25;}s:6:\"yfjbqk\";a:3:{s:4:\"name\";s:18:\"优抚基本情况\";s:5:\"field\";s:6:\"yfjbqk\";s:7:\"slength\";d:0.25;}s:2:\"bz\";a:3:{s:4:\"name\";s:6:\"备注\";s:5:\"field\";s:2:\"bz\";s:7:\"slength\";d:0.25;}}}s:6:\"a_shjl\";a:4:{s:4:\"name\";s:12:\"社会救助\";s:6:\"tbname\";s:6:\"a_shjl\";s:4:\"show\";i:1;s:6:\"fields\";a:6:{s:6:\"xydbrs\";a:3:{s:4:\"name\";s:18:\"享有低保人数\";s:5:\"field\";s:6:\"xydbrs\";s:7:\"slength\";d:0.25;}s:6:\"dbsqyy\";a:3:{s:4:\"name\";s:18:\"低保申请原因\";s:5:\"field\";s:6:\"dbsqyy\";s:7:\"slength\";d:0.25;}s:6:\"lqjzje\";a:3:{s:4:\"name\";s:18:\"领取救助金额\";s:5:\"field\";s:6:\"lqjzje\";s:7:\"slength\";d:0.25;}s:6:\"xymbqk\";a:3:{s:4:\"name\";s:18:\"享有慢保情况\";s:5:\"field\";s:6:\"xymbqk\";s:7:\"slength\";d:0.25;}s:5:\"jtnsr\";a:3:{s:4:\"name\";s:15:\"家庭年收入\";s:5:\"field\";s:5:\"jtnsr\";s:7:\"slength\";d:0.25;}s:2:\"bz\";a:3:{s:4:\"name\";s:6:\"备注\";s:5:\"field\";s:2:\"bz\";s:7:\"slength\";d:0.25;}}}s:6:\"a_yhzc\";a:4:{s:4:\"name\";s:12:\"优惠政策\";s:6:\"tbname\";s:6:\"a_yhzc\";s:4:\"show\";i:1;s:6:\"fields\";a:3:{s:4:\"zclx\";a:3:{s:4:\"name\";s:12:\"政策类型\";s:5:\"field\";s:4:\"zclx\";s:7:\"slength\";d:0.25;}s:4:\"bzje\";a:3:{s:4:\"name\";s:12:\"补助金额\";s:5:\"field\";s:4:\"bzje\";s:7:\"slength\";d:0.25;}s:6:\"bzsmxx\";a:3:{s:4:\"name\";s:18:\"补助说明信息\";s:5:\"field\";s:6:\"bzsmxx\";s:7:\"slength\";d:0.25;}}}s:6:\"a_hybd\";a:4:{s:4:\"name\";s:12:\"婚姻变动\";s:6:\"tbname\";s:6:\"a_hybd\";s:4:\"show\";i:1;s:6:\"fields\";a:3:{s:4:\"bdsj\";a:3:{s:4:\"name\";s:12:\"变动时间\";s:5:\"field\";s:4:\"bdsj\";s:7:\"slength\";d:0.25;}s:4:\"bdlx\";a:3:{s:4:\"name\";s:12:\"变动类型\";s:5:\"field\";s:4:\"bdlx\";s:7:\"slength\";d:0.25;}s:4:\"bdsm\";a:3:{s:4:\"name\";s:12:\"变动说明\";s:5:\"field\";s:4:\"bdsm\";s:7:\"slength\";d:0.25;}}}s:7:\"a_cjrgl\";a:4:{s:4:\"name\";s:9:\"残疾人\";s:6:\"tbname\";s:7:\"a_cjrgl\";s:4:\"show\";i:1;s:6:\"fields\";a:9:{s:4:\"cjlx\";a:3:{s:4:\"name\";s:12:\"残疾类型\";s:5:\"field\";s:4:\"cjlx\";s:7:\"slength\";d:0.25;}s:4:\"cjdj\";a:3:{s:4:\"name\";s:12:\"残疾等级\";s:5:\"field\";s:4:\"cjdj\";s:7:\"slength\";d:0.25;}s:4:\"cjzh\";a:3:{s:4:\"name\";s:12:\"残疾证号\";s:5:\"field\";s:4:\"cjzh\";s:7:\"slength\";d:0.25;}s:7:\"cjzlqsj\";a:3:{s:4:\"name\";s:21:\"残疾证领取时间\";s:5:\"field\";s:7:\"cjzlqsj\";s:7:\"slength\";d:0.25;}s:6:\"sfxydb\";a:3:{s:4:\"name\";s:18:\"是否享有低保\";s:5:\"field\";s:6:\"sfxydb\";s:7:\"slength\";d:0.25;}s:3:\"jhr\";a:3:{s:4:\"name\";s:9:\"监护人\";s:5:\"field\";s:3:\"jhr\";s:7:\"slength\";d:0.25;}s:4:\"lxfs\";a:3:{s:4:\"name\";s:12:\"联系方式\";s:5:\"field\";s:4:\"lxfs\";s:7:\"slength\";d:0.25;}s:2:\"bz\";a:3:{s:4:\"name\";s:6:\"备注\";s:5:\"field\";s:2:\"bz\";s:7:\"slength\";d:0.25;}s:4:\"sfjd\";a:3:{s:4:\"name\";s:12:\"是否建档\";s:5:\"field\";s:4:\"sfjd\";s:7:\"slength\";d:0.25;}}}s:8:\"a_zdgzgl\";a:4:{s:4:\"name\";s:12:\"重点关注\";s:6:\"tbname\";s:8:\"a_zdgzgl\";s:4:\"show\";i:1;s:6:\"fields\";a:2:{s:4:\"gzyy\";a:3:{s:4:\"name\";s:12:\"关注原因\";s:5:\"field\";s:4:\"gzyy\";s:7:\"slength\";d:0.25;}s:2:\"bz\";a:3:{s:4:\"name\";s:6:\"备注\";s:5:\"field\";s:2:\"bz\";s:7:\"slength\";d:0.25;}}}s:8:\"a_jmshbx\";a:4:{s:4:\"name\";s:18:\"居民社会保险\";s:6:\"tbname\";s:8:\"a_jmshbx\";s:4:\"show\";i:1;s:6:\"fields\";a:6:{s:9:\"ybfyjnszd\";a:3:{s:4:\"name\";s:27:\"医保费用缴纳所在地\";s:5:\"field\";s:9:\"ybfyjnszd\";s:7:\"slength\";d:0.25;}s:6:\"ybjnqk\";a:3:{s:4:\"name\";s:18:\"医保缴纳情况\";s:5:\"field\";s:6:\"ybjnqk\";s:7:\"slength\";d:0.25;}s:10:\"ylbxjjnszd\";a:3:{s:4:\"name\";s:30:\"养老保险金缴纳所在地\";s:5:\"field\";s:10:\"ylbxjjnszd\";s:7:\"slength\";d:0.25;}s:9:\"ylbxjjnqk\";a:3:{s:4:\"name\";s:27:\"养老保险金缴纳情况\";s:5:\"field\";s:9:\"ylbxjjnqk\";s:7:\"slength\";d:0.25;}s:4:\"yblx\";a:3:{s:4:\"name\";s:12:\"医保类型\";s:5:\"field\";s:4:\"yblx\";s:7:\"slength\";d:0.25;}s:4:\"yllx\";a:3:{s:4:\"name\";s:12:\"养老类型\";s:5:\"field\";s:4:\"yllx\";s:7:\"slength\";d:0.25;}}}}', 25, '2022-05-13 15:03:18', '2022-05-13 15:08:50');

-- ----------------------------
-- Table structure for contents
-- ----------------------------
DROP TABLE IF EXISTS `contents`;
CREATE TABLE `contents`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '背景',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '名称',
  `showorder` int(10) NULL DEFAULT NULL COMMENT '显示顺序',
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `type` int(1) NULL DEFAULT NULL COMMENT '1-办事指南，2-社区简介',
  `oid` int(11) NULL DEFAULT NULL COMMENT '社区id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of contents
-- ----------------------------

-- ----------------------------
-- Table structure for migrations
-- ----------------------------
DROP TABLE IF EXISTS `migrations`;
CREATE TABLE `migrations`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of migrations
-- ----------------------------
INSERT INTO `migrations` VALUES (1, '2014_10_12_000000_create_users_table', 1);
INSERT INTO `migrations` VALUES (2, '2014_10_12_100000_create_password_resets_table', 1);
INSERT INTO `migrations` VALUES (3, '2019_03_16_102314_add_simple_role_to_user_table', 1);
INSERT INTO `migrations` VALUES (4, '2019_04_20_125200_create_permission_tables', 1);
INSERT INTO `migrations` VALUES (5, '2019_04_20_130706_setup_role_permissions', 1);

-- ----------------------------
-- Table structure for model_has_permissions
-- ----------------------------
DROP TABLE IF EXISTS `model_has_permissions`;
CREATE TABLE `model_has_permissions`  (
  `permission_id` int(10) UNSIGNED NOT NULL,
  `model_type` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL,
  PRIMARY KEY (`permission_id`, `model_id`, `model_type`) USING BTREE,
  INDEX `model_has_permissions_model_id_model_type_index`(`model_id`, `model_type`) USING BTREE,
  CONSTRAINT `model_has_permissions_ibfk_1` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of model_has_permissions
-- ----------------------------

-- ----------------------------
-- Table structure for model_has_roles
-- ----------------------------
DROP TABLE IF EXISTS `model_has_roles`;
CREATE TABLE `model_has_roles`  (
  `role_id` int(10) UNSIGNED NOT NULL,
  `model_type` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL,
  PRIMARY KEY (`role_id`, `model_id`, `model_type`) USING BTREE,
  INDEX `model_has_roles_model_id_model_type_index`(`model_id`, `model_type`) USING BTREE,
  CONSTRAINT `model_has_roles_ibfk_1` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of model_has_roles
-- ----------------------------
INSERT INTO `model_has_roles` VALUES (1, 'App\\Laravue\\Models\\User', 1);
INSERT INTO `model_has_roles` VALUES (6, 'App\\Laravue\\Models\\User', 80);
INSERT INTO `model_has_roles` VALUES (8, 'App\\Laravue\\Models\\User', 81);

-- ----------------------------
-- Table structure for operatorlog
-- ----------------------------
DROP TABLE IF EXISTS `operatorlog`;
CREATE TABLE `operatorlog`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NULL DEFAULT NULL,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '操作类型',
  `msg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '操作说明',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of operatorlog
-- ----------------------------

-- ----------------------------
-- Table structure for orgs
-- ----------------------------
DROP TABLE IF EXISTS `orgs`;
CREATE TABLE `orgs`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `pid` int(11) NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `ord` int(1) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 28 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of orgs
-- ----------------------------
INSERT INTO `orgs` VALUES (25, '街道办事处', NULL, 0, '2021-05-20 09:45:48', '2021-05-20 09:45:48', NULL);
INSERT INTO `orgs` VALUES (27, '社区', NULL, 25, '2021-05-20 09:53:18', '2022-05-06 09:55:46', NULL);

-- ----------------------------
-- Table structure for password_resets
-- ----------------------------
DROP TABLE IF EXISTS `password_resets`;
CREATE TABLE `password_resets`  (
  `email` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  INDEX `password_resets_email_index`(`email`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of password_resets
-- ----------------------------

-- ----------------------------
-- Table structure for permissions
-- ----------------------------
DROP TABLE IF EXISTS `permissions`;
CREATE TABLE `permissions`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '地址',
  `guard_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `type` int(1) NULL DEFAULT 0 COMMENT '0-页面权限，1-功能权限',
  `bscid` int(11) NULL DEFAULT 0 COMMENT '办事处id',
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '权限名称',
  `left` int(255) NULL DEFAULT NULL,
  `right` int(255) NULL DEFAULT NULL,
  `note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '备注',
  `showindex` int(255) NULL DEFAULT NULL COMMENT '显示顺序',
  `pid` int(11) NULL DEFAULT NULL,
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 39 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of permissions
-- ----------------------------
INSERT INTO `permissions` VALUES (1, NULL, 'api', '2019-10-15 16:24:11', '2019-10-17 10:03:22', 0, 0, '居民管理', NULL, NULL, NULL, 1, NULL, 'jumin');
INSERT INTO `permissions` VALUES (2, NULL, 'api', '2019-10-15 16:25:05', '2019-10-17 10:30:41', 0, 0, '党员管理', NULL, NULL, NULL, 2, NULL, 'dangyuan');
INSERT INTO `permissions` VALUES (3, NULL, 'api', '2019-10-15 16:25:19', '2019-10-17 10:30:54', 0, 0, '计生管理', NULL, NULL, NULL, 3, NULL, 'yuling');
INSERT INTO `permissions` VALUES (4, NULL, 'api', '2019-10-15 16:25:30', '2019-10-17 10:31:10', 0, 0, '民政类管理', NULL, NULL, NULL, 4, NULL, 'minzheng');
INSERT INTO `permissions` VALUES (5, NULL, 'api', '2019-10-15 16:25:56', '2019-10-17 10:31:18', 0, 0, '残联类管理', NULL, NULL, NULL, 5, NULL, 'canjiren');
INSERT INTO `permissions` VALUES (8, NULL, 'api', '2019-10-15 16:26:31', '2019-10-17 10:32:20', 0, 0, '重点管理', NULL, NULL, NULL, 8, NULL, 'zhongdian');
INSERT INTO `permissions` VALUES (9, NULL, 'api', '2019-10-15 16:26:44', '2019-10-17 10:04:13', 0, 0, '劳动保障管理', NULL, NULL, NULL, 9, NULL, 'baoxian');
INSERT INTO `permissions` VALUES (14, NULL, 'api', '2019-10-28 10:36:49', '2019-10-28 10:36:49', 0, 0, '数据统计', NULL, NULL, NULL, 14, NULL, 'analyze');
INSERT INTO `permissions` VALUES (29, NULL, 'api', '2021-05-20 09:45:48', '2021-05-20 09:45:48', 0, 25, '居民管理', NULL, NULL, NULL, 1, NULL, NULL);
INSERT INTO `permissions` VALUES (30, NULL, 'api', '2021-05-20 09:45:48', '2021-05-20 09:45:48', 0, 25, '党员管理', NULL, NULL, NULL, 2, NULL, NULL);
INSERT INTO `permissions` VALUES (31, NULL, 'api', '2021-05-20 09:45:48', '2021-05-20 09:45:48', 0, 25, '计生管理', NULL, NULL, NULL, 3, NULL, NULL);
INSERT INTO `permissions` VALUES (32, NULL, 'api', '2021-05-20 09:45:48', '2021-05-20 09:45:48', 0, 25, '民政类管理', NULL, NULL, NULL, 4, NULL, NULL);
INSERT INTO `permissions` VALUES (33, NULL, 'api', '2021-05-20 09:45:49', '2021-05-20 09:45:49', 0, 25, '残联类管理', NULL, NULL, NULL, 5, NULL, NULL);
INSERT INTO `permissions` VALUES (35, NULL, 'api', '2021-05-20 09:45:49', '2021-05-20 09:45:49', 0, 25, '重点管理', NULL, NULL, NULL, 8, NULL, NULL);
INSERT INTO `permissions` VALUES (36, NULL, 'api', '2021-05-20 09:45:49', '2021-05-20 09:45:49', 0, 25, '劳动保障管理', NULL, NULL, NULL, 9, NULL, NULL);
INSERT INTO `permissions` VALUES (38, NULL, 'api', '2021-05-20 09:45:49', '2021-05-20 09:45:49', 0, 25, '数据统计', NULL, NULL, NULL, 14, NULL, NULL);

-- ----------------------------
-- Table structure for printlog
-- ----------------------------
DROP TABLE IF EXISTS `printlog`;
CREATE TABLE `printlog`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NULL DEFAULT NULL COMMENT '打印人id',
  `dataid` int(11) NULL DEFAULT NULL COMMENT '数据表id',
  `xm` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '姓名',
  `type` int(1) NULL DEFAULT NULL COMMENT '1-租住证明，2-居住证明',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `ptype` int(1) NULL DEFAULT NULL COMMENT '1-后台，2-终端机',
  `jsondata` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT 'json数组',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of printlog
-- ----------------------------

-- ----------------------------
-- Table structure for role_has_permissions
-- ----------------------------
DROP TABLE IF EXISTS `role_has_permissions`;
CREATE TABLE `role_has_permissions`  (
  `permission_id` int(10) UNSIGNED NOT NULL,
  `role_id` int(10) UNSIGNED NOT NULL,
  PRIMARY KEY (`permission_id`, `role_id`) USING BTREE,
  INDEX `role_has_permissions_role_id_foreign`(`role_id`) USING BTREE,
  CONSTRAINT `role_has_permissions_ibfk_1` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `role_has_permissions_ibfk_2` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of role_has_permissions
-- ----------------------------

-- ----------------------------
-- Table structure for roles
-- ----------------------------
DROP TABLE IF EXISTS `roles`;
CREATE TABLE `roles`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'admin,bsc-办事处,sq-社区,manage-管理者',
  `guard_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `sname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `uid` int(11) NULL DEFAULT NULL,
  `bscid` int(11) NULL DEFAULT 0,
  `permis` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  `ids` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of roles
-- ----------------------------
INSERT INTO `roles` VALUES (1, 'admin', 'api', '2019-06-12 06:06:25', '2019-06-12 06:06:25', NULL, '超级管理员', NULL, 0, NULL, NULL);
INSERT INTO `roles` VALUES (6, 'bsc', 'api', '2019-10-30 10:15:10', '2022-05-13 14:48:18', NULL, '办事处', NULL, 0, '[{\"id\":1,\"title\":\"居民管理\",\"icon\":\"jumin\",\"children\":[{\"id\":\"1_1\",\"title\":\"居民信息管理\",\"tbname\":\"a_jmxxgl\",\"type\":0,\"url\":\"/formtable/basic\",\"children\":[{\"id\":\"1_1_edit\",\"title\":\"居民信息管理_添加/编辑\",\"url\":\"a_jmxxgl_edit\"},{\"id\":\"1_1_delete\",\"title\":\"居民信息管理_删除\",\"url\":\"a_jmxxgl_delete\"}]},{\"id\":\"1_2\",\"title\":\"居民信息迁移\",\"tbname\":null,\"type\":1,\"url\":\"/user/move\"},{\"id\":\"1_3\",\"title\":\"以户为单位管理\",\"tbname\":null,\"type\":1,\"url\":\"/user/homemanage\"},{\"id\":\"1_46\",\"title\":\"房东信息\",\"tbname\":\"a_fdxx\",\"type\":0,\"url\":\"/formtable/manage/a_fdxx\",\"children\":[{\"id\":\"1_46_edit\",\"title\":\"房东信息_添加/编辑\",\"url\":\"a_fdxx_edit\"},{\"id\":\"1_46_delete\",\"title\":\"房东信息_删除\",\"url\":\"a_fdxx_delete\"}]}]},{\"id\":\"1_1\",\"title\":\"居民信息管理\",\"tbname\":\"a_jmxxgl\",\"type\":0,\"url\":\"/formtable/basic\",\"children\":[{\"id\":\"1_1_edit\",\"title\":\"居民信息管理_添加/编辑\",\"url\":\"a_jmxxgl_edit\"},{\"id\":\"1_1_delete\",\"title\":\"居民信息管理_删除\",\"url\":\"a_jmxxgl_delete\"}]},{\"id\":\"1_1_edit\",\"title\":\"居民信息管理_添加/编辑\",\"url\":\"a_jmxxgl_edit\"},{\"id\":\"1_1_delete\",\"title\":\"居民信息管理_删除\",\"url\":\"a_jmxxgl_delete\"},{\"id\":\"1_2\",\"title\":\"居民信息迁移\",\"tbname\":null,\"type\":1,\"url\":\"/user/move\"},{\"id\":\"1_3\",\"title\":\"以户为单位管理\",\"tbname\":null,\"type\":1,\"url\":\"/user/homemanage\"},{\"id\":\"1_46\",\"title\":\"房东信息\",\"tbname\":\"a_fdxx\",\"type\":0,\"url\":\"/formtable/manage/a_fdxx\",\"children\":[{\"id\":\"1_46_edit\",\"title\":\"房东信息_添加/编辑\",\"url\":\"a_fdxx_edit\"},{\"id\":\"1_46_delete\",\"title\":\"房东信息_删除\",\"url\":\"a_fdxx_delete\"}]},{\"id\":\"1_46_edit\",\"title\":\"房东信息_添加/编辑\",\"url\":\"a_fdxx_edit\"},{\"id\":\"1_46_delete\",\"title\":\"房东信息_删除\",\"url\":\"a_fdxx_delete\"},{\"id\":2,\"title\":\"党员管理\",\"icon\":\"dangyuan\",\"children\":[{\"id\":\"2_4\",\"title\":\"党员信息管理\",\"tbname\":\"a_dyxxgl\",\"type\":0,\"url\":\"/party/partymanage\",\"children\":[{\"id\":\"2_4_edit\",\"title\":\"党员信息管理_添加/编辑\",\"url\":\"a_dyxxgl_edit\"},{\"id\":\"2_4_delete\",\"title\":\"党员信息管理_删除\",\"url\":\"a_dyxxgl_delete\"}]},{\"id\":\"2_5\",\"title\":\"其它党派管理\",\"tbname\":\"a_qtdpgl\",\"type\":0,\"url\":\"/formtable/manage/a_qtdpgl\",\"children\":[{\"id\":\"2_5_edit\",\"title\":\"其它党派管理_添加/编辑\",\"url\":\"a_qtdpgl_edit\"},{\"id\":\"2_5_delete\",\"title\":\"其它党派管理_删除\",\"url\":\"a_qtdpgl_delete\"}]}]},{\"id\":\"2_4\",\"title\":\"党员信息管理\",\"tbname\":\"a_dyxxgl\",\"type\":0,\"url\":\"/party/partymanage\",\"children\":[{\"id\":\"2_4_edit\",\"title\":\"党员信息管理_添加/编辑\",\"url\":\"a_dyxxgl_edit\"},{\"id\":\"2_4_delete\",\"title\":\"党员信息管理_删除\",\"url\":\"a_dyxxgl_delete\"}]},{\"id\":\"2_4_edit\",\"title\":\"党员信息管理_添加/编辑\",\"url\":\"a_dyxxgl_edit\"},{\"id\":\"2_4_delete\",\"title\":\"党员信息管理_删除\",\"url\":\"a_dyxxgl_delete\"},{\"id\":\"2_5\",\"title\":\"其它党派管理\",\"tbname\":\"a_qtdpgl\",\"type\":0,\"url\":\"/formtable/manage/a_qtdpgl\",\"children\":[{\"id\":\"2_5_edit\",\"title\":\"其它党派管理_添加/编辑\",\"url\":\"a_qtdpgl_edit\"},{\"id\":\"2_5_delete\",\"title\":\"其它党派管理_删除\",\"url\":\"a_qtdpgl_delete\"}]},{\"id\":\"2_5_edit\",\"title\":\"其它党派管理_添加/编辑\",\"url\":\"a_qtdpgl_edit\"},{\"id\":\"2_5_delete\",\"title\":\"其它党派管理_删除\",\"url\":\"a_qtdpgl_delete\"},{\"id\":3,\"title\":\"计生管理\",\"icon\":\"yuling\",\"children\":[{\"id\":\"3_6\",\"title\":\"育龄妇女管理\",\"tbname\":\"a_ylfngl\",\"type\":0,\"url\":\"/user/funvmanage\",\"children\":[{\"id\":\"3_6_edit\",\"title\":\"育龄妇女管理_添加/编辑\",\"url\":\"a_ylfngl_edit\"},{\"id\":\"3_6_delete\",\"title\":\"育龄妇女管理_删除\",\"url\":\"a_ylfngl_delete\"}]}]},{\"id\":\"3_6\",\"title\":\"育龄妇女管理\",\"tbname\":\"a_ylfngl\",\"type\":0,\"url\":\"/user/funvmanage\",\"children\":[{\"id\":\"3_6_edit\",\"title\":\"育龄妇女管理_添加/编辑\",\"url\":\"a_ylfngl_edit\"},{\"id\":\"3_6_delete\",\"title\":\"育龄妇女管理_删除\",\"url\":\"a_ylfngl_delete\"}]},{\"id\":\"3_6_edit\",\"title\":\"育龄妇女管理_添加/编辑\",\"url\":\"a_ylfngl_edit\"},{\"id\":\"3_6_delete\",\"title\":\"育龄妇女管理_删除\",\"url\":\"a_ylfngl_delete\"},{\"id\":4,\"title\":\"民政类管理\",\"icon\":\"minzheng\",\"children\":[{\"id\":\"4_8\",\"title\":\"老龄信息管理\",\"tbname\":\"a_llxxgl\",\"type\":0,\"url\":\"/user/oldmanage\",\"children\":[{\"id\":\"4_8_edit\",\"title\":\"老龄信息管理_添加/编辑\",\"url\":\"a_llxxgl_edit\"},{\"id\":\"4_8_delete\",\"title\":\"老龄信息管理_删除\",\"url\":\"a_llxxgl_delete\"}]},{\"id\":\"4_9\",\"title\":\"现退役管理\",\"tbname\":\"a_xtygl\",\"type\":0,\"url\":\"/party/soldier\",\"children\":[{\"id\":\"4_9_edit\",\"title\":\"现退役管理_添加/编辑\",\"url\":\"a_xtygl_edit\"},{\"id\":\"4_9_delete\",\"title\":\"现退役管理_删除\",\"url\":\"a_xtygl_delete\"}]},{\"id\":\"4_10\",\"title\":\"低保人员管理\",\"tbname\":\"a_dbrygl\",\"type\":0,\"url\":\"/formtable/manage/a_dbrygl\",\"children\":[{\"id\":\"4_10_edit\",\"title\":\"低保人员管理_添加/编辑\",\"url\":\"a_dbrygl_edit\"},{\"id\":\"4_10_delete\",\"title\":\"低保人员管理_删除\",\"url\":\"a_dbrygl_delete\"}]},{\"id\":\"4_11\",\"title\":\"优抚对象管理\",\"tbname\":\"a_yfdxgl\",\"type\":0,\"url\":\"/formtable/manage/a_yfdxgl\",\"children\":[{\"id\":\"4_11_edit\",\"title\":\"优抚对象管理_添加/编辑\",\"url\":\"a_yfdxgl_edit\"},{\"id\":\"4_11_delete\",\"title\":\"优抚对象管理_删除\",\"url\":\"a_yfdxgl_delete\"}]},{\"id\":\"4_21\",\"title\":\"社会救助\",\"tbname\":\"a_shjl\",\"type\":0,\"url\":\"/formtable/manage/a_shjl\",\"children\":[{\"id\":\"4_21_edit\",\"title\":\"社会救助_添加/编辑\",\"url\":\"a_shjl_edit\"},{\"id\":\"4_21_delete\",\"title\":\"社会救助_删除\",\"url\":\"a_shjl_delete\"}]},{\"id\":\"4_47\",\"title\":\"优惠政策\",\"tbname\":\"a_yhzc\",\"type\":0,\"url\":\"/formtable/manage/a_yhzc\",\"children\":[{\"id\":\"4_47_edit\",\"title\":\"优惠政策_添加/编辑\",\"url\":\"a_yhzc_edit\"},{\"id\":\"4_47_delete\",\"title\":\"优惠政策_删除\",\"url\":\"a_yhzc_delete\"}]},{\"id\":\"4_48\",\"title\":\"婚姻变动\",\"tbname\":\"a_hybd\",\"type\":0,\"url\":\"/formtable/manage/a_hybd\",\"children\":[{\"id\":\"4_48_edit\",\"title\":\"婚姻变动_添加/编辑\",\"url\":\"a_hybd_edit\"},{\"id\":\"4_48_delete\",\"title\":\"婚姻变动_删除\",\"url\":\"a_hybd_delete\"}]}]},{\"id\":\"4_8\",\"title\":\"老龄信息管理\",\"tbname\":\"a_llxxgl\",\"type\":0,\"url\":\"/user/oldmanage\",\"children\":[{\"id\":\"4_8_edit\",\"title\":\"老龄信息管理_添加/编辑\",\"url\":\"a_llxxgl_edit\"},{\"id\":\"4_8_delete\",\"title\":\"老龄信息管理_删除\",\"url\":\"a_llxxgl_delete\"}]},{\"id\":\"4_8_edit\",\"title\":\"老龄信息管理_添加/编辑\",\"url\":\"a_llxxgl_edit\"},{\"id\":\"4_8_delete\",\"title\":\"老龄信息管理_删除\",\"url\":\"a_llxxgl_delete\"},{\"id\":\"4_9\",\"title\":\"现退役管理\",\"tbname\":\"a_xtygl\",\"type\":0,\"url\":\"/party/soldier\",\"children\":[{\"id\":\"4_9_edit\",\"title\":\"现退役管理_添加/编辑\",\"url\":\"a_xtygl_edit\"},{\"id\":\"4_9_delete\",\"title\":\"现退役管理_删除\",\"url\":\"a_xtygl_delete\"}]},{\"id\":\"4_9_edit\",\"title\":\"现退役管理_添加/编辑\",\"url\":\"a_xtygl_edit\"},{\"id\":\"4_9_delete\",\"title\":\"现退役管理_删除\",\"url\":\"a_xtygl_delete\"},{\"id\":\"4_10\",\"title\":\"低保人员管理\",\"tbname\":\"a_dbrygl\",\"type\":0,\"url\":\"/formtable/manage/a_dbrygl\",\"children\":[{\"id\":\"4_10_edit\",\"title\":\"低保人员管理_添加/编辑\",\"url\":\"a_dbrygl_edit\"},{\"id\":\"4_10_delete\",\"title\":\"低保人员管理_删除\",\"url\":\"a_dbrygl_delete\"}]},{\"id\":\"4_10_edit\",\"title\":\"低保人员管理_添加/编辑\",\"url\":\"a_dbrygl_edit\"},{\"id\":\"4_10_delete\",\"title\":\"低保人员管理_删除\",\"url\":\"a_dbrygl_delete\"},{\"id\":\"4_11\",\"title\":\"优抚对象管理\",\"tbname\":\"a_yfdxgl\",\"type\":0,\"url\":\"/formtable/manage/a_yfdxgl\",\"children\":[{\"id\":\"4_11_edit\",\"title\":\"优抚对象管理_添加/编辑\",\"url\":\"a_yfdxgl_edit\"},{\"id\":\"4_11_delete\",\"title\":\"优抚对象管理_删除\",\"url\":\"a_yfdxgl_delete\"}]},{\"id\":\"4_11_edit\",\"title\":\"优抚对象管理_添加/编辑\",\"url\":\"a_yfdxgl_edit\"},{\"id\":\"4_11_delete\",\"title\":\"优抚对象管理_删除\",\"url\":\"a_yfdxgl_delete\"},{\"id\":\"4_21\",\"title\":\"社会救助\",\"tbname\":\"a_shjl\",\"type\":0,\"url\":\"/formtable/manage/a_shjl\",\"children\":[{\"id\":\"4_21_edit\",\"title\":\"社会救助_添加/编辑\",\"url\":\"a_shjl_edit\"},{\"id\":\"4_21_delete\",\"title\":\"社会救助_删除\",\"url\":\"a_shjl_delete\"}]},{\"id\":\"4_21_edit\",\"title\":\"社会救助_添加/编辑\",\"url\":\"a_shjl_edit\"},{\"id\":\"4_21_delete\",\"title\":\"社会救助_删除\",\"url\":\"a_shjl_delete\"},{\"id\":\"4_47\",\"title\":\"优惠政策\",\"tbname\":\"a_yhzc\",\"type\":0,\"url\":\"/formtable/manage/a_yhzc\",\"children\":[{\"id\":\"4_47_edit\",\"title\":\"优惠政策_添加/编辑\",\"url\":\"a_yhzc_edit\"},{\"id\":\"4_47_delete\",\"title\":\"优惠政策_删除\",\"url\":\"a_yhzc_delete\"}]},{\"id\":\"4_47_edit\",\"title\":\"优惠政策_添加/编辑\",\"url\":\"a_yhzc_edit\"},{\"id\":\"4_47_delete\",\"title\":\"优惠政策_删除\",\"url\":\"a_yhzc_delete\"},{\"id\":\"4_48\",\"title\":\"婚姻变动\",\"tbname\":\"a_hybd\",\"type\":0,\"url\":\"/formtable/manage/a_hybd\",\"children\":[{\"id\":\"4_48_edit\",\"title\":\"婚姻变动_添加/编辑\",\"url\":\"a_hybd_edit\"},{\"id\":\"4_48_delete\",\"title\":\"婚姻变动_删除\",\"url\":\"a_hybd_delete\"}]},{\"id\":\"4_48_edit\",\"title\":\"婚姻变动_添加/编辑\",\"url\":\"a_hybd_edit\"},{\"id\":\"4_48_delete\",\"title\":\"婚姻变动_删除\",\"url\":\"a_hybd_delete\"},{\"id\":5,\"title\":\"残联类管理\",\"icon\":\"canjiren\",\"children\":[{\"id\":\"5_12\",\"title\":\"残疾人管理\",\"tbname\":\"a_cjrgl\",\"type\":0,\"url\":\"/formtable/manage/a_cjrgl\",\"children\":[{\"id\":\"5_12_edit\",\"title\":\"残疾人管理_添加/编辑\",\"url\":\"a_cjrgl_edit\"},{\"id\":\"5_12_delete\",\"title\":\"残疾人管理_删除\",\"url\":\"a_cjrgl_delete\"}]}]},{\"id\":\"5_12\",\"title\":\"残疾人管理\",\"tbname\":\"a_cjrgl\",\"type\":0,\"url\":\"/formtable/manage/a_cjrgl\",\"children\":[{\"id\":\"5_12_edit\",\"title\":\"残疾人管理_添加/编辑\",\"url\":\"a_cjrgl_edit\"},{\"id\":\"5_12_delete\",\"title\":\"残疾人管理_删除\",\"url\":\"a_cjrgl_delete\"}]},{\"id\":\"5_12_edit\",\"title\":\"残疾人管理_添加/编辑\",\"url\":\"a_cjrgl_edit\"},{\"id\":\"5_12_delete\",\"title\":\"残疾人管理_删除\",\"url\":\"a_cjrgl_delete\"},{\"id\":8,\"title\":\"重点管理\",\"icon\":\"zhongdian\",\"children\":[{\"id\":\"8_15\",\"title\":\"重点关注管理\",\"tbname\":\"a_zdgzgl\",\"type\":0,\"url\":\"/formtable/manage/a_zdgzgl\",\"children\":[{\"id\":\"8_15_edit\",\"title\":\"重点关注管理_添加/编辑\",\"url\":\"a_zdgzgl_edit\"},{\"id\":\"8_15_delete\",\"title\":\"重点关注管理_删除\",\"url\":\"a_zdgzgl_delete\"}]}]},{\"id\":\"8_15\",\"title\":\"重点关注管理\",\"tbname\":\"a_zdgzgl\",\"type\":0,\"url\":\"/formtable/manage/a_zdgzgl\",\"children\":[{\"id\":\"8_15_edit\",\"title\":\"重点关注管理_添加/编辑\",\"url\":\"a_zdgzgl_edit\"},{\"id\":\"8_15_delete\",\"title\":\"重点关注管理_删除\",\"url\":\"a_zdgzgl_delete\"}]},{\"id\":\"8_15_edit\",\"title\":\"重点关注管理_添加/编辑\",\"url\":\"a_zdgzgl_edit\"},{\"id\":\"8_15_delete\",\"title\":\"重点关注管理_删除\",\"url\":\"a_zdgzgl_delete\"},{\"id\":9,\"title\":\"劳动保障管理\",\"icon\":\"baoxian\",\"children\":[{\"id\":\"9_16\",\"title\":\"居民社会保险\",\"tbname\":\"a_jmshbx\",\"type\":0,\"url\":\"/formtable/manage/a_jmshbx\",\"children\":[{\"id\":\"9_16_edit\",\"title\":\"居民社会保险_添加/编辑\",\"url\":\"a_jmshbx_edit\"},{\"id\":\"9_16_delete\",\"title\":\"居民社会保险_删除\",\"url\":\"a_jmshbx_delete\"}]}]},{\"id\":\"9_16\",\"title\":\"居民社会保险\",\"tbname\":\"a_jmshbx\",\"type\":0,\"url\":\"/formtable/manage/a_jmshbx\",\"children\":[{\"id\":\"9_16_edit\",\"title\":\"居民社会保险_添加/编辑\",\"url\":\"a_jmshbx_edit\"},{\"id\":\"9_16_delete\",\"title\":\"居民社会保险_删除\",\"url\":\"a_jmshbx_delete\"}]},{\"id\":\"9_16_edit\",\"title\":\"居民社会保险_添加/编辑\",\"url\":\"a_jmshbx_edit\"},{\"id\":\"9_16_delete\",\"title\":\"居民社会保险_删除\",\"url\":\"a_jmshbx_delete\"},{\"id\":14,\"title\":\"数据统计\",\"icon\":\"analyze\",\"children\":[{\"id\":\"14_24\",\"title\":\"数据统计\",\"tbname\":null,\"type\":1,\"url\":\"/formtable/analyze\"}]},{\"id\":\"14_24\",\"title\":\"数据统计\",\"tbname\":null,\"type\":1,\"url\":\"/formtable/analyze\"},{\"id\":\"setting\",\"title\":\"系统设置\",\"children\":[{\"id\":\"bsc\",\"title\":\"办事处管理\",\"url\":\"/setting/bsc\",\"children\":[{\"id\":\"bsc_edit\",\"title\":\"办事处_添加/编辑\",\"url\":\"/bsc/savebsc\"},{\"id\":\"bsc_delete\",\"title\":\"办事处_删除\",\"url\":\"/bsc/delbsc\"}]},{\"id\":\"sq\",\"title\":\"社区管理\",\"url\":\"/setting/sq/0\",\"children\":[{\"id\":\"sq_edit\",\"title\":\"社区_添加/编辑\",\"url\":\"/bsc/savebsc\"},{\"id\":\"sq_delete\",\"title\":\"社区_删除\",\"url\":\"/bsc/delbsc\"}]},{\"id\":\"design\",\"title\":\"居民信息设计\",\"url\":\"/setting/basic\"},{\"id\":\"permis\",\"title\":\"权限管理\",\"url\":\"/setting/permission\",\"children\":[{\"id\":\"permis_edit\",\"title\":\"权限_添加/编辑\",\"url\":\"/permission/store\"},{\"id\":\"permis_delete\",\"title\":\"权限_删除\",\"url\":\"/permission/delete\"},{\"id\":\"func\",\"title\":\"管理功能页\",\"url\":\"/setting/subpermis\",\"children\":[{\"id\":\"func_edit\",\"title\":\"功能页_添加/编辑\",\"url\":\"/permission/savesubpermis\"},{\"id\":\"func_delete\",\"title\":\"功能页_删除\",\"url\":\"/permission/delsubpermis\"},{\"id\":\"fields\",\"title\":\"编辑字段\",\"url\":\"/setting/subfunc\",\"children\":[{\"id\":\"fields_save\",\"title\":\"字段_保存\",\"url\":\"/permission/savesubfunc\"},{\"id\":\"fields_delete\",\"title\":\"字段_删除\",\"url\":\"/permission/delsubfunc\"}]}]}]},{\"id\":\"role\",\"title\":\"角色管理\",\"url\":\"/setting/roles\",\"children\":[{\"id\":\"role_edit\",\"title\":\"角色_添加/编辑\",\"url\":\"/role/store\"},{\"id\":\"role_delete\",\"title\":\"角色_删除\",\"url\":\"/role/destroy\"}]},{\"id\":\"user\",\"title\":\"用户管理\",\"url\":\"/setting/user\",\"children\":[{\"id\":\"user_edit\",\"title\":\"用户_添加/编辑\",\"url\":\"/users/store\"},{\"id\":\"user_delete\",\"title\":\"用户_删除\",\"url\":\"/users/destroy\"}]}]},{\"id\":\"bsc\",\"title\":\"办事处管理\",\"url\":\"/setting/bsc\",\"children\":[{\"id\":\"bsc_edit\",\"title\":\"办事处_添加/编辑\",\"url\":\"/bsc/savebsc\"},{\"id\":\"bsc_delete\",\"title\":\"办事处_删除\",\"url\":\"/bsc/delbsc\"}]},{\"id\":\"bsc_edit\",\"title\":\"办事处_添加/编辑\",\"url\":\"/bsc/savebsc\"},{\"id\":\"bsc_delete\",\"title\":\"办事处_删除\",\"url\":\"/bsc/delbsc\"},{\"id\":\"sq\",\"title\":\"社区管理\",\"url\":\"/setting/sq/0\",\"children\":[{\"id\":\"sq_edit\",\"title\":\"社区_添加/编辑\",\"url\":\"/bsc/savebsc\"},{\"id\":\"sq_delete\",\"title\":\"社区_删除\",\"url\":\"/bsc/delbsc\"}]},{\"id\":\"sq_edit\",\"title\":\"社区_添加/编辑\",\"url\":\"/bsc/savebsc\"},{\"id\":\"sq_delete\",\"title\":\"社区_删除\",\"url\":\"/bsc/delbsc\"},{\"id\":\"design\",\"title\":\"居民信息设计\",\"url\":\"/setting/basic\"},{\"id\":\"user\",\"title\":\"用户管理\",\"url\":\"/setting/user\",\"children\":[{\"id\":\"user_edit\",\"title\":\"用户_添加/编辑\",\"url\":\"/users/store\"},{\"id\":\"user_delete\",\"title\":\"用户_删除\",\"url\":\"/users/destroy\"}]},{\"id\":\"user_edit\",\"title\":\"用户_添加/编辑\",\"url\":\"/users/store\"},{\"id\":\"user_delete\",\"title\":\"用户_删除\",\"url\":\"/users/destroy\"}]', '1,1_1,1_1_edit,1_1_delete,1_2,1_3,1_46,1_46_edit,1_46_delete,2,2_4,2_4_edit,2_4_delete,2_5,2_5_edit,2_5_delete,3,3_6,3_6_edit,3_6_delete,4,4_8,4_8_edit,4_8_delete,4_9,4_9_edit,4_9_delete,4_10,4_10_edit,4_10_delete,4_11,4_11_edit,4_11_delete,4_21,4_21_edit,4_21_delete,4_47,4_47_edit,4_47_delete,4_48,4_48_edit,4_48_delete,5,5_12,5_12_edit,5_12_delete,8,8_15,8_15_edit,8_15_delete,9,9_16,9_16_edit,9_16_delete,14,14_24,setting,bsc,bsc_edit,bsc_delete,sq,sq_edit,sq_delete,design,user,user_edit,user_delete');
INSERT INTO `roles` VALUES (8, 'sq', 'api', '2019-10-30 10:16:15', '2021-05-20 09:49:35', NULL, '社区', NULL, 0, '[{\"id\":1,\"title\":\"居民管理\",\"icon\":\"jumin\",\"children\":[{\"id\":\"1_1\",\"title\":\"居民信息管理\",\"tbname\":\"a_jmxxgl\",\"type\":0,\"url\":\"/formtable/basic\",\"children\":[{\"id\":\"1_1_edit\",\"title\":\"居民信息管理_添加/编辑\",\"url\":\"a_jmxxgl_edit\"},{\"id\":\"1_1_delete\",\"title\":\"居民信息管理_删除\",\"url\":\"a_jmxxgl_delete\"}]},{\"id\":\"1_2\",\"title\":\"居民信息迁移\",\"tbname\":null,\"type\":1,\"url\":\"/user/move\"},{\"id\":\"1_3\",\"title\":\"以户为单位管理\",\"tbname\":null,\"type\":1,\"url\":\"/user/homemanage\"},{\"id\":\"1_46\",\"title\":\"房东信息\",\"tbname\":\"a_fdxx\",\"type\":0,\"url\":\"/formtable/manage/a_fdxx\",\"children\":[{\"id\":\"1_46_edit\",\"title\":\"房东信息_添加/编辑\",\"url\":\"a_fdxx_edit\"},{\"id\":\"1_46_delete\",\"title\":\"房东信息_删除\",\"url\":\"a_fdxx_delete\"}]}]},{\"id\":\"1_1\",\"title\":\"居民信息管理\",\"tbname\":\"a_jmxxgl\",\"type\":0,\"url\":\"/formtable/basic\",\"children\":[{\"id\":\"1_1_edit\",\"title\":\"居民信息管理_添加/编辑\",\"url\":\"a_jmxxgl_edit\"},{\"id\":\"1_1_delete\",\"title\":\"居民信息管理_删除\",\"url\":\"a_jmxxgl_delete\"}]},{\"id\":\"1_1_edit\",\"title\":\"居民信息管理_添加/编辑\",\"url\":\"a_jmxxgl_edit\"},{\"id\":\"1_1_delete\",\"title\":\"居民信息管理_删除\",\"url\":\"a_jmxxgl_delete\"},{\"id\":\"1_2\",\"title\":\"居民信息迁移\",\"tbname\":null,\"type\":1,\"url\":\"/user/move\"},{\"id\":\"1_3\",\"title\":\"以户为单位管理\",\"tbname\":null,\"type\":1,\"url\":\"/user/homemanage\"},{\"id\":\"1_46\",\"title\":\"房东信息\",\"tbname\":\"a_fdxx\",\"type\":0,\"url\":\"/formtable/manage/a_fdxx\",\"children\":[{\"id\":\"1_46_edit\",\"title\":\"房东信息_添加/编辑\",\"url\":\"a_fdxx_edit\"},{\"id\":\"1_46_delete\",\"title\":\"房东信息_删除\",\"url\":\"a_fdxx_delete\"}]},{\"id\":\"1_46_edit\",\"title\":\"房东信息_添加/编辑\",\"url\":\"a_fdxx_edit\"},{\"id\":\"1_46_delete\",\"title\":\"房东信息_删除\",\"url\":\"a_fdxx_delete\"},{\"id\":2,\"title\":\"党员管理\",\"icon\":\"dangyuan\",\"children\":[{\"id\":\"2_4\",\"title\":\"党员信息管理\",\"tbname\":\"a_dyxxgl\",\"type\":0,\"url\":\"/party/partymanage\",\"children\":[{\"id\":\"2_4_edit\",\"title\":\"党员信息管理_添加/编辑\",\"url\":\"a_dyxxgl_edit\"},{\"id\":\"2_4_delete\",\"title\":\"党员信息管理_删除\",\"url\":\"a_dyxxgl_delete\"}]},{\"id\":\"2_5\",\"title\":\"其它党派管理\",\"tbname\":\"a_qtdpgl\",\"type\":0,\"url\":\"/formtable/manage/a_qtdpgl\",\"children\":[{\"id\":\"2_5_edit\",\"title\":\"其它党派管理_添加/编辑\",\"url\":\"a_qtdpgl_edit\"},{\"id\":\"2_5_delete\",\"title\":\"其它党派管理_删除\",\"url\":\"a_qtdpgl_delete\"}]}]},{\"id\":\"2_4\",\"title\":\"党员信息管理\",\"tbname\":\"a_dyxxgl\",\"type\":0,\"url\":\"/party/partymanage\",\"children\":[{\"id\":\"2_4_edit\",\"title\":\"党员信息管理_添加/编辑\",\"url\":\"a_dyxxgl_edit\"},{\"id\":\"2_4_delete\",\"title\":\"党员信息管理_删除\",\"url\":\"a_dyxxgl_delete\"}]},{\"id\":\"2_4_edit\",\"title\":\"党员信息管理_添加/编辑\",\"url\":\"a_dyxxgl_edit\"},{\"id\":\"2_4_delete\",\"title\":\"党员信息管理_删除\",\"url\":\"a_dyxxgl_delete\"},{\"id\":\"2_5\",\"title\":\"其它党派管理\",\"tbname\":\"a_qtdpgl\",\"type\":0,\"url\":\"/formtable/manage/a_qtdpgl\",\"children\":[{\"id\":\"2_5_edit\",\"title\":\"其它党派管理_添加/编辑\",\"url\":\"a_qtdpgl_edit\"},{\"id\":\"2_5_delete\",\"title\":\"其它党派管理_删除\",\"url\":\"a_qtdpgl_delete\"}]},{\"id\":\"2_5_edit\",\"title\":\"其它党派管理_添加/编辑\",\"url\":\"a_qtdpgl_edit\"},{\"id\":\"2_5_delete\",\"title\":\"其它党派管理_删除\",\"url\":\"a_qtdpgl_delete\"},{\"id\":3,\"title\":\"计生管理\",\"icon\":\"yuling\",\"children\":[{\"id\":\"3_6\",\"title\":\"育龄妇女管理\",\"tbname\":\"a_ylfngl\",\"type\":0,\"url\":\"/user/funvmanage\",\"children\":[{\"id\":\"3_6_edit\",\"title\":\"育龄妇女管理_添加/编辑\",\"url\":\"a_ylfngl_edit\"},{\"id\":\"3_6_delete\",\"title\":\"育龄妇女管理_删除\",\"url\":\"a_ylfngl_delete\"}]}]},{\"id\":\"3_6\",\"title\":\"育龄妇女管理\",\"tbname\":\"a_ylfngl\",\"type\":0,\"url\":\"/user/funvmanage\",\"children\":[{\"id\":\"3_6_edit\",\"title\":\"育龄妇女管理_添加/编辑\",\"url\":\"a_ylfngl_edit\"},{\"id\":\"3_6_delete\",\"title\":\"育龄妇女管理_删除\",\"url\":\"a_ylfngl_delete\"}]},{\"id\":\"3_6_edit\",\"title\":\"育龄妇女管理_添加/编辑\",\"url\":\"a_ylfngl_edit\"},{\"id\":\"3_6_delete\",\"title\":\"育龄妇女管理_删除\",\"url\":\"a_ylfngl_delete\"},{\"id\":4,\"title\":\"民政类管理\",\"icon\":\"minzheng\",\"children\":[{\"id\":\"4_8\",\"title\":\"老龄信息管理\",\"tbname\":\"a_llxxgl\",\"type\":0,\"url\":\"/user/oldmanage\",\"children\":[{\"id\":\"4_8_edit\",\"title\":\"老龄信息管理_添加/编辑\",\"url\":\"a_llxxgl_edit\"},{\"id\":\"4_8_delete\",\"title\":\"老龄信息管理_删除\",\"url\":\"a_llxxgl_delete\"}]},{\"id\":\"4_9\",\"title\":\"现退役管理\",\"tbname\":\"a_xtygl\",\"type\":0,\"url\":\"/party/soldier\",\"children\":[{\"id\":\"4_9_edit\",\"title\":\"现退役管理_添加/编辑\",\"url\":\"a_xtygl_edit\"},{\"id\":\"4_9_delete\",\"title\":\"现退役管理_删除\",\"url\":\"a_xtygl_delete\"}]},{\"id\":\"4_10\",\"title\":\"低保人员管理\",\"tbname\":\"a_dbrygl\",\"type\":0,\"url\":\"/formtable/manage/a_dbrygl\",\"children\":[{\"id\":\"4_10_edit\",\"title\":\"低保人员管理_添加/编辑\",\"url\":\"a_dbrygl_edit\"},{\"id\":\"4_10_delete\",\"title\":\"低保人员管理_删除\",\"url\":\"a_dbrygl_delete\"}]},{\"id\":\"4_11\",\"title\":\"优抚对象管理\",\"tbname\":\"a_yfdxgl\",\"type\":0,\"url\":\"/formtable/manage/a_yfdxgl\",\"children\":[{\"id\":\"4_11_edit\",\"title\":\"优抚对象管理_添加/编辑\",\"url\":\"a_yfdxgl_edit\"},{\"id\":\"4_11_delete\",\"title\":\"优抚对象管理_删除\",\"url\":\"a_yfdxgl_delete\"}]},{\"id\":\"4_21\",\"title\":\"社会救助\",\"tbname\":\"a_shjl\",\"type\":0,\"url\":\"/formtable/manage/a_shjl\",\"children\":[{\"id\":\"4_21_edit\",\"title\":\"社会救助_添加/编辑\",\"url\":\"a_shjl_edit\"},{\"id\":\"4_21_delete\",\"title\":\"社会救助_删除\",\"url\":\"a_shjl_delete\"}]},{\"id\":\"4_47\",\"title\":\"优惠政策\",\"tbname\":\"a_yhzc\",\"type\":0,\"url\":\"/formtable/manage/a_yhzc\",\"children\":[{\"id\":\"4_47_edit\",\"title\":\"优惠政策_添加/编辑\",\"url\":\"a_yhzc_edit\"},{\"id\":\"4_47_delete\",\"title\":\"优惠政策_删除\",\"url\":\"a_yhzc_delete\"}]},{\"id\":\"4_48\",\"title\":\"婚姻变动\",\"tbname\":\"a_hybd\",\"type\":0,\"url\":\"/formtable/manage/a_hybd\",\"children\":[{\"id\":\"4_48_edit\",\"title\":\"婚姻变动_添加/编辑\",\"url\":\"a_hybd_edit\"},{\"id\":\"4_48_delete\",\"title\":\"婚姻变动_删除\",\"url\":\"a_hybd_delete\"}]}]},{\"id\":\"4_8\",\"title\":\"老龄信息管理\",\"tbname\":\"a_llxxgl\",\"type\":0,\"url\":\"/user/oldmanage\",\"children\":[{\"id\":\"4_8_edit\",\"title\":\"老龄信息管理_添加/编辑\",\"url\":\"a_llxxgl_edit\"},{\"id\":\"4_8_delete\",\"title\":\"老龄信息管理_删除\",\"url\":\"a_llxxgl_delete\"}]},{\"id\":\"4_8_edit\",\"title\":\"老龄信息管理_添加/编辑\",\"url\":\"a_llxxgl_edit\"},{\"id\":\"4_8_delete\",\"title\":\"老龄信息管理_删除\",\"url\":\"a_llxxgl_delete\"},{\"id\":\"4_9\",\"title\":\"现退役管理\",\"tbname\":\"a_xtygl\",\"type\":0,\"url\":\"/party/soldier\",\"children\":[{\"id\":\"4_9_edit\",\"title\":\"现退役管理_添加/编辑\",\"url\":\"a_xtygl_edit\"},{\"id\":\"4_9_delete\",\"title\":\"现退役管理_删除\",\"url\":\"a_xtygl_delete\"}]},{\"id\":\"4_9_edit\",\"title\":\"现退役管理_添加/编辑\",\"url\":\"a_xtygl_edit\"},{\"id\":\"4_9_delete\",\"title\":\"现退役管理_删除\",\"url\":\"a_xtygl_delete\"},{\"id\":\"4_10\",\"title\":\"低保人员管理\",\"tbname\":\"a_dbrygl\",\"type\":0,\"url\":\"/formtable/manage/a_dbrygl\",\"children\":[{\"id\":\"4_10_edit\",\"title\":\"低保人员管理_添加/编辑\",\"url\":\"a_dbrygl_edit\"},{\"id\":\"4_10_delete\",\"title\":\"低保人员管理_删除\",\"url\":\"a_dbrygl_delete\"}]},{\"id\":\"4_10_edit\",\"title\":\"低保人员管理_添加/编辑\",\"url\":\"a_dbrygl_edit\"},{\"id\":\"4_10_delete\",\"title\":\"低保人员管理_删除\",\"url\":\"a_dbrygl_delete\"},{\"id\":\"4_11\",\"title\":\"优抚对象管理\",\"tbname\":\"a_yfdxgl\",\"type\":0,\"url\":\"/formtable/manage/a_yfdxgl\",\"children\":[{\"id\":\"4_11_edit\",\"title\":\"优抚对象管理_添加/编辑\",\"url\":\"a_yfdxgl_edit\"},{\"id\":\"4_11_delete\",\"title\":\"优抚对象管理_删除\",\"url\":\"a_yfdxgl_delete\"}]},{\"id\":\"4_11_edit\",\"title\":\"优抚对象管理_添加/编辑\",\"url\":\"a_yfdxgl_edit\"},{\"id\":\"4_11_delete\",\"title\":\"优抚对象管理_删除\",\"url\":\"a_yfdxgl_delete\"},{\"id\":\"4_21\",\"title\":\"社会救助\",\"tbname\":\"a_shjl\",\"type\":0,\"url\":\"/formtable/manage/a_shjl\",\"children\":[{\"id\":\"4_21_edit\",\"title\":\"社会救助_添加/编辑\",\"url\":\"a_shjl_edit\"},{\"id\":\"4_21_delete\",\"title\":\"社会救助_删除\",\"url\":\"a_shjl_delete\"}]},{\"id\":\"4_21_edit\",\"title\":\"社会救助_添加/编辑\",\"url\":\"a_shjl_edit\"},{\"id\":\"4_21_delete\",\"title\":\"社会救助_删除\",\"url\":\"a_shjl_delete\"},{\"id\":\"4_47\",\"title\":\"优惠政策\",\"tbname\":\"a_yhzc\",\"type\":0,\"url\":\"/formtable/manage/a_yhzc\",\"children\":[{\"id\":\"4_47_edit\",\"title\":\"优惠政策_添加/编辑\",\"url\":\"a_yhzc_edit\"},{\"id\":\"4_47_delete\",\"title\":\"优惠政策_删除\",\"url\":\"a_yhzc_delete\"}]},{\"id\":\"4_47_edit\",\"title\":\"优惠政策_添加/编辑\",\"url\":\"a_yhzc_edit\"},{\"id\":\"4_47_delete\",\"title\":\"优惠政策_删除\",\"url\":\"a_yhzc_delete\"},{\"id\":\"4_48\",\"title\":\"婚姻变动\",\"tbname\":\"a_hybd\",\"type\":0,\"url\":\"/formtable/manage/a_hybd\",\"children\":[{\"id\":\"4_48_edit\",\"title\":\"婚姻变动_添加/编辑\",\"url\":\"a_hybd_edit\"},{\"id\":\"4_48_delete\",\"title\":\"婚姻变动_删除\",\"url\":\"a_hybd_delete\"}]},{\"id\":\"4_48_edit\",\"title\":\"婚姻变动_添加/编辑\",\"url\":\"a_hybd_edit\"},{\"id\":\"4_48_delete\",\"title\":\"婚姻变动_删除\",\"url\":\"a_hybd_delete\"},{\"id\":5,\"title\":\"残联类管理\",\"icon\":\"canjiren\",\"children\":[{\"id\":\"5_12\",\"title\":\"残疾人管理\",\"tbname\":\"a_cjrgl\",\"type\":0,\"url\":\"/formtable/manage/a_cjrgl\",\"children\":[{\"id\":\"5_12_edit\",\"title\":\"残疾人管理_添加/编辑\",\"url\":\"a_cjrgl_edit\"},{\"id\":\"5_12_delete\",\"title\":\"残疾人管理_删除\",\"url\":\"a_cjrgl_delete\"}]}]},{\"id\":\"5_12\",\"title\":\"残疾人管理\",\"tbname\":\"a_cjrgl\",\"type\":0,\"url\":\"/formtable/manage/a_cjrgl\",\"children\":[{\"id\":\"5_12_edit\",\"title\":\"残疾人管理_添加/编辑\",\"url\":\"a_cjrgl_edit\"},{\"id\":\"5_12_delete\",\"title\":\"残疾人管理_删除\",\"url\":\"a_cjrgl_delete\"}]},{\"id\":\"5_12_edit\",\"title\":\"残疾人管理_添加/编辑\",\"url\":\"a_cjrgl_edit\"},{\"id\":\"5_12_delete\",\"title\":\"残疾人管理_删除\",\"url\":\"a_cjrgl_delete\"},{\"id\":7,\"title\":\"综治管理\",\"icon\":\"xiejiao\",\"children\":[{\"id\":\"7_14\",\"title\":\"邪教人员管理\",\"tbname\":\"a_xjrygl\",\"type\":0,\"url\":\"/formtable/manage/a_xjrygl\",\"children\":[{\"id\":\"7_14_edit\",\"title\":\"邪教人员管理_添加/编辑\",\"url\":\"a_xjrygl_edit\"},{\"id\":\"7_14_delete\",\"title\":\"邪教人员管理_删除\",\"url\":\"a_xjrygl_delete\"}]}]},{\"id\":\"7_14\",\"title\":\"邪教人员管理\",\"tbname\":\"a_xjrygl\",\"type\":0,\"url\":\"/formtable/manage/a_xjrygl\",\"children\":[{\"id\":\"7_14_edit\",\"title\":\"邪教人员管理_添加/编辑\",\"url\":\"a_xjrygl_edit\"},{\"id\":\"7_14_delete\",\"title\":\"邪教人员管理_删除\",\"url\":\"a_xjrygl_delete\"}]},{\"id\":\"7_14_edit\",\"title\":\"邪教人员管理_添加/编辑\",\"url\":\"a_xjrygl_edit\"},{\"id\":\"7_14_delete\",\"title\":\"邪教人员管理_删除\",\"url\":\"a_xjrygl_delete\"},{\"id\":8,\"title\":\"重点管理\",\"icon\":\"zhongdian\",\"children\":[{\"id\":\"8_15\",\"title\":\"重点关注管理\",\"tbname\":\"a_zdgzgl\",\"type\":0,\"url\":\"/formtable/manage/a_zdgzgl\",\"children\":[{\"id\":\"8_15_edit\",\"title\":\"重点关注管理_添加/编辑\",\"url\":\"a_zdgzgl_edit\"},{\"id\":\"8_15_delete\",\"title\":\"重点关注管理_删除\",\"url\":\"a_zdgzgl_delete\"}]}]},{\"id\":\"8_15\",\"title\":\"重点关注管理\",\"tbname\":\"a_zdgzgl\",\"type\":0,\"url\":\"/formtable/manage/a_zdgzgl\",\"children\":[{\"id\":\"8_15_edit\",\"title\":\"重点关注管理_添加/编辑\",\"url\":\"a_zdgzgl_edit\"},{\"id\":\"8_15_delete\",\"title\":\"重点关注管理_删除\",\"url\":\"a_zdgzgl_delete\"}]},{\"id\":\"8_15_edit\",\"title\":\"重点关注管理_添加/编辑\",\"url\":\"a_zdgzgl_edit\"},{\"id\":\"8_15_delete\",\"title\":\"重点关注管理_删除\",\"url\":\"a_zdgzgl_delete\"},{\"id\":9,\"title\":\"劳动保障管理\",\"icon\":\"baoxian\",\"children\":[{\"id\":\"9_16\",\"title\":\"居民社会保险\",\"tbname\":\"a_jmshbx\",\"type\":0,\"url\":\"/formtable/manage/a_jmshbx\",\"children\":[{\"id\":\"9_16_edit\",\"title\":\"居民社会保险_添加/编辑\",\"url\":\"a_jmshbx_edit\"},{\"id\":\"9_16_delete\",\"title\":\"居民社会保险_删除\",\"url\":\"a_jmshbx_delete\"}]}]},{\"id\":\"9_16\",\"title\":\"居民社会保险\",\"tbname\":\"a_jmshbx\",\"type\":0,\"url\":\"/formtable/manage/a_jmshbx\",\"children\":[{\"id\":\"9_16_edit\",\"title\":\"居民社会保险_添加/编辑\",\"url\":\"a_jmshbx_edit\"},{\"id\":\"9_16_delete\",\"title\":\"居民社会保险_删除\",\"url\":\"a_jmshbx_delete\"}]},{\"id\":\"9_16_edit\",\"title\":\"居民社会保险_添加/编辑\",\"url\":\"a_jmshbx_edit\"},{\"id\":\"9_16_delete\",\"title\":\"居民社会保险_删除\",\"url\":\"a_jmshbx_delete\"},{\"id\":13,\"title\":\"境外停留人员\",\"icon\":\"user\",\"children\":[{\"id\":\"13_17\",\"title\":\"境外人员管理\",\"tbname\":\"a_jwrygl\",\"type\":0,\"url\":\"/formtable/manage/a_jwrygl\",\"children\":[{\"id\":\"13_17_edit\",\"title\":\"境外人员管理_添加/编辑\",\"url\":\"a_jwrygl_edit\"},{\"id\":\"13_17_delete\",\"title\":\"境外人员管理_删除\",\"url\":\"a_jwrygl_delete\"}]}]},{\"id\":\"13_17\",\"title\":\"境外人员管理\",\"tbname\":\"a_jwrygl\",\"type\":0,\"url\":\"/formtable/manage/a_jwrygl\",\"children\":[{\"id\":\"13_17_edit\",\"title\":\"境外人员管理_添加/编辑\",\"url\":\"a_jwrygl_edit\"},{\"id\":\"13_17_delete\",\"title\":\"境外人员管理_删除\",\"url\":\"a_jwrygl_delete\"}]},{\"id\":\"13_17_edit\",\"title\":\"境外人员管理_添加/编辑\",\"url\":\"a_jwrygl_edit\"},{\"id\":\"13_17_delete\",\"title\":\"境外人员管理_删除\",\"url\":\"a_jwrygl_delete\"}]', '1,1_1,1_1_edit,1_1_delete,1_2,1_3,1_46,1_46_edit,1_46_delete,2,2_4,2_4_edit,2_4_delete,2_5,2_5_edit,2_5_delete,3,3_6,3_6_edit,3_6_delete,4,4_8,4_8_edit,4_8_delete,4_9,4_9_edit,4_9_delete,4_10,4_10_edit,4_10_delete,4_11,4_11_edit,4_11_delete,4_21,4_21_edit,4_21_delete,4_47,4_47_edit,4_47_delete,4_48,4_48_edit,4_48_delete,5,5_12,5_12_edit,5_12_delete,7,7_14,7_14_edit,7_14_delete,8,8_15,8_15_edit,8_15_delete,9,9_16,9_16_edit,9_16_delete,13,13_17,13_17_edit,13_17_delete');

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `email` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  `state` int(1) NULL DEFAULT 1 COMMENT '0-锁定，1-正常',
  `pid` int(10) NULL DEFAULT NULL COMMENT '上级id',
  `openid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `users_email_unique`(`email`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 82 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES (1, 'admin', '123@123.com', NULL, '$2y$10$WnM67ZZAGTBeN0y6usV42ebKlml2Ooc1JRnNIfC/hN3EDznLHOfo6', NULL, '2019-06-12 06:06:31', '2021-03-16 14:17:06', '/uploads/avatar/20191010/edbc637e956783931274c0d304703191.png', '15511111111', 1, 0, NULL);
INSERT INTO `users` VALUES (80, 'bsc', NULL, NULL, '$2y$10$9t4LH6i5j9h/sLP8iVYflOu8g2zCy5J9wJ6voqNOTKoCZsyOqxkNa', NULL, '2022-05-13 14:46:41', '2022-05-13 14:46:41', NULL, NULL, 1, 25, NULL);
INSERT INTO `users` VALUES (81, 'sq', NULL, NULL, '$2y$10$d0JfkhlG0YveEpwbJhaZq..E.tU8dGpN0C4YT04n5YLkBHJjiMdEi', NULL, '2022-05-13 14:46:58', '2022-05-13 14:46:58', NULL, NULL, 1, 27, NULL);

-- ----------------------------
-- Table structure for version
-- ----------------------------
DROP TABLE IF EXISTS `version`;
CREATE TABLE `version`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` int(1) NULL DEFAULT NULL COMMENT '0-安卓，1-ios',
  `version` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '版本',
  `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '更新内容',
  `force` int(1) NULL DEFAULT NULL COMMENT '0-非强制，1-强制',
  `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '地址',
  `code` int(10) NULL DEFAULT NULL COMMENT '版本号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of version
-- ----------------------------

SET FOREIGN_KEY_CHECKS = 1;