10
Tables (5)
Department
- dept_no — integer — Primary key — NOT NULL
- Student No. — integer — Foreign key → Untitled2.Student No. — NOT NULL
- Dept_Name (DeptName) — varchar(20)
Oder
- oderID — integer — Primary key — NOT NULL
- Customer Name (CustomeName) — varchar(20)
Untitled
- userID — integer — Primary key — NOT NULL
- Customer Name (CustomerName) — varchar(20)
- oderID — integer — Foreign key → Oder.oderID — NOT NULL
Untitled2
- Student No. — integer — Primary key — NOT NULL
- Student Name — varchar(25)
- Address — varchar(40)
- Phone — integer
Untitled3
- pubisher_name (NewPubisher) — bookid — Primary key — NOT NULL
- Field
- Field2
- Field3
- Field4