온톨로지
테이블 (30)
AgeRange (9)
- age_range_id (Key) — 기본 키 — NOT NULL
- name (Field)
Assessment (20)
- assessment_id (Key) — 기본 키 — NOT NULL
- job_application_id (FK)
- hiring_stage_type_id (FK2)
- score_overall (Field)
- comment (Field2)
- assessed_at (Field3)
BenefitType (15)
- benefit_type_id (Key) — 기본 키 — NOT NULL
- name (Field)
Candidate (02)
- candidate_id (PK) — 기본 키 — NOT NULL
- name (Field)
- email (Field2)
- birth_date (Field3)
- career_level_id (FK)
- age_range_id (FK2)
- experience_range_id (FK3)
- trait_personality_id (FK4)
CareerLevel (7)
- career_level_id (Key) — 기본 키 — NOT NULL
- name (Field)
Company (01)
- company_id (Key) — 기본 키 — NOT NULL
- name (Field)
- company_size_id (FK)
- company_type_id (FK2)
- company_stage_id (FK3)
- industry_id (FK4)
- domain_id (FK5)
- location_id (FK6)
CompanyBenefit (17)
- company_id (PKFK) — 기본 키 — NOT NULL
- benefit_type_id (PKFK2) — 기본 키 — NOT NULL
CompanyCulture (18)
- company_id (PKFK) — 기본 키 — NOT NULL
- culture_id (PKFK2) — 기본 키 — NOT NULL
CompanySize (1)
- company_size_id (Key) — 기본 키 — NOT NULL
- name (Field)
CompanyStage (2)
- company_stage_id (Key) — 기본 키 — NOT NULL
- name (Field)
CompanyType (3)
- company_type_id (Key) — 기본 키 — NOT NULL
- name (Field)
Competency (26)
- competency_id (PK) — 기본 키 — NOT NULL
- name (Field)
Culture (16)
- culture_id (Key) — 기본 키 — NOT NULL
- name (Field)
Domain (5)
- domain_id (Key) — 기본 키 — NOT NULL
- name (Field)
EmploymentType (11)
- employment_type_id (Key) — 기본 키 — NOT NULL
- name (Field)
ExperienceRange (8)
- experience_range_id (Key) — 기본 키 — NOT NULL
- name (Field)
FlexibleWorkHoursType (14)
- flexible_work_hours_type_id (Key) — 기본 키 — NOT NULL
- name (Field)
HiringStageType (19)
- hiring_stage_type_id (Key) — 기본 키 — NOT NULL
- name (Field)
Industry (4)
- industry_id (Key) — 기본 키 — NOT NULL
- name (Field)
JobApplication (04)
- job_applicaiton_id (PK) — 기본 키 — NOT NULL
- job_posting_id (FK)
- candidate_id (FK2)
- current_stage_type_id (FK3)
- status (FK4)
- applied_at (FK5)
JobFamily (21)
- job_family_id (PK) — 기본 키 — NOT NULL
- name (Field)
JobLevel (23)
- job_level_id (PK) — 기본 키 — NOT NULL
- name (Field)
JobPosting (03)
- job_posting_id (PK) — 기본 키 — NOT NULL
- company_id (FK)
- job_role_id (FK2)
- job_level_id (FK3)
- employment_type_id (FK4)
- work_location_type_id (FK5)
- work_schedule_pattern_id (FK6)
- flexible_work_horus_type_id (FK7)
- title (Field)
- description (Field2)
- status (Field3)
- created_at (Field4)
JobRole (22)
- job_role_id (PK) — 기본 키 — NOT NULL
- job_family_id (FK)
- name (Field)
Location (6)
- location_id (Key) — 기본 키 — NOT NULL
- name (Field)
Skill (25)
- skill_id (PK) — 기본 키 — NOT NULL
- skill_category_id (FK)
- name (Field)
SkillCategory (24)
- skill_category_id (PK) — 기본 키 — NOT NULL
- name (Field)
TraitPersonality (10)
- trait_personality_id (Key) — 기본 키 — NOT NULL
- name (Field)
WorkLocationType (12)
- work_location_type_id (Key) — 기본 키 — NOT NULL
- name (Field)
WorkSchedulePattern (13)
- work_schedule_pattern_id (Key) — 기본 키 — NOT NULL
- name (Field)