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