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.