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