LIB

Tables (8)

book

  • book_id — int(20) — Primary key — NOT NULL
  • title — varchar(50) — NOT NULL
  • author — varchar(20) — NOT NULL
  • publisher — varchar(20) — NOT NULL
  • the_date — date — NOT NULL
  • genre — varchar(20) — NOT NULL
  • file — varchar(60) — NOT NULL

book_review

  • review_id — int(20) — Primary key — NOT NULL
  • review_title — varchar(20) — NOT NULL
  • review_desc — varchar(100) — NOT NULL
  • book_id — int(20) — NOT NULL
  • user_id — int(20) — NOT NULL
  • review_rating — float — NOT NULL

comment

  • comment_id — int(20) — Primary key — NOT NULL
  • comm_description — varchar(80) — NOT NULL
  • review_id — int(20) — NOT NULL
  • user_id — int(20) — NOT NULL

favorite

  • book_id — int(20) — Primary key — NOT NULL
  • user_id — int(20) — Primary key — NOT NULL
  • Favorite_date — date — NOT NULL

loan

  • book_id — int(20) — Primary key — NOT NULL
  • user_id — int(20) — Primary key — NOT NULL
  • loan_date — datetime — NOT NULL
  • return_date — datetime — NOT NULL

purchase

  • book_id — int(20) — Primary key — NOT NULL
  • user_id — int(20) — Primary key — NOT NULL
  • purchase_date — date — NOT NULL

returned

  • returned_id — int(20) — Primary key — NOT NULL
  • returned_date — date — NOT NULL
  • book_id — int(20) — NOT NULL

user

  • user_id — int(20) — Primary key — NOT NULL
  • pwd — varchar(60) — NOT NULL
  • email — varchar(20) — NOT NULL
  • addr — varchar(30) — NOT NULL
  • name — varchar(15) — NOT NULL
  • gender — varchar(15) — NOT NULL
  • tel — varchar(15)
  • code — varchar(5) — NOT NULL