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)