trace

Tables (23)

ai_answers

  • id — UUID
  • post_id — UUID — Foreign key → posts.id — NOT NULL
  • content — TEXT — NOT NULL
  • is_adopted — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

ai_questions

  • id — UUID
  • post_id — UUID — Foreign key → posts.id — NOT NULL
  • original_title — VARCHAR(500) — NOT NULL
  • refined_title — VARCHAR(500) — NOT NULL
  • refined_content — TEXT
  • suggestions — JSONB
  • created_at — TIMESTAMP — NOT NULL

answer_likes

  • id — UUID
  • answer_id — UUID — Foreign key → answers.id — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

answers

  • id — UUID
  • post_id — UUID — Foreign key → posts.id — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • content — TEXT — NOT NULL
  • is_adopted — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

badges

  • id — VARCHAR(50)
  • name — VARCHAR(100) — NOT NULL
  • description — VARCHAR(255)
  • sort_order — INTEGER — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

comments

  • id — UUID
  • answer_id — UUID — Foreign key → answers.id — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

content_sources

  • id — UUID
  • name — VARCHAR(100) — NOT NULL
  • url — VARCHAR(500) — NOT NULL
  • collect_method — VARCHAR(20) — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

content_tags

  • id — UUID
  • content_id — UUID — Foreign key → contents.id — NOT NULL
  • tag_id — UUID — Foreign key → tags.id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

contents

  • id — UUID
  • source_id — UUID — Foreign key → content_sources.id — NOT NULL
  • title — VARCHAR(500) — NOT NULL
  • author — VARCHAR(100)
  • canonical_url — VARCHAR(1000) — NOT NULL
  • preview — TEXT
  • thumbnail_url — TEXT
  • is_original_visible — BOOLEAN — NOT NULL
  • license_type — VARCHAR(50)
  • original_content — TEXT
  • published_at — TIMESTAMP
  • is_available — BOOLEAN — NOT NULL
  • takedown_requested_at — TIMESTAMP
  • score — INTEGER
  • view_count — INTEGER
  • is_answered — BOOLEAN
  • question_content — TEXT
  • accepted_answer — TEXT
  • top_answers — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

email_verifications

  • id — UUID
  • email — VARCHAR(255) — NOT NULL
  • is_verified — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

likes

  • id — UUID
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • content_id — UUID — Foreign key → contents.id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

post_likes

  • id — UUID
  • post_id — UUID — Foreign key → posts.id — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

posts

  • id — UUID
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • title — VARCHAR(500) — NOT NULL
  • content — TEXT — NOT NULL
  • level — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

quiz_attempts

  • id — UUID
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • content_id — UUID — Foreign key → contents.id — NOT NULL
  • level — VARCHAR(20) — NOT NULL
  • score — INTEGER — NOT NULL
  • total_questions — INTEGER — NOT NULL
  • passed — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

refresh_tokens

  • id — UUID
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • token — VARCHAR(500) — NOT NULL
  • expires_at — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

scraps

  • id — UUID
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • content_id — UUID — Foreign key → contents.id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

similar_questions

  • id — UUID
  • post_id — UUID — Foreign key → posts.id — NOT NULL
  • similar_id — UUID — Foreign key → posts.id — NOT NULL
  • score — REAL — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

social_accounts

  • id — UUID
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • provider — VARCHAR(20) — NOT NULL
  • provider_id — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

tags

  • id — UUID
  • name — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

user_consents

  • id — UUID
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • consent_type — VARCHAR(30) — NOT NULL
  • agreed_at — TIMESTAMP — NOT NULL

user_tags

  • id — UUID
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • tag_id — UUID — Foreign key → tags.id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

users

  • id — UUID
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255)
  • nickname — VARCHAR(50) — NOT NULL
  • profile_image — VARCHAR(500)
  • job — VARCHAR(50) — NOT NULL
  • level — VARCHAR(20) — NOT NULL
  • total_points — INTEGER — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • is_email_verified — BOOLEAN — NOT NULL
  • deleted_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

weekly_reports

  • id — UUID
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • week_start — DATE — NOT NULL
  • week_end — DATE — NOT NULL
  • share_token — VARCHAR(100)
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL