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