-
Notifications
You must be signed in to change notification settings - Fork 0
/
schema.sql
executable file
·36 lines (35 loc) · 933 Bytes
/
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
CREATE TABLE IF NOT EXISTS approvals (
"evt_tx_hash" VARCHAR(64),
"evt_index" INT,
"evt_block_time" TIMESTAMP,
"evt_block_number" DECIMAL,
"approved" VARCHAR(40),
"owner" VARCHAR(40),
"token_id" DECIMAL
);
CREATE TABLE IF NOT EXISTS approval_for_alls (
"evt_tx_hash" VARCHAR(64),
"evt_index" INT,
"evt_block_time" TIMESTAMP,
"evt_block_number" DECIMAL,
"approved" BOOL,
"operator" VARCHAR(40),
"owner" VARCHAR(40)
);
CREATE TABLE IF NOT EXISTS ownership_transferreds (
"evt_tx_hash" VARCHAR(64),
"evt_index" INT,
"evt_block_time" TIMESTAMP,
"evt_block_number" DECIMAL,
"new_owner" VARCHAR(40),
"previous_owner" VARCHAR(40)
);
CREATE TABLE IF NOT EXISTS transfers (
"evt_tx_hash" VARCHAR(64),
"evt_index" INT,
"evt_block_time" TIMESTAMP,
"evt_block_number" DECIMAL,
"from" VARCHAR(40),
"to" VARCHAR(40),
"token_id" DECIMAL
);