Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| nephew_hash | bytea | 2147483647 | null |
|
|
||||||
| uncle_hash | bytea | 2147483647 | null |
|
|
||||||
| uncle_fetched_at | timestamp | 29,6 | √ | null |
|
|
|||||
| index | int4 | 10 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| block_second_degree_relations_pkey | Primary key | Asc/Asc | nephew_hash + uncle_hash |
| nephew_hash_to_uncle_hash | Must be unique | Asc/Asc | nephew_hash + uncle_hash |
| uncle_hash_to_nephew_hash | Must be unique | Asc/Asc | uncle_hash + nephew_hash |
| unfetched_uncles | Must be unique | Asc/Asc | nephew_hash + uncle_hash |