레스고

테이블 (33)

bestseller

  • id — BIGINT(20) — 기본 키 — NOT NULL
  • book_id — BIGINT(20) — 외래 키 → book.id — NOT NULL
  • reg_date — TIMESTAMP — NOT NULL
  • INDEX — `fk_bestseller_book1_idx`

book

  • id — BIGINT(20) — 기본 키 — NOT NULL
  • category_id — BIGINT(20) — 외래 키 → 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
  • INDEX — `fk_book_category_id_idx`

book_category

  • id — BIGINT(20) — 기본 키 — NOT NULL
  • name — VARCHAR(45) — NOT NULL

booklog

  • id — BIGINT(20) — 기본 키 — NOT NULL
  • user_id — BIGINT(20) — 외래 키 → user.id — NOT NULL
  • book_id — BIGINT(20) — 외래 키 → book.id — NOT NULL
  • public_yn — TINYINT(4) — NOT NULL
  • reg_date — TIMESTAMP — NOT NULL
  • INDEX — `fk_booklog_user1_idx`
  • INDEX — `fk_booklog_book1_idx`

booklog_logs

  • id — BIGINT(20) — 기본 키 — NOT NULL
  • content — VARCHAR(2000)
  • img — VARCHAR(100)
  • reg_date — TIMESTAMP — NOT NULL
  • booklog_id — BIGINT(20) — 외래 키 → booklog.id — NOT NULL
  • INDEX — `fk_foreign_key_booklog_id_idx`
  • INDEX — `booklog_id`

bookmark

  • book_id — BIGINT(20) — 외래 키 → book.id — NOT NULL
  • user_id — BIGINT(20) — 외래 키 → user.id — NOT NULL
  • reg_date — TIMESTAMP — NOT NULL
  • INDEX — `fk_bookmark_user1_idx`
  • INDEX — `fk_bookmark_book1_idx`

calendar

  • id — BIGINT(20) — 기본 키 — NOT NULL
  • with_id — BIGINT(20) — 외래 키 → with.id — NOT NULL
  • user_id — BIGINT(20) — 외래 키 → user.id — NOT NULL
  • start_date_time — TIMESTAMP — NOT NULL
  • end_date_time — TIMESTAMP — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • location — VARCHAR(100)
  • INDEX — `fk_calendar_with1_idx`
  • INDEX — `fk_calendar_user1_idx`

debate_attachment

  • id — BIGINT(20) — 기본 키 — NOT NULL
  • board_id — BIGINT(20) — 외래 키 → debate_board.id — NOT NULL
  • original_img — VARCHAR(200) — NOT NULL
  • save_img — VARCHAR(100) — NOT NULL
  • INDEX — `fk_debate_attachment_debate_board1_idx`

debate_board

  • id — BIGINT(20) — 기본 키 — NOT NULL
  • room_id — BIGINT(20) — 외래 키 → debate_room.id — NOT NULL
  • user_id — BIGINT(20) — 외래 키 → 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) — 외래 키 → debate_topic.id — NOT NULL
  • INDEX — `fk_debate_board_debate_room1_idx`
  • INDEX — `fk_debate_board_user1_idx`
  • INDEX — `fk_debate_board_topic_id_idx`

debate_comment

  • id — BIGINT(20) — 기본 키 — NOT NULL
  • board_id — BIGINT(20) — 외래 키 → debate_board.id — NOT NULL
  • user_id — BIGINT(20) — 외래 키 → user.id — NOT NULL
  • content — VARCHAR(300) — NOT NULL
  • reg_date — TIMESTAMP — NOT NULL
  • blind_yn — TINYINT(4) — NOT NULL
  • INDEX — `fk_debate_comment_debate_board1_idx`
  • INDEX — `fk_debate_comment_user1_idx`

debate_room

  • id — BIGINT(20) — 기본 키 — NOT NULL
  • reg_id — BIGINT(20) — 외래 키 → user.id — NOT NULL
  • with_id — BIGINT(20) — 외래 키 → with.id — NOT NULL
  • book_id — BIGINT(20) — 외래 키 → 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)
  • INDEX — `fk_debate_room_user1_idx`
  • INDEX — `fk_debate_room_book1_idx`
  • INDEX — `fk_debate_room_with1_idx`

debate_topic

  • id — BIGINT(20) — 기본 키 — NOT NULL
  • room_id — BIGINT(20) — 외래 키 → debate_room.id — NOT NULL
  • content — VARCHAR(1000) — NOT NULL
  • INDEX — `fk_debate_topic_debate_room1_idx`

free_attachment

  • id — BIGINT(20) — 기본 키 — NOT NULL
  • board_id — BIGINT(20) — 외래 키 → free_board.id — NOT NULL
  • img — VARCHAR(100) — NOT NULL
  • INDEX — `fk_free_attachment_free_board1_idx`

free_board

  • id — BIGINT(20) — 기본 키 — NOT NULL
  • with_id — BIGINT(20) — 외래 키 → with.id — NOT NULL
  • user_id — BIGINT(20) — 외래 키 → 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
  • INDEX — `fk_free_board_with1_idx`
  • INDEX — `fk_free_board_user1_idx`

free_comment

  • id — BIGINT(20) — 기본 키 — NOT NULL
  • board_id — BIGINT(20) — 외래 키 → free_board.id — NOT NULL
  • user_id — BIGINT(20) — 외래 키 → user.id — NOT NULL
  • content — VARCHAR(500) — NOT NULL
  • reg_date — TIMESTAMP — NOT NULL
  • INDEX — `fk_free_comment_free_board1_idx`
  • INDEX — `fk_free_comment_user1_idx`

free_like

  • board_id — BIGINT(20) — 외래 키 → free_board.id — NOT NULL
  • user_id — BIGINT(20) — 외래 키 → user.id — NOT NULL
  • INDEX — `fk_free_like_free_board_idx`
  • INDEX — `fk_free_like_user1_idx`

noti_category

  • id — BIGINT(20) — 기본 키 — NOT NULL
  • name — VARCHAR(45) — NOT NULL

noti_status

  • id — BIGINT(20) — 기본 키 — NOT NULL
  • noti_category_id — BIGINT(20) — 외래 키 → noti_category.id — NOT NULL
  • status — BIGINT(20) — NOT NULL
  • message — VARCHAR(45)
  • INDEX — `fk_noti_category_id_idx`

notification

  • id — BIGINT(20) — 기본 키 — NOT NULL
  • noti_status_id — BIGINT(20) — 외래 키 → noti_status.id — NOT NULL
  • user_id — BIGINT(20) — 외래 키 → 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)
  • INDEX — `fk_notification_user1_idx`
  • INDEX — `fk_noti_status_id_idx`

recommend

  • id — BIGINT(20) — 기본 키 — NOT NULL
  • user_id — BIGINT(20) — 외래 키 → user.id — NOT NULL
  • with_id — BIGINT(20) — 외래 키 → with.id — NOT NULL
  • book_id — BIGINT(20) — 외래 키 → book.id — NOT NULL
  • content — VARCHAR(200) — NOT NULL
  • reg_date — TIMESTAMP — NOT NULL
  • INDEX — `fk_recommend_user1_idx`
  • INDEX — `fk_recommend_with1_idx`
  • INDEX — `fk_recommend_book1_idx`

report

  • id — BIGINT(20) — 기본 키 — NOT NULL
  • content_id — BIGINT(20) — 외래 키 → report_content_category.id — NOT NULL
  • reason_id — BIGINT(20) — 외래 키 → report_reason_category.id — NOT NULL
  • reporter_id — BIGINT(20) — 외래 키 → user.id — NOT NULL
  • reported_id — BIGINT(20) — 외래 키 → user.id — NOT NULL
  • detail — VARCHAR(100)
  • report_date — TIMESTAMP — NOT NULL
  • status — TINYINT(4) — NOT NULL
  • INDEX — `fk_report_report_category1_idx`
  • INDEX — `fk_report_user1_idx`
  • INDEX — `fk_report_user2_idx`
  • INDEX — `fk_report_report_content_category1_idx`

report_content_category

  • id — BIGINT(20) — 기본 키 — NOT NULL
  • name — VARCHAR(45) — NOT NULL

report_reason_category

  • id — BIGINT(20) — 기본 키 — NOT NULL
  • reason — VARCHAR(45) — NOT NULL

shorts

  • id — BIGINT(20) — 기본 키 — NOT NULL
  • book_id — BIGINT(20) — 외래 키 → book.id — NOT NULL
  • user_id — BIGINT(20) — 외래 키 → user.id — NOT NULL
  • content — VARCHAR(2000) — NOT NULL
  • reg_date — TIMESTAMP — NOT NULL
  • blind_yn — TINYINT(4) — NOT NULL
  • INDEX — `fk_shorts_book1_idx`
  • INDEX — `fk_shorts_user1_idx`

shorts_attachment

  • id — BIGINT(20) — 기본 키 — NOT NULL
  • shorts_id — BIGINT(20) — 외래 키 → shorts.id — NOT NULL
  • img — VARCHAR(100) — NOT NULL
  • INDEX — `fk_shorts_attachment_shorts1_idx`

shorts_comment

  • id — BIGINT(20) — 기본 키 — NOT NULL
  • shorts_id — BIGINT(20) — 외래 키 → shorts.id — NOT NULL
  • user_id — BIGINT(20) — 외래 키 → user.id — NOT NULL
  • content — VARCHAR(500) — NOT NULL
  • reg_date — TIMESTAMP — NOT NULL
  • INDEX — `fk_shorts_comment_user1_idx`
  • INDEX — `fk_shorts_comment_shorts1_idx`

shorts_like

  • shorts_id — BIGINT(20) — 외래 키 → shorts.id — NOT NULL
  • user_id — BIGINT(20) — 외래 키 → user.id — NOT NULL
  • INDEX — `fk_shorts_like_shorts1_idx`
  • INDEX — `fk_shorts_like_user1_idx`

user

  • id — BIGINT(20) — 기본 키 — 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
  • withdraw_status — TINYINT(4) — NOT NULL
  • noti_yn — TINYINT(4) — NOT NULL
  • role — VARCHAR(45) — NOT NULL

user2

  • id — INT(11) — 기본 키 — NOT NULL
  • username — VARCHAR(255)
  • password — VARCHAR(255)
  • role — VARCHAR(255)
  • email — VARCHAR(255)

user_withdraw_status

  • id — INT(11) — 기본 키 — NOT NULL
  • status — VARCHAR(45) — NOT NULL

with

  • id — BIGINT(20) — 기본 키 — NOT NULL
  • blind_yn — TINYINT(4) — NOT NULL
  • with_reg_id — BIGINT(20) — 외래 키 → 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
  • INDEX — `fk_with_user1_idx`
  • INDEX — `fk_with_id_idx`

with_category

  • with_id — BIGINT(20) — 외래 키 → with.id — NOT NULL
  • category_id — BIGINT(20) — 외래 키 → book_category.id — NOT NULL
  • INDEX — `fk_with_id_category_idx`
  • INDEX — `fk_book_category_id_idx`

with_member

  • member_id — BIGINT(20) — 외래 키 → user.id — NOT NULL
  • with_id — BIGINT(20) — 외래 키 → with.id — NOT NULL
  • master_yn — TINYINT(4) — NOT NULL
  • kicked_yn — TINYINT(4) — NOT NULL
  • join_date — TIMESTAMP — NOT NULL
  • INDEX — `fk_with_member_with1_idx`
  • INDEX — `fk_with_member_user1_idx`