DrunkHouse

Tables (3)

Drink (술)

  • id (drink_id) — Long — Primary key — NOT NULL
  • name — String — NOT NULL
  • abv — int — NOT NULL — 도수
  • bottleSize (bottle_size) — int — NOT NULL — ml 단위
  • price — int — NOT NULL
  • content — String — 상세 정보
  • category — enum — NOT NULL — 술 종류, other 포함

Member (회원)

  • id (member_id) — Long — Primary key — NOT NULL
  • userName (username) — String — NOT NULL
  • password — String — NOT NULL
  • nick — String — NOT NULL — 닉네임
  • gender — enum — MALE/FEMALE
  • birth — String — ex) 19960229

Review (리뷰)

  • id (review_id) — Long — Primary key — NOT NULL
  • id (member_id) — Member — Foreign key → Member.id — NOT NULL
  • id (drink_id) — Drink — Foreign key → Drink.id — NOT NULL
  • title — String — NOT NULL
  • content — String — NOT NULL