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