ㅁㅁㅁㅁ
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)