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

accounts_partitioned

  • LIKE — accounts

accounts_shard_0

  • modulus — 8
  • remainder — 0

accounts_shard_1

  • modulus — 8
  • remainder — 1

accounts_shard_2

  • modulus — 8
  • remainder — 2

accounts_shard_3

  • modulus — 8
  • remainder — 3

accounts_shard_4

  • modulus — 8
  • remainder — 4

accounts_shard_5

  • modulus — 8
  • remainder — 5

accounts_shard_6

  • modulus — 8
  • remainder — 6

accounts_shard_7

  • modulus — 8
  • remainder — 7

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_202401

  • 2024-01-01) — TO

ledger_entries_202402

  • 2024-02-01) — TO

ledger_entries_202403

  • 2024-03-01) — TO

ledger_entries_partitioned

  • LIKE — ledger_entries

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