fk-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)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

gathering

  • gathering_id — BIGSERIAL
  • gathering_leader_id — BIGINT — Foreign key → users.user_id — 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 — Foreign key → gathering.gathering_id — NOT NULL
  • book_id — BIGINT — Foreign key → book.book_id — NOT NULL
  • added_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

gathering_member

  • gathering_member_id — BIGSERIAL
  • gathering_id — BIGINT — Foreign key → gathering.gathering_id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — 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 — Foreign key → keyword.keyword_id
  • 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 — Foreign key → gathering.gathering_id — NOT NULL
  • book_id — BIGINT — Foreign key → book.book_id
  • meeting_leader_id — BIGINT — Foreign key → users.user_id
  • meeting_name — VARCHAR(100)
  • 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_start_date — TIMESTAMP
  • meeting_end_date — TIMESTAMP

meeting_member

  • meeting_member_id — BIGSERIAL
  • meeting_id — BIGINT — Foreign key → meeting.meeting_id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • attendance_status — VARCHAR(20) — NOT NULL
  • joined_at — TIMESTAMP — NOT NULL
  • cancled_at — TIMESTAMP
  • updated_at — TIMESTAMP — NOT NULL

personal_book

  • personal_book_id — BIGSERIAL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • book_id — BIGINT — Foreign key → book.book_id — 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 — Foreign key → personal_book.personal_book_id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — 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 — Foreign key → users.user_id — NOT NULL
  • book_id — BIGINT — Foreign key → book.book_id — NOT NULL
  • one_line_summary — TEXT
  • top_keywords — TEXT
  • meeting_impact_data — JSONB
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

retrospective

  • retrospective_id — BIGSERIAL
  • meeting_id — BIGINT — Foreign key → meeting.meeting_id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — 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

shared_retrospective

  • shared_retrospective_id — BIGSERIAL
  • meeting_id — BIGINT — Foreign key → meeting.meeting_id — NOT NULL
  • summary — TEXT
  • key_topics — TEXT
  • created_by — BIGINT — Foreign key → users.user_id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

topic

  • topic_id — BIGSERIAL
  • meeting_id — BIGINT — Foreign key → meeting.meeting_id — NOT NULL
  • proposed_by — BIGINT — Foreign key → users.user_id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • topic_type — VARCHAR(30) — NOT NULL
  • 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 — Foreign key → topic.topic_id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — 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

topic_answer_keyword

  • topic_answer_keyword_id — BIGSERIAL
  • topic_answer_id — BIGINT — Foreign key → topic_answer.topic_answer_id — NOT NULL
  • keyword_id — BIGINT — Foreign key → keyword.keyword_id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

topic_setting

  • topic_setting_id — BIGSERIAL
  • meeting_id — BIGINT — Foreign key → meeting.meeting_id — 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 — Foreign key → topic.topic_id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • voted_at — TIMESTAMP — NOT NULL
  • voted — BOOLEAN

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