ㅁㅁㅁㅁ

Tables (8)

grape (Untitled5)

  • grape_id (Key) — Primary key — NOT NULL
  • name_korean (포도품종)
  • name_english (Field2)
  • acidity (Field3)
  • body (Field4)
  • sweetness (Field5)
  • tannin (Field6)

grape_share (Untitled6)

  • grape_share_id (Key) — Primary key — NOT NULL
  • grape_id (Key2) — Foreign key → grape.grape_id — NOT NULL
  • region_id (Key3) — Foreign key → region.region_id — NOT NULL
  • name_kreaon (포도 품종)
  • name_english (Field2)
  • share (Field3)
  • region_name_korean (지역이름)
  • region_name_english (Field5)

region (Untitled7)

  • region_id (Key) — Primary key — NOT NULL
  • name_korean (지역이름)
  • name_english (Field2)
  • parent_name_korean (Field3)
  • parent_name_english (Field4)

wine (Untitled)

  • wine_id (식별번호) — bigint — Primary key — NOT NULL
  • winery_id (Key) — Foreign key → winery.winery_id — NOT NULL
  • region_id (Key2) — Foreign key → winery.region_id — NOT NULL
  • type (와인종류) — varchar
  • name_korean (와인이름(한글)) — varchar
  • name_english (와인이름(영어)) — varchar
  • alcohol (알코올도수) — float
  • acidity (산도) — int
  • body (바디감) — int
  • sweetness (단맛) — int
  • tannin (타닌) — int
  • serving_temperature (권장섭취온도) — float
  • winery_name_korean (Field)
  • winery_name_engilsih (Field2)
  • region_name_korean (Field3)
  • region_name_english (Field4)

wine_aroma (Untitled2)

  • wine_aroma_id (Key) — Primary key — NOT NULL
  • wine_id (식별번호) — bigint — Foreign key → wine.wine_id — NOT NULL
  • winery_id (Key2) — Foreign key → wine.winery_id — NOT NULL
  • region_id (Key22) — Foreign key → wine.region_id — NOT NULL
  • name_korean (와인 이름)
  • name_english (영어이름)
  • aroma (Field3)

wine_grape (Untitled4)

  • wine_grape_id (Key) — Primary key — NOT NULL
  • wine_id (식별번호) — bigint — Foreign key → wine.wine_id — NOT NULL
  • grape_id (Key2) — Foreign key → grape.grape_id — NOT NULL
  • winery_id (Key3) — Foreign key → wine.winery_id — NOT NULL
  • region_id (Key22) — Foreign key → wine.region_id — NOT NULL
  • name_kreaon (와인이름)
  • name_english (Field2)
  • grape_name_kreaon (Field3)
  • grape_name_english (Field4)

wine_pairing (Untitled3)

  • wine_pairing_id (Key) — Primary key — NOT NULL
  • wine_id (식별번호) — bigint — Foreign key → wine.wine_id — NOT NULL
  • winery_id (Key2) — Foreign key → wine.winery_id — NOT NULL
  • region_id (Key22) — Foreign key → wine.region_id — NOT NULL
  • name_korean (와인 이름)
  • name_english (영어이름)
  • pairing (Field)

winery (Untitled8)

  • winery_id (Key) — Primary key — NOT NULL
  • region_id (Key2) — Foreign key → region.region_id — NOT NULL
  • name_korean (와이너리 이름)
  • name_english (Field)
  • region_name_korean (Field2)
  • region_name_english (Field3)