FestivalOrder

Tables (3)

Menu (Untitled2)

  • num (Key) — Primary key — NOT NULL
  • name (Varchar)
  • price (number)
  • photo (varchar)

Order (Untitled)

  • num (Key) — Primary key — NOT NULL
  • table (Field)
  • total_price (Field2)
  • done (Field3)
  • date (Field4)

OrderDetail (Untitled3)

  • num (Key) — Primary key — NOT NULL
  • ordernum (Key2) — Foreign key → Order.num — NOT NULL
  • menunum (Key3) — Foreign key → Menu.num — NOT NULL
  • done (Field)