lab4

Tables (4)

Customer (Untitled5)

  • customer_ID (Key) — Primary key — NOT NULL
  • Name (Field)
  • Address (Field2)

Employee (Untitled)

  • Employee_ID (Key) — Primary key — NOT NULL
  • Name (Field)
  • Date (Field2)
  • Nick_Name (Field3)

Order (Untitled4)

  • Order_ID (Key) — Primary key — NOT NULL
  • customer_ID (Key2) — Foreign key → Customer.customer_ID — NOT NULL
  • Payment_ID (Key3) — Foreign key → Payment.Payment_ID — NOT NULL
  • Employee_ID (Key4) — Foreign key → Employee.Employee_ID — NOT NULL
  • Item (Field2)

Payment (Untitled3)

  • Payment_ID (Key) — Primary key — NOT NULL
  • Cash (Field)