FoodRecipe

Tables (5)

cooktype (Untitled)

  • cook_type_id (Key) — int — Primary key — NOT NULL
  • cook_type_name (Field) — String

foodingredient

  • food_id — int — Foreign key → foodname.food_id — NOT NULL
  • food_type_id (type_id) — int — Foreign key → foodname.food_type_id — NOT NULL
  • cook_type_id (Key) — int — Foreign key → foodname.cook_type_id — NOT NULL
  • in_name — String
  • in_amount (Field2) — int
  • detail (Field3) — String

foodname

  • food_id — int — Primary key — NOT NULL
  • food_type_id (type_id) — int — Foreign key → foodtype.food_type_id — NOT NULL
  • cook_type_id (Key) — int — Foreign key → cooktype.cook_type_id — NOT NULL
  • food_name — String

foodrecipe

  • food_type_id (type_id2) — int — Foreign key → foodname.food_type_id — NOT NULL
  • food_id — int — Foreign key → foodname.food_id — NOT NULL
  • cook_type_id (Key) — int — Foreign key → foodname.cook_type_id — NOT NULL
  • cook_time (Field) — int
  • description (Field2) — String

foodtype

  • food_type_id (type_id) — int — Primary key — NOT NULL
  • food_type_name (type_name) — String