bookfckstore
Tables (4)
book (NewBook)
- bookid — INTEGER — Primary key — NOT NULL
- bookname — VARCHAR(30)
- price — INTEGER
- publisher_name — VARCHAR(30) — 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 — INTEGER
- bookid — INTEGER — Foreign key → book.bookid — NOT NULL
- custid — INTEGER — Foreign key → customer.custid — NOT NULL
publisher (NewPublisher)
- publisher_name — VARCHAR(30) — Primary key — NOT NULL
- contact_name — VARCHAR(30)
- contact_no — INTEGER