ddd
Tables (15)
alan_recommend_book
- id — BIGINT(11)
- alan_recommend_list_id — BIGINT(11)
- book_id — BIGINT(11)
alan_recommend_list
- id — BIGINT(11)
- date — timestamp
book
- id — BIGINT(11)
- title — varchar(30)
- price — long
- author — varchar(20)
- publisher — varchar(20)
- publish_date — timestamp
- stock — int
- isbn — varchar(20)
- description — varchar(300)
- image_path — varchar(200)
book_mark
- id — BIGINT(11)
- user_recommend_list_id — BIGINT(11)
- user_id — BIGINT(11)
cart
- id — BIGINT(11)
- user_id — BIGINT(11)
- book_id — BIGINT(11)
- book_count — int
category
- id — varchar(10)
- name — varchar(10)
delivery
- id — BIGINT(11)
- status — varchar(10)
- address — varchar(30)
- zipcode — varchar(10)
dislike
- id — BIGINT(11)
- review_id — BIGINT(11)
- user_id — BIGINT(11)
like
- id — BIGINT(11)
- review_id — BIGINT(11)
- user_id — BIGINT(11)
order
- id — BIGINT(11)
- user_id — BIGINT(11)
- order_date — timestamp
- delivery_id — BIGINT(11)
- status — varchar(10)
order_book
- id — BIGINT(11)
- order_id — BIGINT(11)
- book_id — BIGINT(11)
- book_count — int
review
- id — BIGINT(11)
- book_id — BIGINT(11)
- user_id — BIGINT(11)
- content — VARCHAR(500)
- score — tinyint
user
- id — BIGINT(11)
- name — varchar(10)
- nick_name — varchar(20)
- email — varchar(30)
- password — varchar(30)
- role — varchar(10)
- mileage — long
- expire — timestamp
- address — varchar(30)
- zipcode — varchar(10)
user_recommend_book
- id — BIGINT(11)
- user_recommend_list_id — BIGINT(11)
- user_id — BIGINT(11)
user_recommend_list
- id — BIGINT(11)
- user_id — BIGINT(11)
- title — varchar(30)
- date — timestamp