Food_Court

Tables (3)

Conor (Untitled5)

  • conor_id (Field) — int — Primary key — NOT NULL
  • name (Field2) — varchar(10) — NOT NULL

Orders (Untitled6)

  • order_id (PK) — int — Primary key — NOT NULL
  • menu_id (Field2) — int — Foreign key → menu.menu_id — NOT NULL
  • conor_id (Field4) — int — Foreign key → menu.conor_id — NOT NULL
  • Status (Field) — char(1) — NOT NULL
  • menu_count (Field3) — int — NOT NULL

menu (Untitled7)

  • menu_id (Field) — int — Primary key — NOT NULL
  • conor_id (Field4) — int — Foreign key → Conor.conor_id — NOT NULL
  • menu_name (Field2) — varchar(10) — NOT NULL
  • price (Field3) — int — NOT NULL