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