아인잡
테이블 (24)
account
- id — BIGINT — 기본 키 — NOT NULL
- company_id — BIGINT — 외래 키 → company.id — NOT NULL
- email — VARCHAR(255) — NOT NULL
- account_name — VARCHAR(100) — NOT NULL
- is_active — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
account_role
- id — BIGINT — 기본 키 — NOT NULL
- company_id — BIGINT — 외래 키 → company.id — NOT NULL
- account_id — BIGINT — 외래 키 → account.id — NOT NULL
- role_id — BIGINT — 외래 키 → role.id — NOT NULL
- created_at — TIMESTAMP — NOT NULL
app_history
- id — BIGINT — 기본 키 — NOT NULL
- company_id — BIGINT — 외래 키 → company.id — NOT NULL
- application_id — BIGINT — 외래 키 → application.id — NOT NULL
- from_stage_id — BIGINT — 외래 키 → stage.id
- to_stage_id — BIGINT — 외래 키 → stage.id
- action_type — SMALLINT — NOT NULL
- reason — VARCHAR(255)
- changed_by_account_id — BIGINT — 외래 키 → account.id
- idempotency_key — VARCHAR(100)
- created_at — TIMESTAMP — NOT NULL
applicant
- id — BIGINT — 기본 키 — NOT NULL
- company_id — BIGINT — 외래 키 → company.id — NOT NULL
- company_segment — VARCHAR(50)
- applicant_name — VARCHAR(100) — NOT NULL
- birth_day — DATE
- email — VARCHAR(255)
- total_career_years — INTEGER
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
applicant_skill
- id — BIGINT — 기본 키 — NOT NULL
- applicant_id — BIGINT — 외래 키 → applicant.id — NOT NULL
- skill_id — BIGINT — 외래 키 → skill.skill_id — NOT NULL
- created_at — TIMESTAMP — NOT NULL
application
- id — BIGINT — 기본 키 — NOT NULL
- company_id — BIGINT — 외래 키 → company.id — NOT NULL
- job_posting_id — BIGINT — 외래 키 → job_posting.id — NOT NULL
- applicant_id — BIGINT — 외래 키 → applicant.id — NOT NULL
- current_stage_id — BIGINT — 외래 키 → stage.id — NOT NULL
- ai_recommend_score — DECIMAL(5,2)
- applied_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
application_resume_snapshot
- id — BIGINT — 기본 키 — NOT NULL
- company_id — BIGINT — 외래 키 → company.id — NOT NULL
- application_id — BIGINT — 외래 키 → application.id — NOT NULL
- applicant_name — VARCHAR(100) — NOT NULL
- birth_day — DATE
- email — VARCHAR(255)
- total_career_years — INTEGER
- current_company_name — VARCHAR(200)
- current_company_years — DECIMAL(5,2)
- current_company_position — VARCHAR(100)
- previous_company_1_name — VARCHAR(200)
- previous_company_1_years — DECIMAL(5,2)
- previous_company_1_position — VARCHAR(100)
- school_name — VARCHAR(200)
- doctor_major — VARCHAR(200)
- master_major — VARCHAR(200)
- bachelor_major — VARCHAR(200)
- associate_major — VARCHAR(200)
- snapshot_json — TEXT
- created_at — TIMESTAMP — NOT NULL
application_resume_snapshot_skill
- id — BIGINT — 기본 키 — NOT NULL
- application_resume_snapshot_id — BIGINT — 외래 키 → application_resume_snapshot.id — NOT NULL
- source_type — SMALLINT — NOT NULL
- skill_id — BIGINT — 외래 키 → skill.skill_id — NOT NULL
- created_at — TIMESTAMP — NOT NULL
career
- id — BIGINT — 기본 키 — NOT NULL
- applicant_id — BIGINT — 외래 키 → applicant.id — NOT NULL
- job_type_id — SMALLINT — 외래 키 → job_type.id
- career_order — SMALLINT — NOT NULL
- company_name — VARCHAR(200) — NOT NULL
- employment_years — DECIMAL(5,2)
- position_name — VARCHAR(100)
- created_at — TIMESTAMP — NOT NULL
career_skill
- id — BIGINT — 기본 키 — NOT NULL
- career_id — BIGINT — 외래 키 → career.id — NOT NULL
- skill_id — BIGINT — 외래 키 → skill.skill_id — NOT NULL
- created_at — TIMESTAMP — NOT NULL
company
- id — BIGINT — 기본 키 — NOT NULL
- company_code — VARCHAR(50) — NOT NULL
- company_name — VARCHAR(200) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
degree
- id — BIGINT — 기본 키 — NOT NULL
- degree_name — VARCHAR(100) — NOT NULL
- degree_level — SMALLINT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
education
- id — BIGINT — 기본 키 — NOT NULL
- applicant_id — BIGINT — 외래 키 → applicant.id — NOT NULL
- school_id — BIGINT — 외래 키 → school.id — NOT NULL
- major_id — BIGINT — 외래 키 → major.id
- degree_id — BIGINT — 외래 키 → degree.id — NOT NULL
- created_at — TIMESTAMP — NOT NULL
job_posting
- id — BIGINT — 기본 키 — NOT NULL
- company_id — BIGINT — 외래 키 → company.id — NOT NULL
- job_type_id — SMALLINT — 외래 키 → job_type.id
- job_title — VARCHAR(200) — NOT NULL
- job_type_code — SMALLINT — NOT NULL
- min_career_years — INTEGER — NOT NULL
- is_major_required — BOOLEAN — NOT NULL
- created_by_account_id — BIGINT — 외래 키 → account.id
- created_at — TIMESTAMP — NOT NULL
job_posting_major
- id — BIGINT — 기본 키 — NOT NULL
- company_id — BIGINT — 외래 키 → company.id — NOT NULL
- job_posting_id — BIGINT — 외래 키 → job_posting.id — NOT NULL
- major_id — BIGINT — 외래 키 → major.id — NOT NULL
- created_at — TIMESTAMP — NOT NULL
job_posting_skill
- id — BIGINT — 기본 키 — NOT NULL
- company_id — BIGINT — 외래 키 → company.id — NOT NULL
- job_posting_id — BIGINT — 외래 키 → job_posting.id — NOT NULL
- skill_id — BIGINT — 외래 키 → skill.skill_id — NOT NULL
- is_required — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
job_type
- id — SMALLINT — 기본 키
- job_type_code — VARCHAR(50) — NOT NULL
- job_type_name — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
major
- id — BIGINT — 기본 키 — NOT NULL
- major_name — VARCHAR(200) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
permission
- id — BIGINT — 기본 키 — NOT NULL
- permission_code — VARCHAR(100) — NOT NULL
- description — VARCHAR(255) — NOT NULL
role
- id — BIGINT — 기본 키 — NOT NULL
- company_id — BIGINT — 외래 키 → company.id — NOT NULL
- role_code — VARCHAR(50) — NOT NULL
- role_name — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
role_permission
- id — BIGINT — 기본 키 — NOT NULL
- role_id — BIGINT — 외래 키 → role.id — NOT NULL
- permission_id — BIGINT — 외래 키 → permission.id — NOT NULL
- created_at — TIMESTAMP — NOT NULL
school
- id — BIGINT — 기본 키 — NOT NULL
- school_name — VARCHAR(200) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
skill
- skill_id — BIGINT — 기본 키 — NOT NULL
- skill_key — VARCHAR(100) — NOT NULL
- skill_name — VARCHAR(200) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
stage
- id — BIGINT — 기본 키 — NOT NULL
- company_id — BIGINT — 외래 키 → company.id — NOT NULL
- stage_code — VARCHAR(50) — NOT NULL
- stage_name — VARCHAR(100) — NOT NULL
- sequence — INTEGER — NOT NULL
- is_final — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL