DROP TABLE IF EXISTS `quality_channel_error_deatil`;
CREATE TABLE `quality_channel_error_deatil` (
`id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键id',
`quality_id` bigint(20) NULL DEFAULT NULL COMMENT '质检id',
`organization_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '销售机构名字',
`organization_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '销售机构编号',
`project_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '销售项目名字',
`project_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '销售项目编号',
`insure_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '投保单号',
`policy_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '保单号',
`insure_time` datetime(0) NULL DEFAULT NULL COMMENT '投保时间',
`pay_time` datetime(0) NULL DEFAULT NULL COMMENT '承保时间',
`applicant_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '投保人',
`customer_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '被保人',
`TSR_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'tsr工号',
`TSR_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'tsr名字',
`product_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '产品名称',
`product_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '产品编号',
`pay_frequency` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '缴费频率',
`premium` bigint(20) NULL DEFAULT NULL COMMENT '保费 年化保费*缴费次数',
`scale_premium` bigint(20) NULL DEFAULT NULL COMMENT '规模保费 ',
`policy_status` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '保单状态',
`deleted` tinyint(4) NULL DEFAULT 0 COMMENT '删除标示 0-未删除，1-已删除',
`create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `idx_qualityId_deleted`(`quality_id`, `deleted`) USING BTREE,
INDEX `idx_creatTime`(`create_time`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;