SOFTEER

Tables (19)

Company (회사)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → industry.Key — NOT NULL
  • Field
  • Field2
  • Field3

Half (반기)

  • Key — Primary key — NOT NULL
  • Field

Job Group (직군)

  • Key — Primary key — NOT NULL
  • Field

Job Role (직무)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → Job Group.Key — NOT NULL
  • Field

Question (자기소개서 질문)

  • Key — Primary key — NOT NULL
  • Field
  • Field2

Recruit (채용)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → Half.Key — NOT NULL
  • Key (Key3) — Foreign key → Company.Key — NOT NULL
  • Key (Key22) — Foreign key → Company.Key — NOT NULL
  • Field
  • Field2

company

  • company_id — BIGINT
  • name — VARCHAR(100) — NOT NULL
  • industry_id — BIGINT — NOT NULL

employment type (고용형태)

  • Key — Primary key — NOT NULL
  • Field

employment_type

  • employment_type_id — BIGINT
  • name — VARCHAR(50) — NOT NULL

essay_question

  • question_id — BIGINT
  • recruitment_id — BIGINT — NOT NULL
  • content — TEXT — NOT NULL
  • max_length — INT

experience type (경험 종류)

  • Key — Primary key — NOT NULL
  • Field

experience_type

  • experience_type_id — BIGINT
  • name — VARCHAR(50) — NOT NULL

industry

  • industry_id — BIGINT
  • name — VARCHAR(100) — NOT NULL

industry (산업군)

  • Key — Primary key — NOT NULL
  • Field
  • Field2

job_group

  • job_group_id — BIGINT
  • name — VARCHAR(50) — NOT NULL

job_role

  • job_role_id — BIGINT
  • job_group_id — BIGINT — NOT NULL
  • name — VARCHAR(100) — NOT NULL

question_trait

  • trait_id — BIGINT
  • name — VARCHAR(50) — NOT NULL

question_trait_map

  • question_id — BIGINT — Primary key — NOT NULL
  • trait_id — BIGINT — Primary key — NOT NULL

recruitment

  • recruitment_id — BIGINT
  • company_id — BIGINT — NOT NULL
  • job_role_id — BIGINT — NOT NULL
  • employment_type_id — BIGINT — NOT NULL
  • year — INT — NOT NULL
  • half — ENUM('상반기','하반기') — NOT NULL