CREATE TABLE `armorgcharge` (
`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 '修改者' ,
`armtrainorgid`  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(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机号' ,
INDEX `armorgcharge_key` (`id`) USING BTREE
)
ENGINE=InnoDB
ROW_FORMAT=COMPACT
;

CREATE TABLE `armtraincharge` (
`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 '修改者' ,
`armtrainorgid`  int(11) NULL DEFAULT NULL COMMENT '武装机构ID' ,
`pxname`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名' ,
`pxidnum`  varchar(18) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '身份证号' ,
`pxphone`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机号' ,
INDEX `armtraincharge_key` (`id`) USING BTREE
)
ENGINE=InnoDB
ROW_FORMAT=COMPACT
;


CREATE TABLE `armorgteach` (
`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 '修改者' ,
`armtrainorgid`  int(11) NULL DEFAULT NULL COMMENT '武装机构ID' ,
`jyname`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名' ,
`jyidnum`  varchar(18) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '身份证号' ,
`jysex`  varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性别' ,
`jyage`  varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '年龄' ,
`jygunnum`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '持枪证号' ,
INDEX `armorgteach_key` (`id`) USING BTREE
)
ENGINE=InnoDB
ROW_FORMAT=COMPACT
;