WineManagementSystem

Tables (8)

grape (포도)

  • grape_id (포도 번호) — NOT NULL — Primary key — NOT NULL
  • grape_name_korean (한글 포도명) — NOT NULL
  • grape_name_english (영어 포도명) — NOT NULL
  • acidity (산미) — NOT NULL
  • body (바디) — NOT NULL
  • sweetness (당도) — NOT NULL
  • tannin (탄닌) — NOT NULL

grape_share (포도 함량)

  • grape_id (포도 번호) — NOT NULL — Foreign key → grape.grape_id — NOT NULL
  • region_id (원산지 번호) — NOT NULL — Foreign key → region.region_id — NOT NULL
  • share (함량) — NOT NULL

region (원산지)

  • region_id (원산지 번호) — NOT NULL — Primary key — NOT NULL
  • region_name_korean (원산지 한글 이름) — NOT NULL
  • region_name_english (원산지 영어 이름) — NOT NULL
  • parent_name_korean (한글 국가명) — NOT NULL
  • parent_name_english (영어 국가명) — NOT NULL

wine (와인)

  • wine_id (와인 번호) — NOT NULL — Primary key — NOT NULL
  • winery_id (양조장 번호) — NOT NULL — Foreign key → winery.winery_id — NOT NULL
  • type (종류) — NOT NULL
  • name_korean (한글 와인명) — NOT NULL
  • name_english (영어 와인명) — NOT NULL
  • alcohol (알콜) — NOT NULL
  • serving_temperature (서빙 온도) — NOT NULL
  • score (평점) — NOT NULL
  • price (가격) — NOT NULL
  • style (와인특성) — NOT NULL
  • grade (와인등급) — NOT NULL
  • importer (수입상) — NOT NULL

wine_aroma (아로마)

  • wine_aroma_id (와인 아로마 번호) — NOT NULL — Primary key — NOT NULL
  • wine_id (와인 번호) — NOT NULL — Foreign key → wine.wine_id — NOT NULL
  • aroma (아로마) — NOT NULL

wine_grape (Untitled)

  • wine_id (와인 번호) — NOT NULL — Foreign key → wine.wine_id — NOT NULL
  • grape_id (포도 번호) — NOT NULL — Foreign key → grape.grape_id — NOT NULL

wine_pairing (와인 편성)

  • wine_pairing_id (와인 편성 번호) — NOT NULL — Primary key — NOT NULL
  • wine_id (와인 번호) — NOT NULL — Foreign key → wine.wine_id — NOT NULL
  • priring (편성) — NOT NULL

winery (양조장)

  • winery_id (양조장 번호) — NOT NULL — Primary key — NOT NULL
  • region_id (원산지 번호) — NOT NULL — Foreign key → region.region_id — NOT NULL
  • winery_name_korean (양조장 한글 이름) — NOT NULL
  • winery_name_english (양조장 영어 이름) — NOT NULL