eclipse.gov Table: fact_votes Type: Base Table
A table that contains high level information about native vote program events on the Eclipse
blockchain.
Columns
| Column Name | Data Type | Description |
|---|---|---|
| BLOCK_TIMESTAMP | TIMESTAMP_NTZ | The date and time at which the block began. |
| BLOCK_ID | NUMBER | Slot for which a block can be created. |
| TX_ID | TEXT | A unique key that identifies a transaction |
| INDEX | VARIANT | The order in which the transaction was executed in a given slot |
| RECENT_BLOCK_HASH | TEXT | Previous block’s hash value |
| SIGNERS | ARRAY | List of accounts that signed the transaction |
| FEE | NUMBER | Transaction fee (in lamports) |
| SUCCEEDED | BOOLEAN | True when a transaction is successful, otherwise false. |
| ACCOUNT_KEYS | ARRAY | List of accounts that are referenced by pre/post sol/token balances objects |
| VOTE_INDEX | NUMBER | Index of the vote within a transaction |
| EVENT_TYPE | TEXT | The type of vote event that is occurring |
| INSTRUCTION | VARIANT | Vote program specific instruction |
| VERSION | TEXT | Transaction version, legacy version is listed as NULL or ‘legacy’ |
| FACT_VOTES_ID | TEXT | The unique identifier for each row in the table. |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | The timestamp at which the record was initially created and inserted into this table. |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | The timestamp at which this record was last modified by an internal process. |