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