17 lines
1.0 KiB
SQL
17 lines
1.0 KiB
SQL
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 = '发票信息表' |