test_jobis

Tables (18)

companies

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(200) — NOT NULL
  • description — VARCHAR(1000)
  • logo_url — VARCHAR(500)
  • source — VARCHAR(50)

deck_items

  • id — BIGINT — Primary key — NOT NULL
  • deck_id — BIGINT — Foreign key → decks.id — NOT NULL
  • job_id — BIGINT — Foreign key → jobs.id
  • news_content_id — BIGINT
  • position — INT — NOT NULL
  • fit_score — DECIMAL(5,2)
  • reason — VARCHAR(300)
  • summary — VARCHAR(500)
  • status — VARCHAR(20) — NOT NULL

decks

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • deck_date — DATE — NOT NULL
  • slot — VARCHAR(10) — NOT NULL
  • empty_reason — VARCHAR(30)
  • first_opened_at — DATETIME
  • completed_at — DATETIME
  • created_at — DATETIME — NOT NULL

job_categories

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • group_name — VARCHAR(100)
  • sort_order — INT

jobs

  • id — BIGINT — Primary key — NOT NULL
  • company_id — BIGINT — Foreign key → companies.id
  • job_category_id — BIGINT — Foreign key → job_categories.id
  • region_id — BIGINT — Foreign key → regions.id
  • title — VARCHAR(255) — NOT NULL
  • career_level — VARCHAR(30)
  • employment_type — VARCHAR(30)
  • remote_available — BOOLEAN — NOT NULL
  • salary_disclosed — BOOLEAN — NOT NULL
  • source — VARCHAR(50)
  • source_url — VARCHAR(500)
  • posted_at — DATETIME
  • deadline_at — DATETIME
  • status — VARCHAR(20) — NOT NULL
  • editor_note — VARCHAR(1000)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

news_contents

  • id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • type — VARCHAR(20) — NOT NULL
  • source — VARCHAR(100)
  • body_summary — VARCHAR(1000)
  • apply_period_start — DATE
  • apply_period_end — DATE
  • review_status — VARCHAR(20) — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • global_expose_flag — BOOLEAN — NOT NULL
  • created_by — BIGINT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

notification_settings

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • email_subscribed — BOOLEAN — NOT NULL
  • send_slot — VARCHAR(10) — NOT NULL
  • snooze_until — DATE
  • email_verified — BOOLEAN — NOT NULL
  • updated_at — DATETIME

personality_test_answers

  • id — BIGINT — Primary key — NOT NULL
  • test_id — BIGINT — Foreign key → personality_tests.id — NOT NULL
  • question_no — INT — NOT NULL
  • choice_value — VARCHAR(50) — NOT NULL
  • answered_at — DATETIME — NOT NULL

personality_tests

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • source — VARCHAR(20) — NOT NULL
  • is_completed — BOOLEAN — NOT NULL
  • result_tags — VARCHAR(500)
  • started_at — DATETIME — NOT NULL
  • completed_at — DATETIME

regions

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • parent_id — BIGINT
  • sort_order — INT

resumes

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • file_name — VARCHAR(255) — NOT NULL
  • file_type — VARCHAR(10) — NOT NULL
  • file_url — VARCHAR(500) — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • uploaded_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

saved_jobs

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • job_id — BIGINT — Foreign key → jobs.id — NOT NULL
  • saved_at — DATETIME — NOT NULL
  • self_reported_status — VARCHAR(20)
  • unsaved_at — DATETIME

user_actions

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • job_id — BIGINT — Foreign key → jobs.id — NOT NULL
  • action_type — VARCHAR(30) — NOT NULL
  • reason_code — VARCHAR(30)
  • source_screen — VARCHAR(20)
  • created_at — DATETIME — NOT NULL

user_job_categories

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • job_category_id — BIGINT — Foreign key → job_categories.id — NOT NULL
  • is_primary — BOOLEAN — NOT NULL

user_profiles

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • career_stage — VARCHAR(30)
  • remote_only — BOOLEAN — NOT NULL
  • preference_note — VARCHAR(500)
  • exclude_keywords — VARCHAR(500)
  • tech_stack — VARCHAR(500)
  • profile_confirmed — BOOLEAN — NOT NULL
  • onboarding_completed — BOOLEAN — NOT NULL
  • onboarding_completed_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

user_regions

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • region_id — BIGINT — Foreign key → regions.id — NOT NULL

users

  • id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — 임시 컬럼
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME
  • withdrawn_at — DATETIME

withdrawal_requests

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • reason_code — VARCHAR(30)
  • requested_at — DATETIME — NOT NULL
  • scheduled_deletion_at — DATETIME
  • restored_at — DATETIME
  • status — VARCHAR(20) — NOT NULL