# MV\_TRANSACTION\_TABLE

Contains distributed transaction metadata.

| Column Name           | Description                                                                    |
| --------------------- | ------------------------------------------------------------------------------ |
| `NODE_ID`             | The node the transaction is from (MV).                                         |
| `DATABASE_NAME`       | The name of the database including the partition ordinal.                      |
| `DATABASE_STATE`      | The state of the database (i.e online, replicating, etc.).                     |
| `SHARDED_DATABASE_ID` | The ID of the sharded database.                                                |
| `DATABASE_ROLE`       | The role of the database: Primary or Replica                                   |
| `TRANSACTION_ID`      | The ID of the distributed transaction.                                         |
| `COORDINATOR_ID`      | The ID of the coordinator.                                                     |
| `PREPREPARE_TS`       | The timestamp the transaction selects just before beginning its prepare phase. |
| `TIMESTAMP`           | Timestamp of the commit.                                                       |
| `PARTICIPANT_LIST`    | List of all participants of the distributed transaction.                       |
| `STATE`               | State of the transaction: Prepared, Committed, or Aborted                      |

***

Modified at: June 5, 2023

Source: [/cloud/reference/information-schema-reference/workspace-component/mv-transaction-table/](https://docs.singlestore.com/cloud/reference/information-schema-reference/workspace-component/mv-transaction-table/)

(An index of the documentation is available at /llms.txt)