ref

Tables (3)

expiration date (Untitled3)

  • ing_id (Key) — INT — Foreign key → ingredient.ing_id — NOT NULL
  • ref_id (Key2) — INT(5) — Foreign key → ingredient.ref_id — NOT NULL
  • exp_date (Field) — CHAR(11)

ingredient (Untitled2)

  • ing_id (Key) — INT — Primary key — NOT NULL
  • ref_id (Key2) — INT(5) — Foreign key → refrigerator.ref_id — NOT NULL
  • ing_name (Field) — CHAR(20)
  • Field2

refrigerator (Untitled)

  • ref_id (Key) — INT(5) — Primary key — NOT NULL