bookstore

Tables (7)

Book

  • book_id — int — Primary key — NOT NULL
  • publisher_id — INT — Foreign key → Publisher.publisher_id — NOT NULL
  • book_title — VARCHAR — NOT NULL
  • author — VARCHAR
  • price — INT
  • rating — DECIMAL

Book_Inventory_History

  • id — VARCHAR — Primary key — NOT NULL
  • book_id — int — Foreign key → Book.book_id — NOT NULL
  • t_type — VARCHAR — NOT NULL
  • Quantity — INT — NOT NULL
  • t_date — DATETIME — NOT NULL

Cart

  • cart_id — INT — Primary key — NOT NULL
  • id (user_id) — VARCHAR — Foreign key → Members.id — NOT NULL
  • book_id — int — Foreign key → Book.book_id — NOT NULL
  • quantity — INT — NOT NULL
  • dateAdded — DATETIME — NOT NULL

Members

  • id — VARCHAR — Primary key — NOT NULL
  • pw — VARCHAR — NOT NULL
  • adress — VARCHAR
  • email — VARCHAR
  • user_per — CHAR

Orders

  • order_id — VARCHAR — Primary key — NOT NULL
  • id (user_id) — VARCHAR — Foreign key → Members.id — NOT NULL
  • total_amount — DECIMAL — NOT NULL
  • order_date — DATETIME

Publisher

  • publisher_id — INT — Primary key — NOT NULL
  • publisher_name — VARCHAR
  • manager — VARCHAR
  • phone_number — VARCHAR

book_history

  • id — INT — Primary key — NOT NULL
  • book_id — int — Foreign key → Book.book_id — NOT NULL
  • publisher_id — INT
  • quantity — INT
  • book_date — DATETIME