ATRK
Tables (7)
apply (지원서)
- id (Key) — LONG — Primary key — NOT NULL
- user_id (유저 PK) — LONG — Foreign key → atrk_user.id — NOT NULL
- company_id (회사 PK) — LONG — Foreign key → company.id — NOT NULL
- job_position (지원 포지션) — LONG — Foreign key → position.id — NOT NULL
atrk_user (유저)
- id (Key) — LONG — Primary key — NOT NULL
- nick_name (Field) — VARCHAR
- email (Field2) — VARCHAR
- job_position (Field3) — VARCHAR
- sso (Field4) — VARCHAR
company (회사)
- id (Key) — LONG — Primary key — NOT NULL
- name (Field) — VARCHAR
position (포지션)
- id (Key) — LONG — Primary key — NOT NULL
- title (포지션 명) — LONG
stage (전형)
- id (Key) — LONG — Primary key — NOT NULL
- user_id (유저 PK) — LONG — Foreign key → atrk_user.id — NOT NULL
- title (전형명) — VARCHAR
- standard (유저공통전형여부) — VARCHAR
stage_content (후기내용)
- id (Key) — LONG — Primary key — NOT NULL
- stage_progress_id (전형진행상황 PK) — LONG — Foreign key → stage_progress.id — NOT NULL
- content (Field2) — VARCHAR
stage_progress (전형진행상황)
- id (Key) — LONG — Primary key — NOT NULL
- apply_id (지원서 PK) — LONG — Foreign key → apply.id — NOT NULL
- stage_content_id (후기내용 PK) — LONG
- stage_id (전형 PK) — LONG
- sequence (후기순서) — INT
- progress_status (전형진행상태) — INT