This repository has been archived by the owner on Jun 7, 2024. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathaxies_schema.yaml
338 lines (337 loc) · 7.23 KB
/
axies_schema.yaml
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
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
version: 8
engine_version: 3
name: axies
tables:
_dlt_loads:
columns:
inserted_at:
data_type: timestamp
nullable: false
load_id:
data_type: text
nullable: false
status:
data_type: bigint
nullable: false
write_disposition: append
_dlt_version:
columns:
engine_version:
data_type: bigint
nullable: false
inserted_at:
data_type: timestamp
nullable: false
version:
data_type: bigint
nullable: false
write_disposition: append
blocks:
columns:
_dlt_load_id:
data_type: text
nullable: false
_dlt_id:
unique: true
data_type: text
nullable: false
block_number:
primary_key: true
cluster: true
data_type: bigint
nullable: false
block_timestamp:
unique: true
sort: true
partition: true
data_type: timestamp
nullable: false
parent_hash:
data_type: text
nullable: true
block_hash:
unique: true
data_type: text
nullable: false
base_fee_per_gas:
data_type: wei
nullable: true
difficulty:
data_type: wei
nullable: false
extra_data:
data_type: text
nullable: true
gas_limit:
data_type: bigint
nullable: false
gas_used:
data_type: bigint
nullable: false
logs_bloom:
data_type: binary
nullable: true
miner:
data_type: text
nullable: true
mix_hash:
data_type: text
nullable: true
nonce:
data_type: text
nullable: true
receipts_root:
data_type: text
nullable: true
sha3_uncles:
data_type: text
nullable: true
size:
data_type: bigint
nullable: true
state_root:
data_type: text
nullable: false
total_difficulty:
data_type: wei
nullable: true
transactions_root:
data_type: text
nullable: false
write_disposition: append
blocks__transactions:
columns:
_dlt_id:
unique: true
data_type: text
nullable: false
block_number:
cluster: true
primary_key: true
foreign_key: true
data_type: bigint
nullable: false
transaction_index:
primary_key: true
data_type: bigint
nullable: false
transaction_hash:
unique: true
data_type: text
nullable: false
block_hash:
data_type: text
nullable: false
block_timestamp:
sort: true
partition: true
data_type: timestamp
nullable: false
chain_id:
data_type: text
nullable: true
from:
data_type: text
nullable: true
gas:
data_type: bigint
nullable: true
gas_price:
data_type: bigint
nullable: true
input:
data_type: text
nullable: true
max_fee_per_gas:
data_type: wei
nullable: true
max_priority_fee_per_gas:
data_type: wei
nullable: true
nonce:
data_type: bigint
nullable: true
r:
data_type: text
nullable: true
s:
data_type: text
nullable: true
status:
data_type: bigint
nullable: true
to:
data_type: text
nullable: true
type:
data_type: text
nullable: true
v:
data_type: bigint
nullable: true
value:
data_type: wei
nullable: false
parent: blocks
blocks__transactions__logs:
columns:
_dlt_id:
unique: true
data_type: text
nullable: false
address:
data_type: text
nullable: false
block_timestamp:
sort: true
partition: true
data_type: timestamp
nullable: false
block_hash:
data_type: text
nullable: false
block_number:
cluster: true
primary_key: true
foreign_key: true
data_type: bigint
nullable: false
transaction_index:
primary_key: true
foreign_key: true
data_type: bigint
nullable: false
log_index:
primary_key: true
data_type: bigint
nullable: false
data:
data_type: text
nullable: true
removed:
data_type: bool
nullable: true
transaction_hash:
data_type: text
nullable: false
parent: blocks__transactions
blocks__transactions__logs__topics:
columns:
_dlt_parent_id:
foreign_key: true
data_type: text
nullable: false
_dlt_list_idx:
data_type: bigint
nullable: false
_dlt_id:
unique: true
data_type: text
nullable: false
value:
data_type: text
nullable: true
parent: blocks__transactions__logs
blocks__transactions__access_list:
columns:
_dlt_parent_id:
foreign_key: true
data_type: text
nullable: false
_dlt_list_idx:
data_type: bigint
nullable: false
_dlt_id:
unique: true
data_type: text
nullable: false
address:
data_type: text
nullable: true
parent: blocks__transactions
blocks__transactions__access_list__storage_keys:
columns:
_dlt_parent_id:
foreign_key: true
data_type: text
nullable: false
_dlt_list_idx:
data_type: bigint
nullable: false
_dlt_id:
unique: true
data_type: text
nullable: false
value:
data_type: text
nullable: true
parent: blocks__transactions__access_list
blocks__uncles:
columns:
_dlt_parent_id:
foreign_key: true
data_type: text
nullable: false
_dlt_list_idx:
data_type: bigint
nullable: false
_dlt_id:
unique: true
data_type: text
nullable: false
value:
data_type: text
nullable: true
parent: blocks
known_contracts:
columns:
address:
data_type: text
nullable: false
name:
data_type: text
nullable: false
_dlt_load_id:
data_type: text
nullable: false
_dlt_id:
unique: true
data_type: text
nullable: false
write_disposition: replace
settings:
default_hints:
foreign_key:
- _dlt_parent_id
not_null:
- _dlt_id
- _dlt_parent_id
- _dlt_list_idx
- _dlt_load_id
- block_number
- block_timestamp
cluster:
- block_number
partition:
- block_timestamp
sort:
- block_timestamp
unique:
- _dlt_id
preferred_types:
# all fields containing genes should be text
"re:[Gg]ene": text
normalizers:
names: dlt.common.normalizers.names.snake_case
detections:
- timestamp
- large_integer
- hexbytes_to_text
- wei_to_double
json:
module: dlt.common.normalizers.json.relational
config:
propagation:
root:
block_number: block_number
block_timestamp: block_timestamp