drop table `Insurance_Bill`;
create Table `Insurance_Bill` (
    `cxCaseId` varchar(30) not null comment '宸汐案件号',
    `billId` varchar(30) not null comment '发票号',
    `hospitalName` varchar(200) not null comment '医院名称',
    `completeTime` char(10) not null comment '结案时间',
    `inquiryStartTime` char(10) not null comment '就诊时间',
    `inquiryEndTime` char(10) not null comment '出院时间',
    `billTimes` char(10) comment '发票日期',
    `insurancePayAmount` decimal(16,2) not null comment '医保支付金额（元）',
    `selfPayAmountOne` decimal(16,2) not null comment '自付一',
    `selfPayAmountTwo` decimal(16,2) not null comment '自付二',
    `selfAmount` decimal(16,2) not null comment '自费',
    `bnOtherAmount` decimal(16,2) comment '保内除外金额',
    `bnReasonOne` varchar(1000) comment '保内除外金额原因',
    `billAmount` decimal(16,2) not null comment '发票合计金额'
) DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '发票信息表'