Database Schema Overview

This document provides an overview of the database schema used by the Salescentri platform.

Core Tables

Wallets

Stores wallet information including balances and metadata.

ColumnTypeDescription
iduuidPrimary key
account_iduuidReference to account
balancedecimalCurrent balance
currencyvarcharCurrency code
created_attimestampCreation time
updated_attimestampLast update time

Transactions

Records of wallet transactions and balance changes.

Relationships

  • One Account has many Wallets
  • One Wallet has many Transactions