Cocktail
Tables (13)
BrandIngredient (Untitled9)
- BrandIngredientId (id) — Long — Primary key — NOT NULL
- IngredientId (id2) — Long — Foreign key → Ingredient.IngredientId — NOT NULL
- BrandIngredientNAme (name) — String — NOT NULL
Composition (Untitled6)
- CompositionId (id) — Long — Primary key — NOT NULL
- IngredientId (ingredient_id) — Long — Foreign key → Ingredient.IngredientId — NOT NULL
- RecipeId (recipe_id) — Long — Foreign key → Recipe.RecipeId — NOT NULL
- IngredientTypeId (id2) — Long — Foreign key → Ingredient.IngredientTypeId — NOT NULL
- CompositionValue (value) — Double — NOT NULL
- CopmositionUnit (unit) — String — NOT NULL
Food (Untitled)
- FoodId (id) — Long — Primary key — NOT NULL
- FoodName (food_name) — String — NOT NULL
- Type (type) — String — NOT NULL
Ingredient (Untitled7)
- IngredientId (id) — Long — Primary key — NOT NULL
- IngredientTypeId (ingredient_type_id) — Long — Foreign key → IngredientType.IngredientTypeId — NOT NULL
- IngredientType (type) — String — NOT NULL
- IngredientName (name) — String — NOT NULL
IngredientType (Untitled8)
- IngredientTypeId (id) — Long — Primary key — NOT NULL
- IngredientType (type) — String — NOT NULL
- IngredientName (ingredient_name) — String — NOT NULL
- IngredientTypeId (parent_id) — Long — Foreign key → IngredientType.IngredientTypeId
Recipe (Untitled2)
- RecipeId (id) — Long — Primary key — NOT NULL
- CocktailId (cocktail_id) — Long — Foreign key → Food.FoodId — NOT NULL
- CocktailRecipe (recipe_name) — String — NOT NULL
RecipeTool (Untitled5)
- RecipeToolId (id) — Long — Primary key — NOT NULL
- RecipeId (recipe_id) — Long — Foreign key → Recipe.RecipeId — NOT NULL
- ToolId (tool_id) — Long — Foreign key → Tool.ToolId — NOT NULL
Step (Untitled3)
- StepId (id) — Long — Primary key — NOT NULL
- RecipeId (recipe_id) — Long — Foreign key → Recipe.RecipeId — NOT NULL
- StepOrder (step_order) — Long — NOT NULL
- OptionalStep (optional_step) — Boolean
- StepContent (content) — VarChar(200) — NOT NULL
Tool (Untitled4)
- ToolId (id) — Long — Primary key — NOT NULL
- Name (name) — String — NOT NULL
User (Untitled10)
- UserId (id) — Long — Primary key — NOT NULL
- UserName (name) — String
UserIngredient (Untitled12)
- UserIngredientId (id) — Long — Primary key — NOT NULL
- UserId (user_id) — Long — Foreign key → User.UserId — NOT NULL
- IngredientId (ingredient_id) — Long — Foreign key → Ingredient.IngredientId — NOT NULL
- RemainedVolume (volume) — Double
- RemainedUnit (unit) — String
- ExpirationDate (expiration_date) — Date
UserPick (Untitled11)
- UserPickId (id) — Long — Primary key — NOT NULL
- UserId (id2) — Long — Foreign key → User.UserId — NOT NULL
- CocktailId (id3) — Long — Foreign key → Food.FoodId — NOT NULL
- Field
UserPickHistory (Untitled13)
- UserPickId (id) — Long — Foreign key → UserPick.UserPickId — NOT NULL
- UserRating (rating) — Double