2
Tables (4)
book (newbook)
- bookid — INTEGER — Primary key — NOT NULL
- bookname — VARCHAR(30)
- price — INTEGER
- publisher_name — varchar(40) — Foreign key → publisher.publisher_name — NOT NULL
customer (Newcustomer)
- custid — integer — Primary key — NOT NULL
- cust_name — varchar(30)
- address — varchar(60)
- phone — varchar(25)
order (neworder)
- orderid — INTEGER — Primary key — NOT NULL
- order_date — DATE
- Sale_price (sale_price) — INTEGER
- custid — integer — Foreign key → book.bookid — NOT NULL
- bookid — integer — Foreign key → customer.custid — NOT NULL
publisher (newPublisher)
- publisher_name — VARCHAR(30) — Primary key — NOT NULL
- contact_name — VARCHAR30)
- contact_no — INTEGER