Nguyen Kimgan
Tables (8)
Copy Of Order1 (CopyOfOrder1)
- uerID — integer — Primary key — NOT NULL
- CustormerName — varchar(20)
- orderID — integer — Foreign key → L_Order.orderID — NOT NULL
Department (Untitled)
- dpmt.No — integer — Primary key — NOT NULL
- dpmt.Name — varchar(20)
- Student.No (Studemt.No) — integer — Foreign key → Student.Student.No — NOT NULL
L_Order (P_Order)
- orderID — integer — Primary key — NOT NULL
- CustormerName — varchar(20)
Student (Untitled2)
- Student.No (Studemt.No) — integer — Primary key — NOT NULL
- Student.Name — varchar(25)
- Address — varchar(40)
book (newbook)
- bookid — varchar(25) — Primary key — NOT NULL
- bookname price — integer
- publisher_name — integer
- publisher_name (publisher_name2) — varchar(25) — Foreign key → publisher.publisher_name — NOT NULL
custormer (Newcustormer)
- cusid — Primary key — NOT NULL
- cus_name — varchar(25)
- address — varchar(25)
- phone — integer
- orderid — integer — Foreign key → order.orderid — NOT NULL
order (neworder)
- orderid — integer — Primary key — NOT NULL
- order_date — integer
- sale_price — integer
- bookid — varchar(25) — Foreign key → book.bookid — NOT NULL
publisher (Newpublisher)
- publisher_name — varchar(25) — Primary key — NOT NULL
- contact_name — integer
- contact_no — integer