Charming
Tables (5)
Copy Of Order2 (CopyOfOrder2)
- OrderID — Integer — Primary key — NOT NULL
- CustomerName — varchar(20)
- OrderID (OrderID2) — Integer — Foreign key → Order.OrderID — NOT NULL
Dept. (Department)
- dept.no — integer — Primary key — NOT NULL
- Student no — integer — Foreign key → Student.Student no — NOT NULL
- Dept.name — varchar(20)
Order
- OrderID — Integer — Primary key — NOT NULL
- CustomerName — varchar(20)
Publisher (Newpublisher)
- publisher.name — Primary key — NOT NULL
- contact.name
- contact.no
Student (Untitled 2)
- Student no — integer — Primary key — NOT NULL
- Student name — varchar(25)
- Address — varchar(40)
- Phone — integer