thorchain.core Table: dim_labels Type: Base Table
What
A hand curated table containing address names / labels for popular contracts, validators, tokens, etc.Columns
| Column Name | Data Type | Description |
|---|---|---|
| DIM_LABELS_ID | TEXT | DIM_LABELS_ID column |
| BLOCKCHAIN | TEXT | The name of the blockchain |
| CREATOR | TEXT | The name of the creator of the label |
| ADDRESS | TEXT | Address that the label is for. This is the field that should be used to join other tables with labels. |
| LABEL_TYPE | TEXT | A high-level category describing the addresses main function or ownership |
| LABEL_SUBTYPE | TEXT | A sub-category nested within label type providing further detail |
| LABEL | TEXT | Name of the controlling entity of the address |
| ADDRESS_NAME | TEXT | ADDRESS_NAME column |
| _AUDIT_RUN_ID | TEXT | _AUDIT_RUN_ID column |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | The utc timestamp at which the row was inserted into the table. |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | The utc timestamp at which the row was last modified. |