온톨로지

테이블 (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)