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