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
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
| @startuml
class Products #cyan {
Loan Products
==
#id
--
+name : varchar(128) -- name of product
amount : decimal(19,4) NOT NULL -- amount of money
days : int unsigned -- loan days
preloanFee : decimal(19,4) NOT NULL -- poundage
installments : int unsigned NOT NULL -- by stages times
interestRate : decimal(22,7) NOT NULL -- interest rate
overdueInterestRate : decimal(22,7) NOT NULL -- overdue interest rate
minCredit : int unsigned -- min credit lines
}
note as N2
comment
open-market product: <b>minCredit=0</b>
white-list product: <b>minCredit=1</b>
salary-deduction product: <b>minCredit=2</b>
end note
N2 . Products
class Accounts #cyan {
Investor & Borrower Accounts
==
#id
id_Person : bigint unsigned
id_Certificate : bigint unsigned
--
+name : varchar(128)
+mobile : varchar(128)
passWordWrongNumber : int -- times of wrong password
lockedAt : datetime -- account locked time
credit : int unsigned -- credit lines
openId : varchar(128) -- single token oauth returned
..
isLocked : boolean
}
note as N1
open-market account: <b>credit=0</b>
white-list account: <b>credit=1</b>
salary-deduction account: <b>credit=2</b>
end note
N1 . Accounts
class Loans #cyan {
Loans information
==
#id
id_Borrower : bigint unsigned
id_Investor : bigint unsigned
id_Product : bigint unsigned
--
purpose : varchar(128)
status : varchar(128)
instanceId : bigint unsigned
term : varchar(128)
loanToken : varchar(128)
..
principal : decimal(20,6) default 0
fee : decimal(20,6) default 0
interest : decimal(20,6) default 0
overdueInterest : decimal(20,6) default 0
amount : decimal(16,2) default 0
..
repaidPrincipal : decimal(20,6) default 0
repaidFee : decimal(20,6) default 0
repaidInterest : decimal(20,6) default 0
repaidOverdueInterest : decimal(20,6) default 0
}
Loans --> Products
Loans --> Accounts
@enduml
|
