-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathschema.clickhouse.sql
140 lines (139 loc) · 4.88 KB
/
schema.clickhouse.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
CREATE TABLE IF NOT EXISTS factory_admin_changed (
"evt_tx_hash" VARCHAR(64),
"evt_index" INT,
"evt_block_time" TIMESTAMP,
"evt_block_number" UInt64,
"new_admin" VARCHAR(40),
"previous_admin" VARCHAR(40)
) ENGINE = MergeTree 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" UInt64,
"beacon" VARCHAR(40)
) ENGINE = MergeTree 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" UInt64,
"group_contract" VARCHAR(40)
) ENGINE = MergeTree 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" UInt64,
"implementation" VARCHAR(40)
) ENGINE = MergeTree 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" UInt64,
"evt_address" VARCHAR(40),
"bid_id" UInt256,
"borrower" VARCHAR(40),
"collateral_amount" UInt256,
"interest_rate" UInt16,
"loan_duration" UInt32,
"principal_amount" UInt256
) ENGINE = MergeTree 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" UInt64,
"evt_address" VARCHAR(40),
"amount_due" UInt256,
"bid_id" UInt256,
"liquidator" VARCHAR(40),
"token_amount_difference" Int256
) ENGINE = MergeTree 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" UInt64,
"evt_address" VARCHAR(40),
"amount_pool_shares_tokens" UInt256,
"lender" VARCHAR(40),
"principal_tokens_withdrawn" UInt256,
"recipient" VARCHAR(40)
) ENGINE = MergeTree 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" UInt64,
"evt_address" VARCHAR(40),
"version" UInt8
) ENGINE = MergeTree 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" UInt64,
"evt_address" VARCHAR(40),
"amount" UInt256,
"lender" VARCHAR(40),
"shares_amount" UInt256,
"shares_recipient" VARCHAR(40)
) ENGINE = MergeTree 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" UInt64,
"evt_address" VARCHAR(40),
"bid_id" UInt256,
"interest_amount" UInt256,
"principal_amount" UInt256,
"repayer" VARCHAR(40),
"total_interest_collected" UInt256,
"total_principal_repaid" UInt256
) ENGINE = MergeTree 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" UInt64,
"evt_address" VARCHAR(40),
"new_owner" VARCHAR(40),
"previous_owner" VARCHAR(40)
) ENGINE = MergeTree 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" UInt64,
"evt_address" VARCHAR(40),
"account" VARCHAR(40)
) ENGINE = MergeTree 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" UInt64,
"evt_address" VARCHAR(40),
"collateral_token_address" VARCHAR(40),
"interest_rate_lower_bound" UInt16,
"interest_rate_upper_bound" UInt16,
"liquidity_threshold_percent" UInt16,
"loan_to_value_percent" UInt16,
"market_id" UInt256,
"max_loan_duration" UInt32,
"pool_shares_token" VARCHAR(40),
"principal_token_address" VARCHAR(40),
"twap_interval" UInt32,
"uniswap_pool_fee" UInt32
) ENGINE = MergeTree 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" UInt64,
"evt_address" VARCHAR(40),
"account" VARCHAR(40)
) ENGINE = MergeTree PRIMARY KEY ("evt_tx_hash","evt_index");