Table Details
| Property | Value |
|---|---|
| Table Name | stellar.raw.operations_v2 |
| Table Status | Production-Ready |
| Unique Key | operation_id |
| Clustering Key(s) | to_date("ledger_close_time") |
| Search Optimization | ledger_sequence, transaction_hash, operation_id, source_account, type |
Table Columns
| Column Name | Data Type | Description |
|---|---|---|
| source_account | VARCHAR(16777216) | Account (G-address) that is the source of this operation. |
| source_account_muxed | VARCHAR(16777216) | Multiplexed (M-address) form of the source account, if used. |
| source_account_muxed_id | VARCHAR(16777216) | 64-bit sub-account id of the multiplexed source account. |
| operation_id | VARCHAR(16777216) | Unique identifier of this operation. |
| type | VARCHAR(16777216) | Operation type name (e.g. payment, create_account). |
| type_id | NUMBER(38,0) | Numeric enum id of the operation type. |
| ledger_sequence | NUMBER(38,0) | Sequence number of the ledger containing this operation. |
| ledger_close_time | TIMESTAMP_NTZ(9) | Time when the ledger containing this operation closed and was finalized. |
| ledger_hash | VARCHAR(16777216) | Hash of the ledger containing this operation. |
| transaction_hash | VARCHAR(16777216) | Hash of the transaction containing this operation. |
| transaction_index | NUMBER(38,0) | Position of the transaction within its ledger. |
| transaction_result | VARCHAR(16777216) | Result code of the transaction containing this operation. |
| transaction_successful | BOOLEAN | True if the transaction containing this operation executed successfully. |
| operation_index | NUMBER(38,0) | Index of this operation within its transaction. |
| operation_details | VARIANT | JSON of this operation’s type-specific fields. |
| _created_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was created in the database. |
| _updated_at | TIMESTAMP_NTZ(9) | Timestamp of when the entry was last updated in the database. |
| transaction_events | VARIANT | Array of token-transfer and SEP-41 events emitted in the transaction. |