erd
Tables (18)
book
- book_id — BIGSERIAL
- book_name — VARCHAR(255) — NOT NULL — 책
- publisher — VARCHAR(100) — 출판사
- author — VARCHAR(100) — 저자
- category — VARCHAR(100) — 카테고리
- book_image_url — VARCHAR(500) — 책
- isbn — VARCHAR(20) — ISBN
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
gathering
- gathering_id — BIGSERIAL
- gathering_leader_id — BIGINT — NOT NULL — 모임장
- gathering_name — VARCHAR(255) — NOT NULL — 모임
- description — TEXT — 모임
- invitation_link — VARCHAR(255) — NOT NULL — 초대
- gathering_status — VARCHAR(20) — NOT NULL — 모임
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
gathering_book
- gathering_book_id — BIGSERIAL
- gathering_id — BIGINT — NOT NULL — 모임
- book_id — BIGINT — NOT NULL — 책
- added_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
gathering_member
- gathering_member_id — BIGSERIAL
- gathering_id — BIGINT — NOT NULL — 모임
- user_id — BIGINT — NOT NULL — 사용자
- is_favorite — BOOLEAN — NOT NULL — 즐겨찾기
- role — VARCHAR(20) — NOT NULL — 역할
- joined_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- removed_at — TIMESTAMP
keyword
- keyword_id — BIGSERIAL
- keyword_type — VARCHAR(30) — NOT NULL — 키워드
- keyword_name — VARCHAR(50) — NOT NULL — 키워드
- parent_id — BIGINT — 부모
- level — INT — NOT NULL — 계층
- sort_order — INT — 정렬
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
meeting
- meeting_id — BIGSERIAL
- gathering_id — BIGINT — NOT NULL — 모임
- book_id — BIGINT — 책
- meeting_leader_id — BIGINT — 약속장
- meeting_name — VARCHAR(100) — 약속
- meeting_schedule — TIMESTAMP — NOT NULL — 약속
- place — VARCHAR(255) — 장소
- max_participants — INT — 최대
- meeting_status — VARCHAR(20) — NOT NULL — 약속
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
meeting_member
- meeting_member_id — BIGSERIAL
- meeting_id — BIGINT — NOT NULL — 약속
- user_id — BIGINT — NOT NULL — 사용자
- attendance_status — VARCHAR(20) — NOT NULL — 참석
- joined_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
personal_book
- personal_book_id — BIGSERIAL
- user_id — BIGINT — NOT NULL — 사용자
- book_id — BIGINT — NOT NULL — 책
- reading_status — VARCHAR(20) — 독서
- added_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
personal_reading_record
- record_id — BIGSERIAL
- personal_book_id — BIGINT — NOT NULL — 개인
- user_id — BIGINT — NOT NULL — 사용자
- record_content — TEXT — 기록
- is_published — BOOLEAN — NOT NULL — 발행
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
reading_summary
- summary_id — BIGSERIAL
- user_id — BIGINT — NOT NULL — 사용자
- book_id — BIGINT — NOT NULL — 책
- one_line_summary — TEXT — AI
- top_keywords — TEXT — 상위
- meeting_impact_data — JSONB — 모임
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- UNIQUE(user_id, — book_id)
retrospective
- retrospective_id — BIGSERIAL
- meeting_id — BIGINT — NOT NULL — 약속
- user_id — BIGINT — NOT NULL — 사용자
- changed_thought — TEXT — 모임을
- impressive_perspective — TEXT — 인상
- reread_part — TEXT — 다시
- is_shared — BOOLEAN — NOT NULL — 공유
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
- UNIQUE(meeting_id, — user_id)
shared_retrospective
- shared_retrospective_id — BIGSERIAL
- meeting_id — BIGINT — NOT NULL — 약속
- summary — TEXT — 회고
- key_topics — TEXT — 핵심
- created_by — BIGINT — NOT NULL — 작성자
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
topic
- topic_id — BIGSERIAL
- meeting_id — BIGINT — NOT NULL — 약속
- proposed_by — BIGINT — NOT NULL — 제안자
- title — VARCHAR(255) — NOT NULL — 주제
- description — TEXT — 주제
- topic_type — VARCHAR(30) — NOT NULL — 주제
- custom_topic_type — VARCHAR(50) — 커스텀
- topic_status — VARCHAR(20) — NOT NULL — 주제
- vote_count — INT — NOT NULL — 투표
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
topic_answer
- topic_answer_id — BIGSERIAL
- topic_id — BIGINT — NOT NULL — 주제
- user_id — BIGINT — NOT NULL — 사용자
- book_rating — DECIMAL(2,1) — 책
- content — TEXT — 답변
- is_submitted — BOOLEAN — NOT NULL — 제출
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
- UNIQUE(topic_id, — user_id)
topic_answer_keyword
- topic_answer_keyword_id — BIGSERIAL
- topic_answer_id — BIGINT — NOT NULL — 주제
- keyword_id — BIGINT — NOT NULL — 키워드
- created_at — TIMESTAMP — NOT NULL
topic_setting
- topic_setting_id — BIGSERIAL
- meeting_id — BIGINT — NOT NULL — 약속
- vote_deadline — TIMESTAMP — 투표
- auto_confirm_top_n — INT — 자동
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
topic_vote
- topic_vote_id — BIGSERIAL
- topic_id — BIGINT — NOT NULL — 주제
- user_id — BIGINT — NOT NULL — 사용자
- voted_at — TIMESTAMP — NOT NULL
- UNIQUE(topic_id, — user_id)
users
- user_id — BIGSERIAL
- user_name — VARCHAR(100) — 사용자
- nickname — VARCHAR(100) — NOT NULL — 닉네임
- user_email — VARCHAR(255) — 이메일
- profile_image_url — VARCHAR(500) — 프로필
- kakao_id — BIGINT — NOT NULL — 카카오
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP — soft