Glamour
Tables (5)
Copy Of Order (CopyOfOrder)
- userID — integer — Primary key — NOT NULL
- CustomerName — varcha(20)
- orderID (orderID2) — integer — Foreign key → P_Order.orderID — NOT NULL
Dept. (Department)
- Dept.Name — varcha(20) — Primary key
- dept_no — integer — Primary key — NOT NULL
- StudentNo — integer — Foreign key → Student.StudentNo — NOT NULL
P_Order (Order)
- orderID — integer — Primary key — NOT NULL
- CustomerName — varcha(20)
Publisher (New publisher)
- publisher_name — Primary key — NOT NULL
- Field
Student (Untitled 2)
- StudentNo — integer — Primary key — NOT NULL
- Student name — varcha(25)
- Address — varcha(40)
- Phone — integer