CREATE TABLE `finance_repayment_plan` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID',
`financing_id` bigint NOT NULL COMMENT '申请融资ID',
`financing_no` varchar(200) NOT NULL COMMENT '申请融资单号',
`product_type` varchar(200) DEFAULT NULL COMMENT '融资产品类型',
`funder_name` varchar(200) DEFAULT NULL COMMENT '资金方名称',
`repayment_method` varchar(200) DEFAULT NULL COMMENT '回款方式',
`deduction_channel_status` tinyint(1) DEFAULT NULL COMMENT '扣款通道状态',
`repayment_status` tinyint(1) DEFAULT NULL COMMENT '还款状态:0-受托支付 1-直付融资方',
`annual_interest_rate` decimal(12,2) DEFAULT NULL COMMENT '年化利率(%)',
`value_date` datetime DEFAULT NULL COMMENT '起息日期',
`maturity_date` datetime DEFAULT NULL COMMENT '到期日期',
`settlement_status` tinyint(1) DEFAULT NULL COMMENT '结清状态',
`creator` varchar(64) DEFAULT '' COMMENT '创建者',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`updater` varchar(64) DEFAULT '' COMMENT '更新者',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
`deleted` tinyint NOT NULL DEFAULT '0' COMMENT '是否删除',
`tenant_id` bigint DEFAULT NULL COMMENT '租户编号',
`installment_no` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '还款期次',
`due_date` datetime DEFAULT NULL COMMENT '应还日期',
`principal_due` decimal(12,2) DEFAULT NULL COMMENT '应还本金(元)',
`interest_due` decimal(12,2) DEFAULT NULL COMMENT '应还利息(元)',
`fee_due` decimal(12,2) DEFAULT NULL COMMENT '应还费用(元)',
`total_amount_due` decimal(12,2) DEFAULT NULL COMMENT '应还合计(元)',
`current_balance` decimal(12,2) DEFAULT NULL COMMENT '当前余额(万元)',
`user_name` varchar(255) DEFAULT NULL COMMENT '融资方名称',
PRIMARY KEY (`id`) USING BTREE,
KEY `idx_financing_id` (`financing_id`) USING BTREE,
KEY `idx_financing_no` (`financing_no`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='融资还款计划表';