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