레스고
테이블 (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`