monolithic-core
Tables (18)
accounts
- id — SERIAL
- account_id — VARCHAR(50) — NOT NULL
- user_id — VARCHAR(50) — NOT NULL
- asset_type — VARCHAR(20) — NOT NULL
- balance — NUMERIC(30, 10) — NOT NULL
- available_balance — NUMERIC(30, 10) — NOT NULL
- frozen_balance — NUMERIC(30, 10) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
audit_logs
- id — SERIAL
- action — VARCHAR(50) — NOT NULL
- entity_type — VARCHAR(50) — NOT NULL
- entity_id — VARCHAR(64) — NOT NULL
- user_id — VARCHAR(50) — NOT NULL
- old_state — JSONB
- new_state — JSONB
- ip_address — VARCHAR(50)
- created_at — TIMESTAMP — NOT NULL
ledger_entries
- id — SERIAL
- entry_id — VARCHAR(64) — NOT NULL
- transaction_id — VARCHAR(64) — NOT NULL
- account_id — VARCHAR(50) — NOT NULL
- entry_type — VARCHAR(20) — NOT NULL
- amount — NUMERIC(30, 10) — NOT NULL
- balance_after — NUMERIC(30, 10) — NOT NULL
- asset_type — VARCHAR(20) — NOT NULL
- description — TEXT
- status — VARCHAR(20) — NOT NULL
- reference_id — VARCHAR(64)
- created_at — TIMESTAMP — NOT NULL
ledger_entries_partitioned
reconciliation_records
- id — SERIAL
- asset_type — VARCHAR(20) — NOT NULL
- internal_balance — NUMERIC(30, 10) — NOT NULL
- external_balance — NUMERIC(30, 10) — NOT NULL
- discrepancy — NUMERIC(30, 10) — NOT NULL
- reconciled — BOOLEAN — NOT NULL
- remarks — TEXT
- created_at — TIMESTAMP — NOT NULL
- reconciled_at — TIMESTAMP
transactions
- id — SERIAL
- transaction_id — VARCHAR(64) — NOT NULL
- transaction_type — VARCHAR(30) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- source_account_id — VARCHAR(50)
- destination_account_id — VARCHAR(50)
- asset_type — VARCHAR(20) — NOT NULL
- amount — NUMERIC(30, 10) — NOT NULL
- fee — NUMERIC(30, 10) — NOT NULL
- required_signatures — INT — NOT NULL
- collected_signatures — INT — NOT NULL
- metadata — JSONB
- external_id — VARCHAR(128)
- blockchain_tx_hash — VARCHAR(128)
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- completed_at — TIMESTAMP