ainjob_assignment

Tables (23)

account

  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • company_id — BIGINT — Foreign key → company.id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

account_role

  • id — BIGINT — Primary key — NOT NULL
  • account_id — BIGINT — Foreign key → account.user_id — NOT NULL
  • role_id — BIGINT — Foreign key → role.id — NOT NULL

app_history

  • id — BIGINT — Primary key — NOT NULL
  • application_id — BIGINT — Foreign key → application.id — NOT NULL
  • stage_id — BIGINT — Foreign key → stage.id — NOT NULL
  • changed_by — BIGINT — Foreign key → account.user_id
  • note — TEXT
  • idempotency_key — VARCHAR(64)
  • created_at — DATETIME — NOT NULL

applicant

  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • phone — VARCHAR(20)
  • birth_date — DATE
  • gender — CHAR(1)
  • resume_url — VARCHAR(500)
  • is_public — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

applicant_skill

  • id — BIGINT — Primary key — NOT NULL
  • applicant_id — BIGINT — Foreign key → applicant.user_id — NOT NULL
  • skill_id — BIGINT — Foreign key → skill.id — NOT NULL

application

  • id — BIGINT — Primary key — NOT NULL
  • company_id — BIGINT — Foreign key → company.id — NOT NULL
  • job_posting_id — BIGINT — Foreign key → job_posting.id — NOT NULL
  • applicant_id — BIGINT — Foreign key → applicant.user_id — NOT NULL
  • current_stage_id — BIGINT — Foreign key → stage.id
  • resume_id — BIGINT — Foreign key → resume.resume_id — NOT NULL
  • is_cancelled — TINYINT(1) — NOT NULL
  • cancel_reason — TEXT
  • profile_snapshot — JSON
  • version — INT — NOT NULL — 낙관적 락
  • applied_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

career

  • id — BIGINT — Primary key — NOT NULL
  • applicant_id — BIGINT — Foreign key → applicant.user_id — NOT NULL
  • company_name — VARCHAR(200) — NOT NULL
  • job_type — ENUM('BACKEND','FRONTEND','FULLSTACK','DEVOPS','DATA','MOBILE','OTHER') — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE
  • description — TEXT
  • created_at — DATETIME — NOT NULL

career_skill

  • id — BIGINT — Primary key — NOT NULL
  • career_id — BIGINT — Foreign key → career.id — NOT NULL
  • skill_id — BIGINT — Foreign key → skill.id — NOT NULL

company

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(200) — NOT NULL
  • biz_no — VARCHAR(20) — NOT NULL
  • plan_code — TINYINT — NOT NULL
  • status — ENUM('PENDING','ACTIVE','REJECTED','SUSPENDED','DELETED') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

education

  • id — BIGINT — Primary key — NOT NULL
  • applicant_id — BIGINT — Foreign key → applicant.user_id — NOT NULL
  • major_id — BIGINT — Foreign key → major.id
  • school_name — VARCHAR(200) — NOT NULL
  • level — ENUM('HIGH_SCHOOL','ASSOCIATE','BACHELOR','MASTER','DOCTOR') — NOT NULL
  • start_date — DATE
  • end_date — DATE
  • is_graduated — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL

job_posting

  • id — BIGINT — Primary key — NOT NULL
  • company_id — BIGINT — Foreign key → company.id — NOT NULL
  • title — VARCHAR(300) — NOT NULL
  • job_type — ENUM('BACKEND','FRONTEND','FULLSTACK','DEVOPS','DATA','MOBILE','OTHER') — NOT NULL
  • min_career_year — TINYINT — NOT NULL
  • description — TEXT
  • is_active — TINYINT(1) — NOT NULL
  • is_deleted — TINYINT(1) — NOT NULL
  • is_recommendable — TINYINT(1) — NOT NULL
  • opened_at — DATE
  • closed_at — DATE
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

job_posting_bookmark

  • id — BIGINT — Primary key — NOT NULL
  • applicant_id — BIGINT — Foreign key → applicant.user_id — NOT NULL
  • job_posting_id — BIGINT — Foreign key → job_posting.id — NOT NULL
  • created_at — DATETIME — NOT NULL

job_posting_skill

  • id — BIGINT — Primary key — NOT NULL
  • job_posting_id — BIGINT — Foreign key → job_posting.id — NOT NULL
  • skill_id — BIGINT — Foreign key → skill.id — NOT NULL
  • is_required — TINYINT(1) — NOT NULL

major

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • created_at — DATETIME — NOT NULL

operator

  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • level — TINYINT — NOT NULL
  • created_at — DATETIME — NOT NULL

permission

  • id — BIGINT — Primary key — NOT NULL
  • action — VARCHAR(100) — NOT NULL
  • description — TEXT
  • resource — TEXT

resume

  • resume_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → applicant.user_id — NOT NULL
  • title — VARCHAR(200) — NOT NULL — 이력서 제목 (예: 백엔드 지원용)
  • content — MEDIUMTEXT — 마크다운 에디터 작성 내용
  • is_public — TINYINT(1) — NOT NULL — 1 = HR 담당자 열람 허용
  • is_default — TINYINT(1) — NOT NULL — 1 = 기본 선택 이력서
  • is_deleted — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

resume_attachment

  • resume_attachment_id — BIGINT — Primary key — NOT NULL
  • resume_id — BIGINT — Foreign key → resume.resume_id — NOT NULL
  • file_name — VARCHAR(255) — NOT NULL — 원본 파일명
  • file_url — VARCHAR(500) — NOT NULL — S3 URL
  • file_type — ENUM('RESUME', 'PORTFOLIO', 'CERTIFICATE', 'OTHER') — NOT NULL
  • file_size — INT — 파일 크기 (bytes)
  • created_at — DATETIME — NOT NULL

role

  • id — BIGINT — Primary key — NOT NULL
  • company_id — BIGINT — Foreign key → company.id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT

role_permission

  • id — BIGINT — Primary key — NOT NULL
  • role_id — BIGINT — Foreign key → role.id — NOT NULL
  • permission_id — BIGINT — Foreign key → permission.id — NOT NULL

skill

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • category — VARCHAR(50)
  • created_at — DATETIME — NOT NULL

stage

  • id — BIGINT — Primary key — NOT NULL
  • company_id — BIGINT — Foreign key → company.id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • sequence — TINYINT — NOT NULL
  • is_final — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL

users

  • id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • user_type — ENUM('APPLICANT','HR','OPERATOR') — NOT NULL
  • is_active — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL