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