1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
| -- 助力贷：产品配置与订单表
|
| CREATE TABLE IF NOT EXISTS `t_loan_config` (
| `uuid` varchar(64) NOT NULL,
| `term` int NOT NULL COMMENT '借款天数',
| `daily_rate` decimal(20,8) NOT NULL DEFAULT '0.00100000' COMMENT '日利率',
| `max_quota` decimal(20,8) NOT NULL DEFAULT '10000.00000000' COMMENT '最高额度',
| `lending_institution` varchar(64) DEFAULT '1',
| `lending_name` varchar(128) DEFAULT 'Platform Finance',
| `repayment` int DEFAULT '1' COMMENT '1到期一次还款',
| `repay_cycle` int DEFAULT NULL COMMENT '还款周期(天)',
| `state` int DEFAULT '1' COMMENT '0停用 1启用',
| `sort_num` int DEFAULT '0',
| `create_time` datetime DEFAULT NULL,
| `update_time` datetime DEFAULT NULL,
| PRIMARY KEY (`uuid`)
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='贷款产品配置';
|
| CREATE TABLE IF NOT EXISTS `t_loan_order` (
| `uuid` varchar(64) NOT NULL,
| `order_no` varchar(64) NOT NULL,
| `user_id` varchar(64) NOT NULL,
| `loan_config_id` varchar(64) DEFAULT NULL,
| `symbol` varchar(32) DEFAULT 'USDT',
| `quota` decimal(20,8) NOT NULL,
| `term` int NOT NULL,
| `daily_rate` decimal(20,8) NOT NULL,
| `total_interest` decimal(20,8) DEFAULT '0.00000000',
| `repay_cycle` int DEFAULT NULL,
| `repayment` int DEFAULT '1',
| `lending_institution` varchar(64) DEFAULT NULL,
| `lending_name` varchar(128) DEFAULT NULL,
| `state` int DEFAULT '1' COMMENT '1待审 2还款中 3驳回 4逾期 5已还款',
| `reason` varchar(512) DEFAULT NULL,
| `id_front_img` varchar(512) DEFAULT NULL,
| `id_back_img` varchar(512) DEFAULT NULL,
| `handheld_img` varchar(512) DEFAULT NULL,
| `create_time` datetime DEFAULT NULL,
| `approve_time` datetime DEFAULT NULL,
| `due_time` datetime DEFAULT NULL,
| `repaid_time` datetime DEFAULT NULL,
| PRIMARY KEY (`uuid`),
| KEY `idx_loan_order_user` (`user_id`),
| KEY `idx_loan_order_state_due` (`state`,`due_time`)
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='贷款订单';
|
| INSERT INTO `t_loan_config` (`uuid`,`term`,`daily_rate`,`max_quota`,`lending_institution`,`lending_name`,`repayment`,`repay_cycle`,`state`,`sort_num`,`create_time`)
| SELECT 'loan_cfg_7', 7, 0.001, 5000, '1', 'Platform Finance', 1, 7, 1, 1, NOW()
| FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM t_loan_config WHERE uuid = 'loan_cfg_7');
|
| INSERT INTO `t_loan_config` (`uuid`,`term`,`daily_rate`,`max_quota`,`lending_institution`,`lending_name`,`repayment`,`repay_cycle`,`state`,`sort_num`,`create_time`)
| SELECT 'loan_cfg_14', 14, 0.001, 10000, '1', 'Platform Finance', 1, 14, 1, 2, NOW()
| FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM t_loan_config WHERE uuid = 'loan_cfg_14');
|
| INSERT INTO `t_loan_config` (`uuid`,`term`,`daily_rate`,`max_quota`,`lending_institution`,`lending_name`,`repayment`,`repay_cycle`,`state`,`sort_num`,`create_time`)
| SELECT 'loan_cfg_30', 30, 0.001, 30000, '1', 'Platform Finance', 1, 30, 1, 3, NOW()
| FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM t_loan_config WHERE uuid = 'loan_cfg_30');
|
| INSERT INTO `t_loan_config` (`uuid`,`term`,`daily_rate`,`max_quota`,`lending_institution`,`lending_name`,`repayment`,`repay_cycle`,`state`,`sort_num`,`create_time`)
| SELECT 'loan_cfg_60', 60, 0.001, 50000, '1', 'Platform Finance', 1, 60, 1, 4, NOW()
| FROM DUAL WHERE NOT EXISTS (SELECT 1 FROM t_loan_config WHERE uuid = 'loan_cfg_60');
|
|
