MyFirstProject
Tables (4)
Copy Of Order (Untitled4)
- userID — integer — Primary key — NOT NULL
- CustomerName — varchar(20)
- orderID — integer — Foreign key → Order 1.orderID — NOT NULL
Dept. (Untitled3)
- dept_no — integer — Primary key — NOT NULL
- Dept. Name (DeptName) — varchar(25)
- Student No (StudentNo.) — integer — Foreign key → Student.Student No — NOT NULL
Order 1 (Order)
- orderID — integer — Primary key — NOT NULL
- CustomerName — varchar(20)
Student (Untitled)
- Student No (StudentNo.) — integer — Primary key — NOT NULL
- Student Name (StudentName.) — varchar(25)
- Address — varchar(40)
- Phone — integer