동아리ATS1차
테이블 (21)
Interviewer (면접 평가원)
- Interviewer_id (Key) — varchar — 기본 키 — NOT NULL
- interview_id (Key2) — varchar — 외래 키 → interview.interview_id — NOT NULL
- user_id (Key3) — varchar — 외래 키 → user.user_id — NOT NULL
answer (지원서 답변)
- answer_id (Key) — string — 기본 키 — NOT NULL
- application_id (Key4) — 외래 키 → applications.application_id — NOT NULL
- question_id (Key2) — varchar — 외래 키 → application_ questions.question_id — NOT NULL
- answer_by_multiple_choice (Key3) — varchar — 외래 키 → choice_questions.option_id — NOT NULL
- recruitment_id (Key32) — varchar — 외래 키 → applications.recruitment_id — NOT NULL
- answer_by_subjective (Field2) — text
- created_at (Field3)
- updated_at (Field)
- deleted (Field4)
- isRequired (Field5) — boolean
applicants (지원자)
- applicant_id (Key) — varchar — 기본 키 — NOT NULL
- club_id (Key2) — varchar — 외래 키 → club.club_id — NOT NULL
- recruitment_id (Key3) — varchar — 외래 키 → recruitments.recruitment_id — NOT NULL
- name (Field3) — String
- imageUrl (Field4) — Stirng
- thumbnailUrl (Field5) — String
- email (Field7) — String
- phone (Field8) — String
- student_id (Field9) — String
- isFinalPassed (Field10) — boolean
- created_at (Field) — DateTime
- updated_at (Field6) — DateTime
- deleted (Field2) — boolean
application_ questions (지원서 문항(주질문))
- question_id (Key2) — varchar — 기본 키 — NOT NULL
- step_id (Key) — varchar — 외래 키 → steps.step_id — NOT NULL
- question_order (Field4) — integer
- question_text (Field) — text
- question_type (Field2) — enum
- public (Field3) — boolean
application_default_field (지원자 필수 응답 필드 정보)
- applicant_field_id (Key2) — String — 기본 키 — NOT NULL
- step_id (Key) — varchar — 외래 키 → steps.step_id — NOT NULL
- field_name (Field) — enum
applications (작성된 지원서)
- application_id (Key) — 기본 키 — NOT NULL
- applicant_id (Key2) — varchar — 외래 키 → applicants.applicant_id — NOT NULL
- step_id (Key3) — varchar — 외래 키 → steps.step_id — NOT NULL
- recruitment_id (Key32) — varchar — 외래 키 → applicants.recruitment_id — NOT NULL
- created_at (Field) — DateTime
- updated_at (Field2) — DateTime
- deleted (Field3) — boolean
choice_questions (객관식)
- option_id (Key) — varchar — 기본 키 — NOT NULL
- question_id (Key2) — varchar — 외래 키 → application_ questions.question_id — NOT NULL
- option_order (Field2) — Integer
- option_text (Field) — TEXT
club (동아리)
- club_id (Key) — varchar — 기본 키 — NOT NULL
- club_name (Field) — varchar
- club_image_url (Field3) — varchar
- club_thumbnail_url (Field4) — varchar
- club_description (Field5) — varchar
- created_at (Field7) — DateTime
- updated_at (Field8) — DateTime
- club_president_id (Field2) — int
- deleted (Field6) — boolean
club_classification (동아리분류)
- club_ classification_id (Key) — int — 기본 키 — NOT NULL
- club_classification_name (Field) — varchar
club_classification (동아리 분류 매핑테이블)
- club_id (Key) — int — 외래 키 → club.club_id — NOT NULL
- club_ classification_id (Key2) — int — 외래 키 → club_classification.club_ classification_id — NOT NULL
evaluation (평가 결과데이터(지원서,면접 통합))
- evaluation_id (Key) — varchar — 기본 키 — NOT NULL
- step_id (Key3) — varchar — 외래 키 → steps.step_id — NOT NULL
- applicant_id (Key2) — varchar — 외래 키 → applicants.applicant_id — NOT NULL
- score (Field2) — float
- comment (Field3) — text
- reviewed_by (Field) — varchar
- created_at (Field4) — DateTime
- updated_at (Field5) — DateTime
- deleted (Field6) — boolean
evaluation_permission (평가권한)
- evaluation_permission_id (Key) — varchar — 기본 키 — NOT NULL
- user_id (Key2) — varchar — 외래 키 → user.user_id — NOT NULL
- recruitment_id (Key3) — varchar — 외래 키 → recruitments.recruitment_id — NOT NULL
- created_at (Field) — DateTime
- updated_at (Field2) — DateTime
evaluation_permission_request (평가권한 요청테이블)
- evaluation_request_id (Key) — varchar — 기본 키 — NOT NULL
- user_id (Key2) — varchar — 외래 키 → user.user_id — NOT NULL
- recruitment_id (Key3) — varchar — 외래 키 → recruitments.recruitment_id — NOT NULL
- status (Field) — enum
- request_at (Field2) — DateTime
- reviewed_at (Field3) — DateTime
- reviewed_by (Field4) — varchar
interview (면접 정보)
- interview_id (Key) — varchar — 기본 키 — NOT NULL
- step_id (Key2) — varchar — 외래 키 → steps.step_id — NOT NULL
- interview_date (Field) — DateTime
- interview_time_number (Field2) — int
- interview_description (Field3) — text
interviewee (면접 대상자)
- interviewee_id (Key) — varchar — 기본 키 — NOT NULL
- interview_id (Key2) — varchar — 외래 키 → interview.interview_id — NOT NULL
- applicant_id (Key3) — varchar — 외래 키 → applicants.applicant_id — NOT NULL
recruitments (모집전형)
- recruitment_id (Key) — varchar — 기본 키 — NOT NULL
- club_id (Key2) — varchar — 외래 키 → club.club_id — NOT NULL
- recruitment_name (Field5) — varchar
- created_at (Field2) — DateTime
- updated_at (Field) — DateTime
- status (Field4) — Enum
- expire_date (Field6) — DateTime
- deleted (Field3) — boolean
role_request (사용자 역할요청테이블)
- request_id (Key) — int — 기본 키 — NOT NULL
- user_id (Key2) — varchar — 외래 키 → user.user_id — NOT NULL
- club_id (Key3) — varchar — 외래 키 → club.club_id — NOT NULL
- requested_role (Field3) — enum
- status (Field4) — enum
- request_at (Field5) — DateTime
- reviewed_at (Field6) — DateTime
- reviewed_by (Field7) — varchar
step_passer (각 step별 합격자)
- accepted_applicant_id (Key) — varchar — 기본 키 — NOT NULL
- applicant_id (Key2) — varchar — 외래 키 → applicants.applicant_id — NOT NULL
- step_id (Key3) — varchar — 외래 키 → steps.step_id — NOT NULL
steps (모집전형 옵션(지원서, 과제, 면접))
- step_id (Key) — varchar — 기본 키 — NOT NULL
- recruitment_id (Key2) — varchar — 외래 키 → recruitments.recruitment_id — NOT NULL
- step_type (Field) — enum
- step_name (Field2) — varchar
- created_at (Field3) — DateTime
- updated_at (Field4) — DateTime
- deleted (Field5) — boolean
user (사용자)
- user_id (Key) — varchar — 기본 키 — NOT NULL
- user_name (Field) — varchar
- email (Field4) — varchar
- password (Field7) — varchar
- student_id (Field6) — int
- created_at (Field2) — DateTime
- updated_at (Field3) — DateTime
- deleted (Field5) — boolean
user_club_role (동아리-사용자 역할 매핑테이블)
- id (Key) — int — 기본 키 — NOT NULL
- club_id (Key3) — int — 외래 키 → club.club_id — NOT NULL
- user_id (Key4) — int — 외래 키 → user.user_id — NOT NULL
- role (Field) — enum
- created_at (Field2) — DateTime
- updated_at (Field3) — DateTime
- deleted (Field4) — boolean