Table Description
This table contains data about messages contained within transactions in the Echelon blockchain, including message types, content, and associated metadata.Column Descriptions
| Column name | Data Type | Description |
|---|---|---|
| block_date | date | The date of the block. |
| block_height | bigint | The height of the block where the message occurred. |
| block_timestamp | timestamp(3) with time zone | Timestamp when the block was validated. |
| chain_id | varchar | The ID of the chain where the message belongs. |
| tx_id | varchar | The hash of the transaction containing the message. |
| tx_index | bigint | The index of the transaction in the block. |
| message_index | bigint | The index of the message in the transaction. |
| message_type | varchar | The type of message. |
| message | varchar | The value/content of the message. |
| schema_version | bigint | The version of the schema in provider database. |
| updated_at | timestamp(3) with time zone | Timestamp of when the record was last updated. |
| ingested_at | timestamp(3) with time zone | Timestamp of when the record was ingested into Dune. |