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 ;