RYC 2차

테이블 (19)

admins (관리자)

  • id (Key) — varchar — 기본 키 — NOT NULL
  • email (Field5) — varchar
  • name (Field2) — varchar
  • image_url (Field3) — varchar
  • thumbnail_url (Field4) — varchar
  • password (Field) — varchar
  • created_at (Field6) — DateTime
  • updated_at (Field7) — DateTime
  • deleted (Field8) — boolean

announcement (공고)

  • id (Key) — varchar — 기본 키 — NOT NULL
  • title (Field5) — varchar
  • introduction (Field10) — varchar
  • number_of_people (Field8) — int
  • interview_start_date (Field4) — date
  • interview_end_date (Field9) — date
  • expire_date (Field6) — DateTime
  • created_at (Field2) — DateTime
  • updated_at (Field) — DateTime
  • deleted (Field3) — boolean
  • club_id (Key2) — varchar — 외래 키 → clubs.id — NOT NULL

applicants (공고 지원자)

  • id (Key3) — varchar — 기본 키 — NOT NULL
  • email (Field) — varchar
  • temp_password (Field2) — varchar
  • status (Field6) — enum
  • created_at (Field3) — varchar
  • updated_at (Field4) — varchar
  • deleted (Field5) — boolean
  • step_id (Key) — varchar — 외래 키 → steps.id — NOT NULL

application_questions (자기소개서 질문)

  • id (Key) — varchar — 기본 키 — NOT NULL
  • title (Field) — varchar
  • description (Field2) — varchar
  • recruitment_id (Key2) — varchar — 외래 키 → announcement.id — NOT NULL

applications (자기소개서)

  • question_id (Key2) — varchar — 외래 키 → application_questions.id — NOT NULL
  • applicant_id (Key3) — varchar — 외래 키 → applicants.id — NOT NULL
  • answer (Field) — varchar
  • created_at (Field3) — DateTime
  • updated_at (Field4) — DateTime

club_detail_images (동아리상세이미지)

  • image_url (Key) — varchar — 기본 키 — NOT NULL
  • thumbnail_url (Key3) — varchar — 기본 키 — NOT NULL
  • club_id (Key2) — varchar — 외래 키 → clubs.id — NOT NULL

club_summaries (동아리 요약)

  • title (Key) — varchar — 기본 키 — NOT NULL
  • value (Key3) — varchar — 기본 키 — NOT NULL
  • club_id (Key2) — varchar — 외래 키 → clubs.id — NOT NULL

club_tag (동아리-태그)

  • name (Key2) — varchar — 기본 키 — NOT NULL
  • club_id (Key) — varchar — 외래 키 → clubs.id — NOT NULL

clubs (동아리)

  • id (Key) — varchar — 기본 키 — NOT NULL
  • name (Field) — varchar
  • category (Field9) — enum
  • short_description (Field5) — varchar
  • detail_description (Field2) — varchar
  • image_url (Field3) — varchar
  • thumbnail_url (Field4) — varchar
  • created_at (Field7) — DateTime
  • updated_at (Field8) — DateTime
  • deleted (Field6) — boolean

evaluations (평가)

  • applicant_id (Key22) — varchar — 외래 키 — NOT NULL
  • admin_id (Key) — varchar — 외래 키 → admins.id — NOT NULL
  • score (Field) — float
  • comment (Field2) — varchar
  • created_at (Field3) — varchar
  • updated_at (Field4) — varchar

images (공고 이미지)

  • id (Key) — varchar — 기본 키 — NOT NULL
  • image_url (Field) — varchar
  • thumbnail_url (Field2) — varchar
  • recruitment_id (Key2) — varchar — 외래 키 → announcement.id — NOT NULL

interview_dates (면접 날짜)

  • id (Key3) — varchar — 기본 키 — NOT NULL
  • date_time (Field) — DateTime
  • created_at (Field2) — varchar
  • updated_at (Field3) — varchar
  • step_id (Key) — varchar — 외래 키 → steps.id — NOT NULL
  • applicant_id (Key32) — varchar — 외래 키 → applicants.id — NOT NULL

pre_answers (사전 질문 답변)

  • recruitment_id (Key2) — varchar — 외래 키 → pre_questions.recruitment_id — NOT NULL
  • applicant_id (Key3) — varchar — 외래 키 → applicants.id — NOT NULL
  • answer (Field) — JSON
  • created_at (Field2) — varchar
  • updated_at (Field3) — varchar

pre_questions (사전 질문)

  • recruitment_id (Key2) — varchar — 외래 키 → announcement.id — NOT NULL
  • title (Field) — JSON

private_comments (내 코멘트)

  • admin_id (Key2) — varchar — 외래 키 → admins.id — NOT NULL
  • applicant_id (Key3) — varchar — 외래 키 → applicants.id — NOT NULL
  • comment (Field) — varchar
  • created_at (Field2) — DateTime
  • updated_at (Field3) — DateTime

recruitment_tag (공고-태그)

  • id (Key2) — varchar — 기본 키 — NOT NULL
  • name (Field) — varchar
  • recruitment_id (Key) — varchar — 외래 키 → announcement.id — NOT NULL

role_requests (역할 요청)

  • club_id (Key2) — varchar — 외래 키 → clubs.id — NOT NULL
  • admin_id (Key) — varchar — 외래 키 → admins.id — NOT NULL
  • status (Field) — enum
  • created_at (Field2) — DateTime
  • updated_at (Field3) — DateTime

roles (동아리-사용자 역할)

  • club_id (Key3) — varchar — 외래 키 → clubs.id — NOT NULL
  • admin_id (Key) — varchar — 외래 키 → admins.id — NOT NULL
  • role (Field) — enum
  • created_at (Field2) — DateTime
  • updated_at (Field3) — DateTime

steps (지원전형)

  • id (Key) — varchar — 기본 키 — NOT NULL
  • type (Field) — enum
  • order (Field2) — int
  • created_at (Field3) — DateTime
  • updated_at (Field4) — DateTime
  • recruitment_id (Key2) — varchar — 외래 키 → announcement.id — NOT NULL