동아리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