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