ㅋㅋ

Tables (45)

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

history

  • id — UUID
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • action_type — VARCHAR(50) — NOT NULL
  • content_id — UUID — Foreign key → contents.id
  • post_id — UUID — Foreign key → posts.id
  • answer_id — UUID — Foreign key → answers.id
  • created_at — TIMESTAMP — NOT NULL

job_bookmarks

  • id — UUID
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • job_posting_id — UUID — Foreign key → job_postings.id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

job_interview_qa

  • id — UUID
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • job_posting_id — UUID — Foreign key → job_postings.id — NOT NULL
  • payload_json — TEXT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

job_mock_interview_session

  • id — UUID
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • job_posting_id — UUID — Foreign key → job_postings.id
  • company_name — VARCHAR(255) — NOT NULL
  • job_title — VARCHAR(512) — NOT NULL
  • job_category — VARCHAR(32)
  • raw_jd_text — TEXT
  • status — VARCHAR(24) — NOT NULL
  • mode — VARCHAR(16) — NOT NULL
  • model_key — VARCHAR(32) — NOT NULL
  • phase — VARCHAR(16) — NOT NULL
  • current_question_index — INTEGER — NOT NULL
  • answered_count — INTEGER — NOT NULL
  • plan_json — TEXT — NOT NULL
  • result_json — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

job_mock_interview_turn

  • id — UUID
  • session_id — UUID — Foreign key → job_mock_interview_session.id — NOT NULL
  • order_no — INTEGER — NOT NULL
  • question_no — INTEGER — NOT NULL
  • phase — VARCHAR(24) — NOT NULL
  • type — VARCHAR(24) — NOT NULL
  • content — TEXT
  • rating — VARCHAR(16)
  • metadata_json — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

job_posting_benefits

  • job_posting_id — UUID — Foreign key → job_postings.id — NOT NULL
  • line — VARCHAR(500)

job_posting_hiring_process

  • job_posting_id — UUID — Foreign key → job_postings.id — NOT NULL
  • line — VARCHAR(500)

job_posting_jd_images

  • job_posting_id — UUID — Foreign key → job_postings.id — NOT NULL
  • url — VARCHAR(2048)

job_posting_preferred_bullets

  • job_posting_id — UUID — Foreign key → job_postings.id — NOT NULL
  • line — VARCHAR(2000)

job_posting_preferred_skills

  • job_posting_id — UUID — Foreign key → job_postings.id — NOT NULL
  • skill — VARCHAR(120)

job_posting_required_skills

  • job_posting_id — UUID — Foreign key → job_postings.id — NOT NULL
  • skill — VARCHAR(120)

job_posting_requirement_bullets

  • job_posting_id — UUID — Foreign key → job_postings.id — NOT NULL
  • line — VARCHAR(2000)

job_posting_responsibilities

  • job_posting_id — UUID — Foreign key → job_postings.id — NOT NULL
  • line — VARCHAR(2000)

job_posting_tech_stack

  • job_posting_id — UUID — Foreign key → job_postings.id — NOT NULL
  • tech — VARCHAR(120)

job_postings

  • id — UUID
  • source — VARCHAR(32) — NOT NULL
  • source_url — VARCHAR(2048) — NOT NULL
  • company_name — VARCHAR(255) — NOT NULL
  • company_logo_url — VARCHAR(1024)
  • title — VARCHAR(512) — NOT NULL
  • employment_type — VARCHAR(32) — NOT NULL
  • job_category — VARCHAR(32) — NOT NULL
  • experience_level — VARCHAR(32) — NOT NULL
  • location — VARCHAR(255)
  • salary_display — VARCHAR(255)
  • deadline — DATE
  • rolling_deadline — BOOLEAN — NOT NULL
  • apply_url — VARCHAR(2048)
  • status — VARCHAR(32) — NOT NULL
  • parse_status — VARCHAR(32) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

job_skill_gaps

  • id — UUID
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • job_posting_id — UUID — Foreign key → job_postings.id — NOT NULL
  • result_json — TEXT — 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

master_resumes

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

point_logs

  • id — UUID
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • action — VARCHAR(50) — NOT NULL
  • points — INTEGER — NOT NULL
  • reference_id — UUID
  • earned_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

report_activities

  • id — UUID
  • report_id — UUID — Foreign key → weekly_reports.id — NOT NULL
  • contents_read — INTEGER — NOT NULL
  • questions_created — INTEGER — NOT NULL
  • scraps_count — INTEGER — NOT NULL
  • top_tags — JSONB
  • prev_week_comparison — JSONB
  • daily_activities — JSONB
  • tag_activities — JSONB
  • 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

subscriptions

  • id — UUID
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • toss_billing_key — VARCHAR(200) — NOT NULL
  • toss_customer_key — VARCHAR(100) — NOT NULL
  • payment_key — VARCHAR(200)
  • plan_type — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • pending_plan_type — VARCHAR(20)
  • amount — INTEGER — NOT NULL
  • started_at — TIMESTAMP — NOT NULL
  • expired_at — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

tags

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

trend_snapshots

  • id — UUID
  • unit — VARCHAR(10) — NOT NULL
  • scope — VARCHAR(20) — NOT NULL
  • period_start — DATE — NOT NULL
  • period_end — DATE — NOT NULL
  • payload — JSONB — NOT NULL
  • generated_at — TIMESTAMP — NOT NULL
  • expires_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL

user_badges

  • id — UUID
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • badge_id — VARCHAR(50) — Foreign key → badges.id — NOT NULL
  • acquired_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
  • plan_type — VARCHAR(20) — NOT NULL
  • toss_billing_key — VARCHAR(200)
  • toss_customer_key — VARCHAR(100)
  • plan_expired_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