wisky
Tables (10)
Client
- 회원ID (client_id) — Primary key — NOT NULL
- 이름 (client_name)
- 전화번호 (client_number)
- 이메일 (client_email)
- 비밀번호 (client_pwd)
- 닉네임 (client_nickname)
- 권한 (client_role)
ClientPreferedWhiskly
- pref_whisky_id — Primary key — NOT NULL
- pref_id — Foreign key → ClientPreferences.pref_id — NOT NULL
- whisky_id — Foreign key → Whisky.위스키ID — NOT NULL
ClientPreferences
- pref_id — Primary key — NOT NULL
- client_id — Foreign key → Client.회원ID — NOT NULL
- preferred_tags
- preferred_abv_min
- preferred_abv_max
- preferred_scent
- preferred_flavor
Cocktail
- 칵테일ID (cocktail_id) — Primary key — NOT NULL
- cocktail_name
- cocktail_content
- cocktail_rate
- cocktail_recipe
- cocktail_base_liquor
CocktailIngredients (CocktailIngredient)
- ingredient_id — Primary key — NOT NULL
- 칵테일ID (cocktail_id) — Foreign key → Cocktail.칵테일ID — NOT NULL
- 위스키ID (whisky_id) — Foreign key → Whisky.위스키ID — NOT NULL
- amount
- unit
Review
- 리뷰ID (review_id) — Primary key — NOT NULL
- 리뷰내용 (review_content)
- 리뷰점수 (review_rating)
- 리뷰작성일 (review_created_at)
- 회원ID (client_id) — Foreign key → Client.회원ID — NOT NULL
- 위스키ID (whisky_id) — Foreign key → Whisky.위스키ID — NOT NULL
- 칵테일ID (cocktail_id) — Foreign key → Cocktail.칵테일ID — NOT NULL
Whisky
- 위스키ID (whisky_id) — Primary key — NOT NULL
- category_id — Foreign key → whisky_Category.category_id — NOT NULL
- whisky_name
- whisky_type
- whisky_alcohol_content
- whisky_age
- whisky_content
- whisky_region
Word
- word_id — Primary key — NOT NULL
- word
- word_content
notice (Notice)
- 공지사항ID (notice_id) — Primary key — NOT NULL
- 제목 (notice_title)
- 내용 (notice_content)
- 작성자ID (client_id) — Foreign key → Client.회원ID — NOT NULL
- 공지사항작성일 (created_at)
whisky_Category (WhiskyCategory)
- category_id — Primary key — NOT NULL
- category_name