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