ㅋㅋ
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