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