final_moneo
Tables (4)
category
- cate_id — NUMBER — Primary key — NOT NULL
- cate_name — VARCHAR2(50) — NOT NULL
user_budget
- budget_id — NUMBER — Primary key — NOT NULL
- u_id — NUMBER — Foreign key → users.u_id — 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
- 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.
- u_id — NUMBER — Foreign key → users.u_id — NOT NULL
- cate_id — NUMBER — Foreign key → category.cate_id — NOT NULL
users
- u_id — NUMBER — Primary key — NOT NULL
- name — VARCHAR2(100) — NOT NULL
- email — VARCHAR2(255) — NOT NULL
- password — VARCHAR2(255) — NOT NULL — Store a hashed password here, never plain text.