expense-manager
Tables (5)
budget (예산)
- 식별자 (budget_id) — bigint — Primary key — NOT NULL
- 식별자 (member_category_id) — bigint — Foreign key → member_category.식별자 — NOT NULL
- 예산금액 (amount) — bigint — NOT NULL
- 월 (month) — datetime — NOT NULL
category (카테고리)
- 식별자 (category_id) — bigint — Primary key — NOT NULL
- 카테고리 이름 (name) — varchar(20) — NOT NULL
expense (지출)
- 식별자 (expense_id) — bigint — Primary key — NOT NULL
- 식별자 (member_category_id) — bigint — Foreign key → member_category.식별자 — NOT NULL
- 지출금액 (amount) — bigint — NOT NULL
- 메모 (memo) — verchar(30)
- 지출일자 (expenseAt) — datetime — NOT NULL
member (회원)
- 식별자 (member_id) — bigint — Primary key — NOT NULL
- 이메일 (email) — varchar(40) — NOT NULL
- 비밀번호 (password) — varchar(255) — NOT NULL
member_category (회원_카테고리)
- 식별자 (member_category_id) — bigint — Primary key — NOT NULL
- 식별자 (member_id) — bigint — Foreign key → member.식별자 — NOT NULL
- 식별자 (category_id2) — bigint — Foreign key → category.식별자 — NOT NULL