hong
Tables (9)
brewery_info
- brewery_id — INT — Primary key — NOT NULL
- brewery_name — VARCHAR(100) — NOT NULL
- brewery_address — VARCHAR(300)
- brewery_contact — VARCHAR(50)
- brewery_homepage — VARCHAR(300)
- brewery_programs — TEXT
cocktail_base_bridge
- cocktail_id (cocktail_id2) — INT — Foreign key → cocktail_info.cocktail_id — NOT NULL
- drink_id — INT — Foreign key → drink_info.drink_id — NOT NULL
cocktail_info
- cocktail_id — INT — Primary key — NOT NULL
- cocktail_idx_no — VARCHAR(10)
- cocktail_title — VARCHAR(150) — NOT NULL
- cocktail_base — VARCHAR(100)
- cocktail_glass — VARCHAR(100)
- cocktail_technique — VARCHAR(50)
- cocktail_garnish — VARCHAR(100)
- cocktail_recipe — TEXT
- cocktail_method — TEXT
- cocktail_subject — TEXT
- cocktail_image_url — VARCHAR(300)
drink_info
- drink_id — INT — Primary key — NOT NULL
- brewery_id — INT — Foreign key → brewery_info.brewery_id — NOT NULL
- type_id — TINYINT — Foreign key → drink_type.type_id — NOT NULL
- drink_name — VARCHAR(150) — NOT NULL
- drink_url — VARCHAR(300)
- drink_image_url — VARCHAR(300)
- drink_intro — TEXT
- drink_abv — DECIMAL(4,3)
- drink_volume — VARCHAR(100)
- drink_origin — TEXT
- drink_awards — TEXT
- drink_etc — TEXT
drink_pairing_food_bridge
- food_id (food_id2) — INT — Foreign key → pairing_food.food_id — NOT NULL
- drink_id — INT — Foreign key → drink_info.drink_id — NOT NULL
drink_type
- type_id — TINYINT — Primary key — NOT NULL
- type_name — VARCHAR(50) — NOT NULL
local_specialties
- id — INT — Primary key — NOT NULL
- areaname — VARCHAR(100) — NOT NULL
- contents_name — VARCHAR(150) — NOT NULL
- imgurl — VARCHAR(300)
- linkurl — VARCHAR(300)
menu_shop
- shop_id — INT — Primary key — NOT NULL
- shop_publication_id — VARCHAR(20)
- shop_name — VARCHAR(150) — NOT NULL
- shop_address — VARCHAR(300)
- shop_hours — VARCHAR(255)
- shop_tel — VARCHAR(30)
- shop_menu — TEXT
- shop_image_url — VARCHAR(300)
pairing_food
- food_id — INT — Primary key — NOT NULL
- food_name — VARCHAR(100) — NOT NULL