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