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