olion
Tables (24)
books
- book_id — SERIAL — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- author — VARCHAR(255) — NOT NULL
- cover_image_url — TEXT — NOT NULL
- purchase_link — TEXT
- isbn — VARCHAR(20)
- publisher — VARCHAR(255)
- description — TEXT
- external_url — TEXT
- provider — VARCHAR(20)
- created_at — TIMESTAMP
community_post
- post_id — SERIAL — Primary key — NOT NULL
- room_id — INTEGER — Foreign key → community_room.room_id — NOT NULL
- author_id — INTEGER — Foreign key → user.user_id — NOT NULL
- reflection_id — INTEGER — Foreign key → reflection.reflection_id
- anonymous_nickname — VARCHAR(50) — NOT NULL
- content — TEXT — NOT NULL
- heart_count — INTEGER — NOT NULL
- report_count — INTEGER — NOT NULL
- is_blinded — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
community_room
- room_id — SERIAL — Primary key — NOT NULL
- book_id — INTEGER — Foreign key → books.book_id — NOT NULL
daily_goal_achievement
- achievement_id — SERIAL — Primary key — NOT NULL
- user_id — INTEGER — Foreign key → user.user_id — NOT NULL
- date — DATE — NOT NULL
- achieved — BOOLEAN — NOT NULL
- focused_minutes — INTEGER — NOT NULL
diagnosis_recommendation
- recommendation_id — SERIAL — Primary key — NOT NULL
- diagnosis_id — INTEGER — Foreign key → emotion_diagnosis.diagnosis_id — NOT NULL
- book_id — INTEGER — Foreign key → books.book_id — NOT NULL
- ai_curation_text — TEXT — NOT NULL
- rank — INTEGER — NOT NULL
diagnosis_swipe
- swipe_id — SERIAL — Primary key — NOT NULL
- diagnosis_id — INTEGER — Foreign key → emotion_diagnosis.diagnosis_id — NOT NULL
- card_id — INTEGER — Foreign key → emotion_card.card_id — NOT NULL
- liked — BOOLEAN — NOT NULL
emotion_card
- card_id — SERIAL — Primary key — NOT NULL
- content — VARCHAR(255) — NOT NULL
- is_active — BOOLEAN — NOT NULL
emotion_diagnosis
- diagnosis_id — SERIAL — Primary key — NOT NULL
- user_id — INTEGER — Foreign key → user.user_id — NOT NULL
- created_at — TIMESTAMP — NOT NULL
essay
- essay_id — SERIAL — Primary key — NOT NULL
- user_id — INTEGER — Foreign key → user.user_id — NOT NULL
- title — VARCHAR(255)
- status — VARCHAR(20) — NOT NULL
- published_at — TIMESTAMP
essay_chapter
- chapter_id — SERIAL — Primary key — NOT NULL
- essay_id — INTEGER — Foreign key → essay.essay_id — NOT NULL
- chapter_no — INTEGER — NOT NULL
- title — VARCHAR(255) — NOT NULL
essay_job
- job_id — SERIAL — Primary key — NOT NULL
- essay_id — INTEGER — Foreign key → essay.essay_id — NOT NULL
- status — VARCHAR(20) — NOT NULL
- requested_at — TIMESTAMP — NOT NULL
- completed_at — TIMESTAMP
essay_reflection
- essay_id — INTEGER — Foreign key → essay.essay_id — NOT NULL
- reflection_id — INTEGER — Foreign key → reflection.reflection_id — NOT NULL
- chapter_id — INTEGER — Foreign key → essay_chapter.chapter_id — NOT NULL
- order_in_chapter — INTEGER — NOT NULL
heart
- heart_id — SERIAL — Primary key — NOT NULL
- post_id — INTEGER — Foreign key → community_post.post_id — NOT NULL
- user_id — INTEGER — Foreign key → user.user_id — NOT NULL
- created_at — TIMESTAMP — NOT NULL
inspiration_capsule
- capsule_id — SERIAL — Primary key — NOT NULL
- user_id — INTEGER — Foreign key → user.user_id — NOT NULL
- book_id — INTEGER — Foreign key → books.book_id
- quote_text — TEXT — NOT NULL
- opened_date — DATE — NOT NULL
profanity_word
- word_id — SERIAL — Primary key — NOT NULL
- word — VARCHAR(100) — NOT NULL
- is_active — BOOLEAN — NOT NULL
reading_session
- session_id — SERIAL — Primary key — NOT NULL
- user_id — INTEGER — Foreign key → user.user_id — NOT NULL
- user_book_id — INTEGER — Foreign key → user_book.user_book_id — NOT NULL
- target_minutes — INTEGER — NOT NULL
- status — VARCHAR(20) — NOT NULL
- started_at — TIMESTAMP — NOT NULL
- ended_at — TIMESTAMP
reflection
- reflection_id — SERIAL — Primary key — NOT NULL
- user_id — INTEGER — Foreign key → user.user_id — NOT NULL
- session_id — INTEGER — Foreign key → reading_session.session_id
- ai_question — TEXT — NOT NULL
- content — TEXT — NOT NULL
- is_used_in_essay — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
refresh_token
- token_id — SERIAL — Primary key — NOT NULL
- user_id — INTEGER — NOT NULL
- token — VARCHAR(500) — NOT NULL
- expires_at — TIMESTAMP — NOT NULL
- revoked — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- user_id (user_id2) — SERIAL — Foreign key → user.user_id — NOT NULL
report
- report_id — SERIAL — Primary key — NOT NULL
- post_id — INTEGER — Foreign key → community_post.post_id — NOT NULL
- reporter_id — INTEGER — Foreign key → user.user_id — NOT NULL
- reason — VARCHAR(255)
- status — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
session_interruption
- interruption_id — SERIAL — Primary key — NOT NULL
- session_id — INTEGER — Foreign key → reading_session.session_id — NOT NULL
- reason — VARCHAR(30) — NOT NULL
- custom_text — TEXT
- occurred_at — TIMESTAMP — NOT NULL
streak_badge
- badge_id — SERIAL — Primary key — NOT NULL
- user_id — INTEGER — Foreign key → user.user_id — NOT NULL
- week_start_date — DATE — NOT NULL
- earned_at — TIMESTAMP — NOT NULL
support_inquiry
- inquiry_id — SERIAL — Primary key — NOT NULL
- user_id — INTEGER — Foreign key → user.user_id — NOT NULL
- content — TEXT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
user
- user_id — SERIAL — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- profile_img_url — VARCHAR(500)
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
user_book
- user_book_id — SERIAL — Primary key — NOT NULL
- user_id — INTEGER — Foreign key → user.user_id — NOT NULL
- book_id — INTEGER — Foreign key → books.book_id — NOT NULL
- status — VARCHAR(20) — NOT NULL
- pinned_order — INTEGER
- saved_at — TIMESTAMP — NOT NULL