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


ALTER TABLE `sb_sponsorlicense`
ADD COLUMN `info_rar`  varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '资料补正告知书' AFTER `district`;

ALTER TABLE `sb_traincompanyapply`
ADD COLUMN `info_rar`  varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '资料补正告知书' AFTER `legalphone`;

ALTER TABLE `sb_sponsorlicense`
ADD COLUMN `replyreason`  varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '批复意见' AFTER `info_rar`;

ALTER TABLE `sb_traincompanyapply`
ADD COLUMN `replyreason`  varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '批复意见' AFTER `info_rar`;






