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)