Applicant

Tables (6)

Applicant (Untitled)

  • applicant_id (Key) — Primary key — NOT NULL
  • manager (Field)

ApplicantAnswer (Untitled3)

  • application_answer_id (Key2) — Primary key — NOT NULL
  • application_question_id (Key) — Foreign key → ApplicantQuestion.application_question_id — NOT NULL
  • title (Field)
  • isSubjective (Field2)

ApplicantComment (Untitled5)

  • applicant_comment_id (Key2) — Primary key — NOT NULL
  • applicant_id (Key) — Foreign key → Applicant.applicant_id — NOT NULL
  • content (Field)
  • writer (Field2)
  • writer_id (Field3)

ApplicantProgression (Untitled6)

  • applicant_progression_id (Key) — Primary key — NOT NULL
  • applicant_id (Key2) — Foreign key → Applicant.applicant_id — NOT NULL
  • progression_state(enum) (Field2)
  • done_date (Field4)

ApplicantQuestion (Untitled2)

  • application_question_id (Key) — Primary key — NOT NULL
  • title (Field)

ApplicantResponse (Untitled4)

  • application_response_id (Key) — Primary key — NOT NULL
  • applicant_id (Key3) — Foreign key → Applicant.applicant_id — NOT NULL
  • application_question_id (Key4) — Foreign key → ApplicantQuestion.application_question_id — NOT NULL
  • application_answer_id (Key2) — Foreign key → ApplicantAnswer.application_answer_id — NOT NULL
  • content (Field2)