칵테일 레시피

테이블 (4)

Category (Untitled4)

  • category_Num — Number — 기본 키 — NOT NULL
  • category_Name — varchar(20)
  • recipe_Num — Number — 외래 키 → Recipe.recipe_Num — NOT NULL

Favorite (Untitled5)

  • favor_Num — Number — 기본 키 — NOT NULL
  • favor_Name — varchar(30)
  • favor_Category — varchar(20)
  • favor_ingre — varchar(50)
  • favor_Recipe — varchar(100)
  • recipe_Num — Number — 외래 키 → Recipe.recipe_Num — NOT NULL
  • myRecipe_Num — Number — 외래 키 → MyRecipe.myRecipe_Num — NOT NULL

MyRecipe (Untitled6)

  • myRecipe_Num — Number — 기본 키 — NOT NULL
  • myCocktaile_Name — varchar(30)
  • myCocktaile_ingre — varchar(50)
  • myCocktaile_Recipe — varchar(100)
  • myCocktaile_Category — varchar(20)

Recipe (Untitled2)

  • recipe_Num — Number — 기본 키 — NOT NULL
  • cocktail_Name (cocktaile_Name) — varchar(30)
  • choose_Category — varchar(20)
  • cocktail_ingre — varchar(50)
  • cocktail_Recipe — varchar(100)