MyFirstProject
Tables (8)
Copy Of Order (CopyOfOrder)
- userID — integer — Primary key — NOT NULL
- CustomerName — varchar(20)
- orderID — integer — Foreign key → L_Order1.orderID — NOT NULL
Dept. (Department)
- dept_no — integer — Primary key — NOT NULL
- Student No (StudentNo) — integer — Foreign key → Student.Student No
- Dept. Name (DeptName) — varchar(20)
L_Order1 (P_Order)
- orderID — integer — Primary key — NOT NULL
- CustomerName — varchar(20)
Publisher (Newpublisher)
- Publisher_name — varchar(40) — Primary key — NOT NULL
- contact_name — varchar(20)
- contact_no — varchar(20)
Student (Untitled)
- Student No (StudentNo) — integer — Primary key
- Student Name (StudentName) — varchar(25)
- Address — varchar(40)
- Phone — integer
book (NewBook)
- bookid — integer — Primary key — NOT NULL
- bookname — varchar(40)
- price
- Publisher_name — integer — Foreign key → Publisher.Publisher_name — NOT NULL
- Field2
customer (NewCustomer)
- custid — Primary key — NOT NULL
- cust_name
- address — Varchar(60)
- Phone (phone)
order (NewOrder)
- orderid — Primary key — NOT NULL
- order_date
- sale_price
- bookid — Foreign key → book.bookid — NOT NULL
- custid — Foreign key → customer.custid — NOT NULL