moneo

Tables (7)

cate

  • Key (cate_num) — Primary key — NOT NULL
  • Field (cate_name)
  • Field

category

  • cate_id — NUMBER — Primary key — NOT NULL
  • cate_name — VARCHAR2(50) — NOT NULL

chat_messages

  • id — uuid — Primary key — NOT NULL
  • thread_id — uuid — Foreign key → chat_threads.id — NOT NULL
  • role — text — NOT NULL
  • content — text — NOT NULL
  • created_at — timestamp — NOT NULL

chat_threads

  • id — uuid — Primary key — NOT NULL
  • user_id — uuid — Foreign key → users.id — NOT NULL
  • title — text — NOT NULL
  • memory_summary — text
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • Key (cate_num) — Foreign key → cate.Key — NOT NULL

user_budget

  • budget_id — NUMBER — Primary key — NOT NULL
  • u_id — NUMBER — Foreign key — NOT NULL
  • cate_id — NUMBER — Foreign key → category.cate_id — NOT NULL
  • budget_limit — NUMBER(12,2) — NOT NULL
  • budget_month — VARCHAR2(7) — NOT NULL — Format 'YYYY-MM', e.g. '2026-09'.

user_tran

  • tran_num — NUMBER — Primary key — NOT NULL
  • u_id — NUMBER — Foreign key — NOT NULL
  • cate_id — NUMBER — Foreign key → category.cate_id — NOT NULL
  • type — CHAR(1) — NOT NULL — '+' for income, '-' for expense.
  • amount — NUMBER(12,2) — NOT NULL — 'Always stored positive
  • merchant — VARCHAR2(200)
  • tran_date — DATE — NOT NULL
  • pay_method — VARCHAR2(50) — e.g. Card, Cash, Transfer.
  • memo — VARCHAR2(500) — Free-text note about the transaction.

users

  • id — varchar(30) — Primary key — NOT NULL
  • email — varchar2(100) — NOT NULL
  • user_metadata — jsonb