bookDrop123
Tables (12)
admin_tb
- admin_id — int — Primary key — NOT NULL
- username — varchar(45) — NOT NULL
- password — varchar(300) — NOT NULL
book_stock_tb
- book_stock_id — int — Primary key — NOT NULL
- book_id — int — NOT NULL
book_tb
- book_id — int — Primary key — NOT NULL
- isbn — varchar(100)
- category_id — int — NOT NULL
- book_name — varchar(100) — NOT NULL
- author_name — varchar(100) — NOT NULL
- publisher_name — varchar(100) — NOT NULL
- cover_img_url — varchar(500) — NOT NULL
- create_date — datetime — NOT NULL
- update_date — datetime — NOT NULL
- publish_date — datetime
category_tb
- category_id — int — Primary key — NOT NULL
- category_name — varchar(45) — NOT NULL
loan_tb
- loan_id — int — Primary key — NOT NULL
- user_id — int — NOT NULL
- book_stock_id — int — NOT NULL
- loan_date — datetime — NOT NULL
- due_date — datetime — NOT NULL
- return_date — datetime
- return_or_not — int — NOT NULL
new_book_tb
- new_book_id — int — Primary key — NOT NULL
- book_id — int — NOT NULL
- publish_date — datetime — NOT NULL
notice_board_category_tb
- notice_board_category_id — int — Primary key — NOT NULL
- notice_board_category_name — varchar(45) — NOT NULL
notice_board_tb
- notice_board_id — int — Primary key — NOT NULL
- notice_board_category_id — int — NOT NULL
- title — varchar(100) — NOT NULL
- content — text — NOT NULL
- create_date — datetime — NOT NULL
- update_date — datetime — NOT NULL
oauth2_tb
- oauth2_id — int — Primary key — NOT NULL
- oauth2_name — varchar(100) — NOT NULL
- user_id — int — NOT NULL
- provider_name — varchar(45) — NOT NULL
- create_date — datetime — NOT NULL
- update_date — datetime — NOT NULL
review_tb
- review_id — int — Primary key — NOT NULL
- book_id — int — NOT NULL
- user_id — int — NOT NULL
- content — text
- rating — float
- create_date — datetime — NOT NULL
- update_date — datetime
user_tb
- user_id — int — Primary key — NOT NULL
- username — varchar(45) — NOT NULL
- password — varchar(300) — NOT NULL
- name — varchar(45) — NOT NULL
- email — varchar(100) — NOT NULL
- phone — varchar(100) — NOT NULL
- address — varchar(100)
- gender — varchar(45)
- age — int — NOT NULL
- birth — varchar(100) — NOT NULL
- profile_url — varchar(300)
- create_date — datetime — NOT NULL
- update_date — datetime — NOT NULL
wish_tb
- wish_id — int — Primary key — NOT NULL
- book_id — int — NOT NULL
- user_id — int — NOT NULL