Donut

Tables (5)

CUSTOMER (customer)

  • CustId (Key) — NUMBER(10) — Primary key — NOT NULL
  • Name (Field) — VARCHAR(10)
  • Phone (Field2) — VARCHAR(20)
  • Email (Field3) — VARCHAR(20)

Employee (employee)

  • Key — Primary key — NOT NULL

Menu (menu)

  • MenuId (Key) — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4
  • Field5

ORDER (order)

  • Orderid (Key) — NUMBER(10) — Primary key — NOT NULL
  • Field

OrderItem (orderitem)