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