-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathschema.sql
154 lines (153 loc) · 4.6 KB
/
schema.sql
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
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
CREATE TABLE IF NOT EXISTS factory_admin_changed (
"evt_tx_hash" VARCHAR(64),
"evt_index" INT,
"evt_block_time" TIMESTAMP,
"evt_block_number" DECIMAL,
"new_admin" VARCHAR(40),
"previous_admin" VARCHAR(40),
PRIMARY KEY(evt_tx_hash,evt_index)
);
CREATE TABLE IF NOT EXISTS factory_beacon_upgraded (
"evt_tx_hash" VARCHAR(64),
"evt_index" INT,
"evt_block_time" TIMESTAMP,
"evt_block_number" DECIMAL,
"beacon" VARCHAR(40),
PRIMARY KEY(evt_tx_hash,evt_index)
);
CREATE TABLE IF NOT EXISTS factory_deployed_lender_group_contract (
"evt_tx_hash" VARCHAR(64),
"evt_index" INT,
"evt_block_time" TIMESTAMP,
"evt_block_number" DECIMAL,
"group_contract" VARCHAR(40),
PRIMARY KEY(evt_tx_hash,evt_index)
);
CREATE TABLE IF NOT EXISTS factory_upgraded (
"evt_tx_hash" VARCHAR(64),
"evt_index" INT,
"evt_block_time" TIMESTAMP,
"evt_block_number" DECIMAL,
"implementation" VARCHAR(40),
PRIMARY KEY(evt_tx_hash,evt_index)
);
CREATE TABLE IF NOT EXISTS lendergroup_borrower_accepted_funds (
"evt_tx_hash" VARCHAR(64),
"evt_index" INT,
"evt_block_time" TIMESTAMP,
"evt_block_number" DECIMAL,
"evt_address" VARCHAR(40),
"bid_id" DECIMAL,
"borrower" VARCHAR(40),
"collateral_amount" DECIMAL,
"interest_rate" INT,
"loan_duration" INT,
"principal_amount" DECIMAL,
PRIMARY KEY(evt_tx_hash,evt_index)
);
CREATE TABLE IF NOT EXISTS lendergroup_defaulted_loan_liquidated (
"evt_tx_hash" VARCHAR(64),
"evt_index" INT,
"evt_block_time" TIMESTAMP,
"evt_block_number" DECIMAL,
"evt_address" VARCHAR(40),
"amount_due" DECIMAL,
"bid_id" DECIMAL,
"liquidator" VARCHAR(40),
"token_amount_difference" DECIMAL,
PRIMARY KEY(evt_tx_hash,evt_index)
);
CREATE TABLE IF NOT EXISTS lendergroup_earnings_withdrawn (
"evt_tx_hash" VARCHAR(64),
"evt_index" INT,
"evt_block_time" TIMESTAMP,
"evt_block_number" DECIMAL,
"evt_address" VARCHAR(40),
"amount_pool_shares_tokens" DECIMAL,
"lender" VARCHAR(40),
"principal_tokens_withdrawn" DECIMAL,
"recipient" VARCHAR(40),
PRIMARY KEY(evt_tx_hash,evt_index)
);
CREATE TABLE IF NOT EXISTS lendergroup_initialized (
"evt_tx_hash" VARCHAR(64),
"evt_index" INT,
"evt_block_time" TIMESTAMP,
"evt_block_number" DECIMAL,
"evt_address" VARCHAR(40),
"version" INT,
PRIMARY KEY(evt_tx_hash,evt_index)
);
CREATE TABLE IF NOT EXISTS lendergroup_lender_added_principal (
"evt_tx_hash" VARCHAR(64),
"evt_index" INT,
"evt_block_time" TIMESTAMP,
"evt_block_number" DECIMAL,
"evt_address" VARCHAR(40),
"amount" DECIMAL,
"lender" VARCHAR(40),
"shares_amount" DECIMAL,
"shares_recipient" VARCHAR(40),
PRIMARY KEY(evt_tx_hash,evt_index)
);
CREATE TABLE IF NOT EXISTS lendergroup_loan_repaid (
"evt_tx_hash" VARCHAR(64),
"evt_index" INT,
"evt_block_time" TIMESTAMP,
"evt_block_number" DECIMAL,
"evt_address" VARCHAR(40),
"bid_id" DECIMAL,
"interest_amount" DECIMAL,
"principal_amount" DECIMAL,
"repayer" VARCHAR(40),
"total_interest_collected" DECIMAL,
"total_principal_repaid" DECIMAL,
PRIMARY KEY(evt_tx_hash,evt_index)
);
CREATE TABLE IF NOT EXISTS lendergroup_ownership_transferred (
"evt_tx_hash" VARCHAR(64),
"evt_index" INT,
"evt_block_time" TIMESTAMP,
"evt_block_number" DECIMAL,
"evt_address" VARCHAR(40),
"new_owner" VARCHAR(40),
"previous_owner" VARCHAR(40),
PRIMARY KEY(evt_tx_hash,evt_index)
);
CREATE TABLE IF NOT EXISTS lendergroup_paused (
"evt_tx_hash" VARCHAR(64),
"evt_index" INT,
"evt_block_time" TIMESTAMP,
"evt_block_number" DECIMAL,
"evt_address" VARCHAR(40),
"account" VARCHAR(40),
PRIMARY KEY(evt_tx_hash,evt_index)
);
CREATE TABLE IF NOT EXISTS lendergroup_pool_initialized (
"evt_tx_hash" VARCHAR(64),
"evt_index" INT,
"evt_block_time" TIMESTAMP,
"evt_block_number" DECIMAL,
"evt_address" VARCHAR(40),
"collateral_token_address" VARCHAR(40),
"interest_rate_lower_bound" INT,
"interest_rate_upper_bound" INT,
"liquidity_threshold_percent" INT,
"loan_to_value_percent" INT,
"market_id" DECIMAL,
"max_loan_duration" INT,
"pool_shares_token" VARCHAR(40),
"principal_token_address" VARCHAR(40),
"twap_interval" INT,
"uniswap_pool_fee" INT,
PRIMARY KEY(evt_tx_hash,evt_index)
);
CREATE TABLE IF NOT EXISTS lendergroup_unpaused (
"evt_tx_hash" VARCHAR(64),
"evt_index" INT,
"evt_block_time" TIMESTAMP,
"evt_block_number" DECIMAL,
"evt_address" VARCHAR(40),
"account" VARCHAR(40),
PRIMARY KEY(evt_tx_hash,evt_index)
);