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