/*
Navicat MySQL Data Transfer

Source Server         : 百川信
Source Server Version : 50518
Source Host           : bcxin366.mysql.rds.aliyuncs.com:3306
Source Database       : ars

Target Server Type    : MYSQL
Target Server Version : 50518
File Encoding         : 65001

Date: 2017-09-12 20:13:24
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for company_certificate
-- ----------------------------
DROP TABLE IF EXISTS `company_certificate`;
CREATE TABLE `company_certificate` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `active` bit(1) NOT NULL COMMENT '是否有效',
  `create_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `update_by` varchar(50) NOT NULL,
  `pzwh` varchar(50) DEFAULT NULL COMMENT '批准文号',
  `fwfw` varchar(50) DEFAULT NULL COMMENT '服务范围',
  `frmc` varchar(50) DEFAULT NULL COMMENT '法人名称',
  `gsmc` varchar(100) DEFAULT NULL COMMENT '公司名称',
  `zczb` varchar(50) DEFAULT NULL COMMENT '注册资本',
  `fzrq` datetime DEFAULT NULL COMMENT '发证日期',
  `slr` varchar(50) DEFAULT NULL COMMENT '受理人',
  `slrsj` varchar(50) DEFAULT NULL COMMENT '受理人手机号',
  `zzrq` datetime DEFAULT NULL COMMENT '制作日期',
  `xkzh` varchar(50) DEFAULT NULL COMMENT '许可证号',
  `sponsorlicenseid` int(11) DEFAULT NULL COMMENT '保安服务公司申报ID',
  `gsdz` varchar(100) DEFAULT NULL COMMENT '公司地址',
  `zczblx` varchar(3) DEFAULT NULL COMMENT '注册资本类型',
  `fzjgbh` varchar(50) DEFAULT NULL COMMENT '发证机关编号',
  `frdblx` varchar(3) DEFAULT NULL COMMENT '法定代表人类型',
  `zzzt` varchar(3) DEFAULT NULL COMMENT '制证状态',
  `fzjgmc` varchar(100) DEFAULT NULL COMMENT '发证机关名称',
  PRIMARY KEY (`id`),
  KEY `idx_id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=593 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of company_certificate
-- ----------------------------
INSERT INTO `company_certificate` VALUES ('585', '', '2017-09-09 06:56:28', '2017-09-09 06:56:28', 'sjld', '21', '1,2,3', '21', '121', '12', '2017-09-09 00:00:00', 'sjld', '13916796300', null, 'SN20170001', '34', '212', null, null, null, null, '21');
INSERT INTO `company_certificate` VALUES ('586', '', '2017-09-09 06:56:30', '2017-09-09 06:56:30', 'sjld', '21', '1,2,3', '21', '121', '12', '2017-09-09 00:00:00', 'sjld', '13916796300', null, 'SN20170002', '34', '212', null, null, null, null, '21');
INSERT INTO `company_certificate` VALUES ('587', '', '2017-09-09 07:01:39', '2017-09-09 07:01:40', 'sjld', '12', '', '', '', '', '2017-09-09 00:00:00', 'sjld', '13916796300', null, 'SN20170003', '34', '', null, null, null, null, '121');
INSERT INTO `company_certificate` VALUES ('588', '', '2017-09-09 23:11:27', '2017-09-09 23:11:27', 'sjld', '10921', '1,2,3', '121', '21', '21', '2017-09-09 00:00:00', 'sjld', '13916796300', null, 'SN20170004', '35', '21', null, null, null, null, '福建公安');
INSERT INTO `company_certificate` VALUES ('591', '', '2017-09-11 17:01:11', '2017-09-11 17:01:11', 'xmga', '212', '1,2,3', '张三', '福州保安公司', '2000', '2017-09-11 00:00:00', 'xmga', '13916796300', null, 'SN20170005', '24', '福州市', null, null, null, null, '21212');
INSERT INTO `company_certificate` VALUES ('592', '', '2017-09-12 13:10:31', '2017-09-12 13:10:31', 'zaj', '121', '2', '21', '3121', '121', '2017-09-12 00:00:00', 'zaj', '13916796305', null, 'SN20170006', '37', '212', null, null, null, null, '21');

-- ----------------------------
-- Table structure for security_certificate
-- ----------------------------
DROP TABLE IF EXISTS `security_certificate`;
CREATE TABLE `security_certificate` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `active` bit(1) NOT NULL COMMENT '是否有效',
  `create_time` datetime NOT NULL,
  `update_time` datetime NOT NULL,
  `update_by` varchar(50) NOT NULL,
  `xm` varchar(50) DEFAULT NULL COMMENT '姓名',
  `address` varchar(100) DEFAULT NULL COMMENT '地址',
  `csrq` varchar(50) DEFAULT NULL COMMENT '出生日期',
  `idnum` varchar(50) DEFAULT NULL COMMENT '公民身份证号',
  `zsbh` varchar(50) DEFAULT NULL COMMENT '证书编号',
  `fzrq` datetime DEFAULT NULL COMMENT '发证日期',
  `zzrq` datetime DEFAULT NULL COMMENT '制作日期',
  `zzzt` varchar(3) DEFAULT NULL COMMENT '制证状态',
  `securitypersonid` int(11) DEFAULT NULL COMMENT '保安员资格证申报ID',
  `fzjgmc` varchar(100) DEFAULT NULL COMMENT '发证机关名称',
  `fzjgbh` varchar(50) DEFAULT NULL COMMENT '发证机关编号',
  PRIMARY KEY (`id`),
  KEY `idx_id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=590 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of security_certificate
-- ----------------------------
INSERT INTO `security_certificate` VALUES ('583', '', '2017-09-08 09:59:48', '2017-09-08 09:59:48', 'xmga', '洪明耀', '朝阳区太阳宫芍药居甲1号', '1986-01-02', '350205198601020015', '1000010', '2017-09-08 00:00:00', null, null, '138', null, null);
INSERT INTO `security_certificate` VALUES ('584', '', '2017-09-09 14:17:24', '2017-09-09 14:45:58', 'sjld', '陈西平', '21', '1963-05-05', '612101196305050012', '2121', '2000-09-09 00:00:00', null, null, '219', null, null);
INSERT INTO `security_certificate` VALUES ('585', '', '2017-09-10 07:26:05', '2017-09-10 07:26:05', 'sjld', '', '', '', '', '2121', '2017-09-10 00:00:00', null, null, '221', null, null);
INSERT INTO `security_certificate` VALUES ('586', '', '2017-09-10 10:33:41', '2017-09-10 10:33:51', 'sjld', 'susu', '21', '1988-05-23', '150625198805233338', '2121', '2017-09-10 00:00:00', null, null, '222', null, null);
INSERT INTO `security_certificate` VALUES ('587', '', '2017-09-12 05:57:01', '2017-09-12 05:57:01', 'sjld', '测试', '21', '1994-03-13', '150501199403135370', '2121', '2017-09-12 00:00:00', null, null, '224', null, null);
INSERT INTO `security_certificate` VALUES ('588', '', '2017-09-12 06:40:20', '2017-09-12 06:40:20', 'sjld', '菜菜', '11', '1992-08-11', '510182199208117680', '21', '2017-09-12 00:00:00', null, null, '226', null, null);
INSERT INTO `security_certificate` VALUES ('589', '', '2017-09-12 13:54:13', '2017-09-12 13:54:32', 'sjld', '432', '21', '1978-10-24', '330481197810249560', '1121', '2017-09-12 00:00:00', null, null, '227', null, null);

-- ----------------------------
-- Table structure for train_certificate
-- ----------------------------
DROP TABLE IF EXISTS `train_certificate`;
CREATE TABLE `train_certificate` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `active` bit(1) DEFAULT NULL COMMENT '是否可用',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `update_by` varchar(50) DEFAULT NULL COMMENT '修改者',
  `pzwh` varchar(50) DEFAULT NULL COMMENT '批准文号',
  `pxnr` varchar(100) DEFAULT NULL COMMENT '服务范围',
  `frmc` varchar(50) DEFAULT NULL COMMENT '法人名称',
  `gsmc` varchar(50) DEFAULT NULL COMMENT '公司名称',
  `zczb` varchar(50) DEFAULT NULL COMMENT '注册资本',
  `fzrq` date DEFAULT NULL COMMENT '发证日期',
  `slr` varchar(100) DEFAULT NULL COMMENT '受理人',
  `slrsj` varchar(20) DEFAULT NULL COMMENT '受理人手机号',
  `zzrq` date DEFAULT NULL COMMENT '制证日期',
  `xkzh` varchar(50) DEFAULT NULL COMMENT '许可证号',
  `traincompanyapplyid` int(11) DEFAULT NULL COMMENT '保安服务公司申报ID',
  `gsdz` varchar(200) DEFAULT NULL COMMENT '公司地址',
  `zczblx` varchar(3) DEFAULT NULL COMMENT '注册资本类型',
  `fzjgmc` varchar(100) DEFAULT NULL COMMENT '发证机关名称',
  `fzjgbh` varchar(20) DEFAULT NULL COMMENT '发证机关编号',
  `frdblx` varchar(3) DEFAULT NULL COMMENT '法人代表类型',
  `zzzt` varchar(3) DEFAULT NULL COMMENT '制证状态',
  KEY `train_certificate_key` (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;

-- ----------------------------
-- Records of train_certificate
-- ----------------------------
INSERT INTO `train_certificate` VALUES ('11', '', '2017-09-08 11:19:00', '2017-09-08 11:19:00', 'xmga', '1111', '21', '21', '21', null, '2017-09-08', null, null, null, null, '20', '21', null, '2222', null, null, null);
