CREATE TABLE `sb_sponsorlicense_manager` (
`id`  int(11) NOT NULL AUTO_INCREMENT COMMENT '主键' ,
`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 '修改者' ,
`Sponsorlicenseid`  int(11) NULL DEFAULT NULL COMMENT '保安服务公司申请ID' ,
`name`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名' ,
`idnum`  varchar(18) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '身份证号' ,
`phone`  varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机号' ,
INDEX `armorgteach_key` (`id`) USING BTREE
)
ENGINE=InnoDB
ROW_FORMAT=COMPACT
;

CREATE TABLE `sb_sponsorlicense_vmanager` (
`id`  int(11) NOT NULL AUTO_INCREMENT COMMENT '主键' ,
`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 '修改者' ,
`Sponsorlicenseid`  int(11) NULL DEFAULT NULL COMMENT '保安服务公司申请ID' ,
`vname`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '副总姓名' ,
`vidnum`  varchar(18) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '副总身份证号' ,
`vphone`  varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '副总手机号' ,
INDEX `armorgteach_key` (`id`) USING BTREE
)
ENGINE=InnoDB
ROW_FORMAT=COMPACT
;
