Memoney
Tables (8)
category_result
- transaction_id — VARCHAR(50) — Foreign key → transactions.transaction_id — NOT NULL
- category — VARCHAR(30) — NOT NULL
- category_confidence — FLOAT — NOT NULL
- method — ENUM('dictionary_match','industry_fallback','keyword_fallback','model_prediction','account_rule') — NOT NULL
- reason — VARCHAR(500)
- merchant_id — VARCHAR(50) — Foreign key → merchants.merchant_id
- model_version — VARCHAR(30) — NOT NULL
- predicted_at — DATETIME — NOT NULL
category_user_correction
- correction_id — INT — Primary key — NOT NULL
- transaction_id — VARCHAR(50) — Foreign key → transactions.transaction_id — NOT NULL
- user_corrected_category — VARCHAR(30) — NOT NULL
- corrected_at — DATETIME — NOT NULL
fixed_expense_profile
- user_id — VARCHAR(50) — Foreign key → personas.persona_id — NOT NULL
- merchant_id — VARCHAR(50) — Foreign key → merchants.merchant_id — NOT NULL
- period — ENUM('weekly','monthly','quarterly','yearly') — NOT NULL
- expected_amount — INT — NOT NULL
- last_seen — DATE — NOT NULL
- status — ENUM('active','ended','pending') — NOT NULL
- confidence — FLOAT — NOT NULL
- user_confirmed — BOOLEAN
- updated_at — DATETIME — NOT NULL
fixed_expense_transaction_result
- transaction_id — VARCHAR(50) — Foreign key → transactions.transaction_id — NOT NULL
- merchant_id — VARCHAR(50) — Foreign key → merchants.merchant_id — NOT NULL
- is_fixed — BOOLEAN — NOT NULL
- confidence — FLOAT — NOT NULL
- reason — VARCHAR(500)
- predicted_at — DATETIME — NOT NULL
fixed_expense_user_correction
- correction_id — INT — Primary key — NOT NULL
- user_id — VARCHAR(50) — Foreign key → fixed_expense_profile.user_id — NOT NULL
- merchant_id — VARCHAR(50) — Foreign key → fixed_expense_profile.merchant_id — NOT NULL
- user_corrected_is_fixed — BOOLEAN — NOT NULL
- corrected_at — DATETIME — NOT NULL
merchants
- merchant_id — VARCHAR(50) — Primary key — NOT NULL
- normalized_name — VARCHAR(200) — NOT NULL
personas
- persona_id — VARCHAR(50) — Primary key — NOT NULL
transactions
- transaction_id — VARCHAR(50) — Primary key — NOT NULL
- persona_id — VARCHAR(50) — Foreign key → personas.persona_id — NOT NULL
- source_type — ENUM('card','account') — NOT NULL
- approved_at — DATETIME — NOT NULL
- amount — INT — NOT NULL
- direction — ENUM('inflow','outflow') — NOT NULL
- raw_merchant_name — VARCHAR(200) — NOT NULL
- merchant_no — VARCHAR(50)
- industry_code — VARCHAR(20)
- card_type — VARCHAR(20)
- installment_months — INT
- tx_type — VARCHAR(30)
- raw_memo — VARCHAR(200)
- balance_after — INT
- is_cancelled — BOOLEAN