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