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