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