withbooks

Tables (32)

bestseller

  • id — BIGINT(20) — Primary key — NOT NULL
  • book_id — BIGINT(20) — Foreign key → book.id — NOT NULL
  • reg_date — TIMESTAMP — NOT NULL

book

  • id — BIGINT(20) — Primary key — NOT NULL
  • category_id — BIGINT(20) — Foreign key → book_category.id — NOT NULL
  • category_name — VARCHAR(100) — NOT NULL
  • cid — BIGINT(20) — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • author — VARCHAR(100) — NOT NULL
  • pub_date — TIMESTAMP — NOT NULL
  • publisher — VARCHAR(50) — NOT NULL
  • isbn13 — VARCHAR(45) — NOT NULL
  • description — VARCHAR(300)
  • purchase_link — VARCHAR(200) — NOT NULL
  • price — INT(11) — NOT NULL
  • cover — VARCHAR(100) — NOT NULL
  • public_yn — TINYINT(4) — NOT NULL
  • reg_date — TIMESTAMP — NOT NULL

book_category

  • id — BIGINT(20) — Primary key — NOT NULL
  • name — VARCHAR(45) — NOT NULL

booklog

  • id — BIGINT(20) — Primary key — NOT NULL
  • user_id — BIGINT(20) — Foreign key → user.id — NOT NULL
  • book_id — BIGINT(20) — Foreign key → book.id — NOT NULL
  • public_yn — TINYINT(4) — NOT NULL
  • reg_date — TIMESTAMP — NOT NULL

booklog_logs

  • id — BIGINT(20) — Primary key — NOT NULL
  • content — VARCHAR(2000)
  • img — VARCHAR(100)
  • reg_date — TIMESTAMP — NOT NULL
  • booklog_id — BIGINT(20) — Foreign key → booklog.id — NOT NULL

bookmark

  • book_id — BIGINT(20) — Foreign key → book.id — NOT NULL
  • user_id — BIGINT(20) — Foreign key → user.id — NOT NULL
  • id (id2) — INT(11) — Foreign key → user.id — NOT NULL
  • reg_date — TIMESTAMP — NOT NULL

calendar

  • id — BIGINT(20) — Primary key — NOT NULL
  • with_id — BIGINT(20) — Foreign key → with.id — NOT NULL
  • user_id — BIGINT(20) — Foreign key → user.id — NOT NULL
  • start_date_time — TIMESTAMP — NOT NULL
  • end_date_time — TIMESTAMP — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • location — VARCHAR(100)

debate_attachment

  • id — BIGINT(20) — Primary key — NOT NULL
  • board_id — BIGINT(20) — Foreign key → debate_board.id — NOT NULL
  • original_img — VARCHAR(200) — NOT NULL
  • save_img — VARCHAR(100) — NOT NULL
  • id (id2) — INT(11) — Foreign key — NOT NULL

debate_board

  • id — BIGINT(20) — Primary key — NOT NULL
  • room_id — BIGINT(20) — Foreign key → debate_room.id — NOT NULL
  • user_id — BIGINT(20) — Foreign key → user.id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — VARCHAR(5000) — NOT NULL
  • reg_date — TIMESTAMP — NOT NULL
  • blind_yn — TINYINT(4) — NOT NULL
  • topic_id — BIGINT(20) — Foreign key → debate_topic.id — NOT NULL

debate_comment

  • id — BIGINT(20) — Primary key — NOT NULL
  • board_id — BIGINT(20) — Foreign key → debate_board.id — NOT NULL
  • user_id — BIGINT(20) — Foreign key → user.id — NOT NULL
  • content — VARCHAR(300) — NOT NULL
  • reg_date — TIMESTAMP — NOT NULL
  • blind_yn — TINYINT(4) — NOT NULL

debate_room

  • id — BIGINT(20) — Primary key — NOT NULL
  • reg_id — BIGINT(20) — Foreign key → user.id — NOT NULL
  • with_id — BIGINT(20) — Foreign key → with.id — NOT NULL
  • book_id — BIGINT(20) — Foreign key → book.id — NOT NULL
  • notice — VARCHAR(3000) — NOT NULL
  • deadline — INT(11) — NOT NULL
  • reserve_date — TIMESTAMP — NOT NULL
  • reg_date — TIMESTAMP — NOT NULL
  • blind_yn — INT(11)

debate_topic

  • id — BIGINT(20) — Primary key — NOT NULL
  • room_id — BIGINT(20) — Foreign key → debate_room.id — NOT NULL
  • content — VARCHAR(1000) — NOT NULL

free_attachment

  • id — BIGINT(20) — Primary key — NOT NULL
  • board_id — BIGINT(20) — Foreign key → free_board.id — NOT NULL
  • img — VARCHAR(100) — NOT NULL

free_board

  • id — BIGINT(20) — Primary key — NOT NULL
  • with_id — BIGINT(20) — Foreign key → with.id — NOT NULL
  • user_id — BIGINT(20) — Foreign key → user.id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — VARCHAR(5000) — NOT NULL
  • reg_date — TIMESTAMP — NOT NULL
  • blind_yn — TINYINT(4) — NOT NULL
  • notice_yn — TINYINT(4) — NOT NULL

free_comment

  • id — BIGINT(20) — Primary key — NOT NULL
  • board_id — BIGINT(20) — Foreign key → free_board.id — NOT NULL
  • user_id — BIGINT(20) — Foreign key → user.id — NOT NULL
  • content — VARCHAR(500) — NOT NULL
  • reg_date — TIMESTAMP — NOT NULL

free_like

  • board_id — BIGINT(20) — Foreign key → free_board.id — NOT NULL
  • user_id — BIGINT(20) — Foreign key → user.id — NOT NULL
  • id (id2) — INT(11) — Foreign key → user.id — NOT NULL

noti_category

  • id — BIGINT(20) — Primary key — NOT NULL
  • name — VARCHAR(45) — NOT NULL

noti_status

  • id — BIGINT(20) — Primary key — NOT NULL
  • noti_category_id — BIGINT(20) — Foreign key → noti_category.id — NOT NULL
  • status — BIGINT(20) — NOT NULL
  • message — VARCHAR(45)

notification

  • id — BIGINT(20) — Primary key — NOT NULL
  • noti_status_id — BIGINT(20) — Foreign key → noti_status.id — NOT NULL
  • user_id — BIGINT(20) — Foreign key → user.id — NOT NULL
  • content_id — BIGINT(20) — NOT NULL
  • add_date — TIMESTAMP — NOT NULL
  • checked_yn — TINYINT(4) — NOT NULL
  • checked_date — TINYINT(4)

recommend

  • id — BIGINT(20) — Primary key — NOT NULL
  • user_id — BIGINT(20) — Foreign key → user.id — NOT NULL
  • with_id — BIGINT(20) — Foreign key → with.id — NOT NULL
  • book_id — BIGINT(20) — Foreign key → book.id — NOT NULL
  • content — VARCHAR(200) — NOT NULL
  • reg_date — TIMESTAMP — NOT NULL

report

  • id — BIGINT(20) — Primary key — NOT NULL
  • content_id — BIGINT(20) — Foreign key → report_content_category.id — NOT NULL
  • reason_id — BIGINT(20) — Foreign key → report_reason_category.id — NOT NULL
  • reporter_id — BIGINT(20) — Foreign key → user.id — NOT NULL
  • reported_id — BIGINT(20) — Foreign key → user.id — NOT NULL
  • detail — VARCHAR(100)
  • report_date — TIMESTAMP — NOT NULL
  • status — TINYINT(4) — NOT NULL

report_content_category

  • id — BIGINT(20) — Primary key — NOT NULL
  • name — VARCHAR(45) — NOT NULL

report_reason_category

  • id — BIGINT(20) — Primary key — NOT NULL
  • reason — VARCHAR(45) — NOT NULL

shorts

  • id — BIGINT(20) — Primary key — NOT NULL
  • book_id — BIGINT(20) — Foreign key → book.id — NOT NULL
  • user_id — BIGINT(20) — Foreign key → user.id — NOT NULL
  • content — VARCHAR(2000) — NOT NULL
  • reg_date — TIMESTAMP — NOT NULL
  • blind_yn — TINYINT(4) — NOT NULL

shorts_attachment

  • id — BIGINT(20) — Primary key — NOT NULL
  • shorts_id — BIGINT(20) — Foreign key → shorts.id — NOT NULL
  • img — VARCHAR(100) — NOT NULL

shorts_comment

  • id — BIGINT(20) — Primary key — NOT NULL
  • shorts_id — BIGINT(20) — Foreign key → shorts.id — NOT NULL
  • user_id — BIGINT(20) — Foreign key → user.id — NOT NULL
  • content — VARCHAR(500) — NOT NULL
  • reg_date — TIMESTAMP — NOT NULL

shorts_like

  • shorts_id — BIGINT(20) — Foreign key → shorts.id — NOT NULL
  • user_id — BIGINT(20) — Foreign key → user.id — NOT NULL

user

  • id — BIGINT(20) — Primary key — NOT NULL
  • id (withdraw_status) — INT(11) — Foreign key → user_withdraw_status.id — NOT NULL
  • email — VARCHAR(45) — NOT NULL
  • password — VARCHAR(200) — NOT NULL
  • nickname — VARCHAR(200) — NOT NULL
  • gender — TINYINT(4) — NOT NULL
  • intro — VARCHAR(45)
  • birth_date — TIMESTAMP — NOT NULL
  • img — VARCHAR(500)
  • join_date — TIMESTAMP — NOT NULL
  • noti_yn — TINYINT(4) — NOT NULL
  • role — VARCHAR(45) — NOT NULL

user_withdraw_status

  • id — INT(11) — Primary key — NOT NULL
  • status — VARCHAR(45) — NOT NULL

with

  • id — BIGINT(20) — Primary key — NOT NULL
  • blind_yn — TINYINT(4) — NOT NULL
  • with_reg_id — BIGINT(20) — Foreign key → user.id — NOT NULL
  • face_yn — TINYINT(4) — NOT NULL
  • name — VARCHAR(45) — NOT NULL
  • intro — VARCHAR(1000)
  • img — VARCHAR(100)
  • interval — TINYINT(4)
  • location — VARCHAR(200)
  • personnel — TINYINT(4) — NOT NULL
  • reg_date — TIMESTAMP — NOT NULL

with_category

  • with_id — BIGINT(20) — Foreign key → with.id — NOT NULL
  • category_id — BIGINT(20) — Foreign key → book_category.id — NOT NULL

with_member

  • member_id — BIGINT(20) — Foreign key → user.id — NOT NULL
  • with_id — BIGINT(20) — Foreign key → with.id — NOT NULL
  • master_yn — TINYINT(4) — NOT NULL
  • kicked_yn — TINYINT(4) — NOT NULL
  • join_date — TIMESTAMP — NOT NULL