CREATE TABLE `security_company_insurance` (
`id`  int(11) NOT NULL AUTO_INCREMENT COMMENT '主键' ,
`active`  bit(1) NULL DEFAULT NULL COMMENT '是否可用' ,
`update_by`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '修改者' ,
`update_time`  datetime NULL DEFAULT NULL COMMENT '修改时间' ,
`create_time`  datetime NULL DEFAULT NULL COMMENT '创建时间' ,
`company_id`  int(11) NULL DEFAULT NULL COMMENT '公司ID' ,
`insured_num`  int(11) NULL DEFAULT NULL COMMENT '在保人数' ,
`insurance_company`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '保险公司名称' ,
`protection_date`  datetime NULL DEFAULT NULL COMMENT '起保日期' ,
`insurance_product`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '保险产品名称' ,
`premium_person`  decimal(8,2) NULL DEFAULT NULL COMMENT '每人保费' ,
UNIQUE INDEX `insurnace_pk` (`id`) USING BTREE
)
ENGINE=InnoDB
ROW_FORMAT=COMPACT
;
