Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| address_hash | bytea | 2147483647 | null |
|
|
||||||
| address_type | varchar | 255 | null |
|
|
||||||
| block_hash | bytea | 2147483647 | null |
|
|
||||||
| reward | numeric | 100 | √ | null |
|
|
|||||
| inserted_at | timestamp | 22 | null |
|
|
||||||
| updated_at | timestamp | 22 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| block_rewards_pkey | Primary key | Asc/Asc/Asc | address_hash + block_hash + address_type |
| block_rewards_block_hash_index | Performance | Asc | block_hash |