| ID | NUMBER | Unique identifier for the transaction |
| TRANSACTION_HASH | TEXT | Hash of the transaction. |
| LEDGER_SEQUENCE | NUMBER | The sequence number of the ledger. |
| CLOSED_AT | TIMESTAMP_NTZ | Timestamp when the ledger was closed and committed to the network. Ledgers are expected to close ~every 5 seconds. |
| BLOCK_TIMESTAMP | TIMESTAMP_NTZ | A clone of closed_at for join convenience. |
| ACCOUNT | TEXT | The account involved in the operation. |
| ACCOUNT_SEQUENCE | NUMBER | Sequence number for the account. |
| MAX_FEE | NUMBER | Maximum fee for the transaction. |
| OPERATION_COUNT | NUMBER | The total number of successful operations applied to this ledger. |
| CREATED_AT | TIMESTAMP_NTZ | Creation timestamp of the transaction. |
| MEMO_TYPE | TEXT | Type of memo attached to transaction. |
| MEMO | TEXT | Memo content of the transaction. |
| TIME_BOUNDS | TEXT | Time bounds for transaction validity. |
| SUCCESSFUL | BOOLEAN | Whether the operation was successful. |
| FEE_CHARGED | NUMBER | Actual fee charged for the operation. |
| INNER_TRANSACTION_HASH | TEXT | A transaction hash of a transaction wrapped with its signatures for fee-bump transactions |
| FEE_ACCOUNT | TEXT | Account charged the fee. |
| NEW_MAX_FEE | NUMBER | Updated maximum fee. |
| ACCOUNT_MUXED | TEXT | Muxed account identifier. |
| FEE_ACCOUNT_MUXED | TEXT | Muxed fee account identifier. |
| BATCH_ID | TEXT | String representation of the run id for a given DAG in Airflow. Takes the form of “scheduled__<batch_end_date>-<dag_alias>”. Batch ids are unique to the batch and help with monitoring and rerun capabilities. |
| BATCH_RUN_DATE | TIMESTAMP_NTZ | The start date for the batch interval. When taken with the date in the batch_id, the date represents the interval of ledgers processed. The batch run date can be seen as a proxy of closed_at for a ledger. |
| BATCH_INSERT_TS | TIMESTAMP_NTZ | The timestamp in UTC when a batch of records was inserted into the database. This field can help identify if a batch executed in real time or as part of a backfill. The timestamp should not be used during ad hoc analysis and is useful for data engineering purposes. |
| LEDGER_BOUNDS | TEXT | Bounds of the ledger. |
| MIN_ACCOUNT_SEQUENCE | NUMBER | Minimum account sequence number. |
| MIN_ACCOUNT_SEQUENCE_AGE | NUMBER | Minimum age of account sequence. |
| MIN_ACCOUNT_SEQUENCE_LEDGER_GAP | NUMBER | Minimum gap in ledger sequences. |
| TX_ENVELOPE | TEXT | A base-64 encoded XDR blob of the tx envelope (transaction and its signatures) |
| TX_RESULT | TEXT | A base-64 encoded XDR blob of the tx result |
| TX_META | TEXT | A base-64 encoded XDR blob of the tx meta |
| TX_FEE_META | TEXT | A base-64 encoded XDR blob of the tx fee meta |
| EXTRA_SIGNERS | ARRAY | Additional transaction signers. |
| RESOURCE_FEE | NUMBER | Fee for resource usage. |
| SOROBAN_RESOURCES_INSTRUCTIONS | NUMBER | Instructions for Soroban resources. |
| SOROBAN_RESOURCES_READ_BYTES | NUMBER | Bytes read by Soroban resources. |
| SOROBAN_RESOURCES_WRITE_BYTES | NUMBER | Bytes written by Soroban resources. |
| TRANSACTION_RESULT_CODE | TEXT | Result code of the transaction. |
| INCLUSION_FEE_BID | NUMBER | Bid for inclusion fee. |
| INCLUSION_FEE_CHARGED | NUMBER | Actual inclusion fee charged. |
| RESOURCE_FEE_REFUND | NUMBER | Refund of resource fee. |
| NON_REFUNDABLE_RESOURCE_FEE_CHARGED | NUMBER | The amount of the resource fee charged for the transaction that is non-refundable. |
| REFUNDABLE_RESOURCE_FEE_CHARGED | NUMBER | The amount of the resource fee charged for the transaction that is refundable. |
| RENT_FEE_CHARGED | NUMBER | The fee charged for renting resources on the network, such as storage space for data. |
| TX_SIGNERS | TEXT | The public keys of the signers who authorized the transaction. |
| REFUNDABLE_FEE | NUMBER | The portion of the transaction fee that is refundable under certain conditions. |
| FACT_TRANSACTIONS_ID | TEXT | Unique primary key for the dimension table, used as the main identifier for each record. |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | Timestamp when this record was inserted. |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | Timestamp when this record was last modified. |
