11 lines
699 B
SQL
11 lines
699 B
SQL
drop table `Insurance_Result`;
|
|
create table `Insurance_Result` (
|
|
`cxCaseId` varchar(30) not null comment '宸汐案件号',
|
|
`dutyName` varchar(100) not null comment '责任名称',
|
|
`rationalAmount` decimal(16, 2) not null comment '合理金额',
|
|
`localProportion` varchar(100) not null comment '赔付比例',
|
|
`outProportion` varchar(100) not null comment '异地报销比例',
|
|
`compensationAmount` decimal(16, 2) not null comment '赔付金额',
|
|
`payAmount` decimal(16, 2) not null comment '赔付金额',
|
|
`responsibilityAmount` decimal(16, 2) not null comment '责任赔付金额'
|
|
) default charset = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '理算结果表' |