MoneyMate

Tables (3)

categories (카테고리)

  • id (카테고리ID) — BIGINT — Primary key — NOT NULL
  • name (카테고리명) — VARCHAR(50)
  • type (타입) — VARCHAR(20)

ledger_items (가계부내역)

  • id (내역ID) — BIGINT — Primary key — NOT NULL
  • title (내용) — VARCHAR(100)
  • amount (금액) — BIGINT
  • transaction_date (거래일자) — DATE
  • created_at (생성일시) — DATETIME
  • updated_at (수정일시) — DATETIME
  • user_id (유저ID) — BIGINT — Foreign key → user.id — NOT NULL
  • category_id (카테고리ID) — BIGINT — Foreign key → categories.id — NOT NULL

user (회원)

  • id (유저ID) — BIGINT — Primary key — NOT NULL
  • username (사용자명) — VARCHAR(50)