example

Tables (6)

category_map

  • id — INTEGER
  • source_type — TEXT — NOT NULL
  • source_code — TEXT — NOT NULL
  • major_category — TEXT — NOT NULL
  • minor_category — TEXT — NOT NULL
  • description — TEXT

ledger_accounts

  • id — INTEGER
  • source_domain — TEXT — NOT NULL
  • source_key — TEXT — NOT NULL
  • display_name — TEXT — NOT NULL
  • is_active — INTEGER — NOT NULL
  • created_at — TEXT — NOT NULL
  • updated_at — TEXT — NOT NULL

ledger_transactions

  • id — INTEGER
  • raw_id — INTEGER — Foreign key → raw_transactions.id
  • parent_id — INTEGER — Foreign key → ledger_transactions.id
  • occurred_at — TEXT — NOT NULL
  • tx_type — TEXT — NOT NULL
  • major_category — TEXT — NOT NULL
  • minor_category — TEXT — NOT NULL
  • amount — REAL — NOT NULL
  • description — TEXT — NOT NULL
  • payment_method — TEXT — NOT NULL
  • tag — TEXT
  • memo — TEXT
  • is_deleted — INTEGER — NOT NULL
  • created_at — TEXT — NOT NULL

raw_accounts

  • id — INTEGER
  • domain — TEXT — NOT NULL
  • account_key — TEXT — NOT NULL
  • prod_name — TEXT
  • account_type — TEXT
  • card_num_masked — TEXT
  • balance_amt — REAL — NOT NULL
  • currency_code — TEXT — NOT NULL
  • is_minus — INTEGER
  • is_charge — INTEGER
  • is_withdrawable — INTEGER
  • is_pay — INTEGER
  • account_id — TEXT
  • fetched_at — TEXT — NOT NULL
  • sync_id — INTEGER — Foreign key → sync_history.id

raw_transactions

  • id — INTEGER
  • domain — TEXT — NOT NULL
  • account_key — TEXT — NOT NULL
  • occurred_at — TEXT — NOT NULL
  • source_ref_no — TEXT
  • trans_type — TEXT — NOT NULL
  • pay_type — TEXT
  • amount — REAL — NOT NULL
  • balance_snapshot — REAL
  • merchant_name — TEXT
  • category_raw — TEXT
  • memo_raw — TEXT
  • currency_code — TEXT — NOT NULL
  • fetched_at — TEXT — NOT NULL
  • sync_id — INTEGER — Foreign key → sync_history.id

sync_history

  • id — INTEGER
  • api_id — TEXT — NOT NULL
  • api_uri — TEXT — NOT NULL
  • identifier — TEXT
  • from_date — TEXT — NOT NULL
  • to_date — TEXT — NOT NULL
  • status — TEXT — NOT NULL
  • fetched_count — INTEGER — NOT NULL
  • error_msg — TEXT
  • started_at — TEXT — NOT NULL
  • finished_at — TEXT
  • duration_ms — INTEGER