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