칵테일 레시피
테이블 (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)