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)