> For the complete documentation index, see [llms.txt](https://docs.pay.imal.dev/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.pay.imal.dev/database-schemas/transactions-table.md).

# Transactions table

* Table name: transactions
* Columns: 14

## Brief Columns description

* merchantName: type: text, escaped merchant name
* txDescription: type:text, description of the transaction
* txToken: type:varchar(100), tti\_ of the token used for the transaction
* txAmount: type:text, raw amount of the token used for the transaction
* mmSeed: type:text, AES256 encrypted middleman account seed
* mmAddress: type:varchar(100), address of the middleman account
* txMemo: type:text, memo of the transaction
* txDeadline: type:varchar(100), unix timestamp of the transaction expiration
* txID: type:varchar(100), transaction ID
* txDestination: type:varchar(100), merchant's vite address
* mechantVerified: type:varchar(100), status of merchant verification (true/false)
* txHash: type:varchar(100), hash of the transaction that confirmations should be awaited for
* redirectURL: type:text, "Back to merchant" URL
* css: type:text, optional css used to style the merchant's name, settable in merchants table
