LIB
Tables (8)
book
- book_id — int(20) — Primary key — NOT NULL
- Key — 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
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