ClubApplication
테이블 (12)
동아리 (CLUB)
- Key (club_id) — BIGINT — 기본 키 — NOT NULL
- Field (name) — VARCHAR(100) — NOT NULL
- Field2 (short_desc) — VARCHAR(255) — NOT NULL
- Field3 (description) — TEXT
- Field4 (activities) — TEXT
- Field (vision) — TEXT
- Field (type) — ENUM('major','general') — NOT NULL
- Field (department) — VARCHAR(100) — NOT NULL
- Field (category) — VARCHAR(100) — NOT NULL
- Field (status) — ENUM('pending','approved') — NOT NULL
- Field (recruit_status) — ENUM('open','closed') — NOT NULL
- Field (recruitment_notice) — TEXT
- Field (recruitment_start_date) — DATE
- Field (recruitment_end_date) — DATE
- Key (user_id) — BIGINT — 외래 키 → 유저.Key — NOT NULL
동아리 공지 (ClubNotices)
- Key (notice_id) — BIGINT — 기본 키 — NOT NULL
- Field (content) — TEXT — NOT NULL
- Field2 (created_at) — TIMESTAMP — NOT NULL
- Key (club_id) — BIGINT — 외래 키 → 동아리.Key — NOT NULL
동아리 이미지 (ClubImages)
- Key (image_id) — BIGINT — 기본 키 — NOT NULL
- Field (image_url) — VARCHAR(255) — NOT NULL
- Field3 (uploaded_at) — TIMESTAMP — NOT NULL
- Key (club_id) — BIGINT — 외래 키 → 동아리.Key — NOT NULL
면접 신청 현황 (InterviewApplications)
- Key (apply_id) — BIGINT — 기본 키 — NOT NULL
- Field (applied_at) — TIMESTAMP
- Key (user_id) — BIGINT — 외래 키 → 유저.Key — NOT NULL
- Key (interview_id) — BIGINT — 외래 키 → 면접 회차.Key — NOT NULL
면접 회차 (Interviews)
- Key (interview_id) — BIGINT — 기본 키 — NOT NULL
- Field (date) — date — NOT NULL
- Field2 (start_time) — TIME — NOT NULL
- Field3 (end_time) — TIME — NOT NULL
- Field4 (duration) — INT — NOT NULL
- Field (max_applicants) — INT — NOT NULL
- Field
- Key (club_id) — BIGINT — 외래 키 → 동아리.Key — NOT NULL
알림설정 (Notifications)
- Key (notification_id) — BIGINT — 기본 키 — NOT NULL
- Field (type) — ENUM('wishlist','deadline','result') — NOT NULL
- Key (user_id) — BIGINT — 외래 키 → 유저.Key — NOT NULL
- Key (club_id) — BIGINT — 외래 키 → 동아리.Key — NOT NULL
유저 (user)
- Key (user_id) — BIGINT — 기본 키 — NOT NULL
- Field (student_id) — VARCHAR(20) — NOT NULL
- Field2 (email) — VARCHAR(100),UNIQUE — NOT NULL
- Field3 (password) — VARCHAR(100) — NOT NULL
- Field4 (nickname) — VARCHAR(50) — NOT NULL
- Field (role) — ENUM — NOT NULL
- Field (phone) — VARCHAR(20)
- Field (created_at) — DEFAULT CURRENT_TIMESTAMP
지원서 (Applications)
- Key (application_id) — BIGINT — 기본 키 — NOT NULL
- Field (result) — ENUM('pending','passed','failed') — NOT NULL
- Field2 (confirm_status) — ENUM('none','confirmed','declined') — NOT NULL
- Field3 (message) — TEXT
- Field4 (created_at) — TIMESTAMP — NOT NULL
- Field
- Key (user_id) — BIGINT — 외래 키 → 유저.Key — NOT NULL
- Key (club_id) — BIGINT — 외래 키 → 동아리.Key — NOT NULL
지원서 답변 (ApplicationAnswers)
- Key (answer_id) — BIGINT — 기본 키 — NOT NULL
- Field (answer) — TEXT — NOT NULL
- Key (application_id) — BIGINT — 외래 키 → 지원서.Key — NOT NULL
- Key (question_id) — BIGINT — 외래 키 → 질문.Key — NOT NULL
지원자 보유 기술 (UserSkill)
- Key (skill_id) — BIGINT — 기본 키 — NOT NULL
- Field (skill_name) — VARCHAR(100) — NOT NULL
- Field2 (proficiency) — ENUM('Beginner','Intermediate','Advanced','Expert') — NOT NULL
- Field (created_at) — DEFAULT CURRENT_TIMESTAMP — NOT NULL
- Key (user_id) — BIGINT — 외래 키 → 유저.Key — NOT NULL
질문 (Questions)
- Key (question_id) — BIGINT — 기본 키 — NOT NULL
- Field (answer) — TEXT — NOT NULL
- Key (club_id) — BIGINT — 외래 키 → 동아리.Key — NOT NULL
찜목록 (Wishlist)
- Key (wishlist_id) — BIGINT — 기본 키 — NOT NULL
- Field (created_at) — TIMESTAMP — NOT NULL
- Key (user_id) — BIGINT — 외래 키 → 유저.Key — NOT NULL
- Key (club_id) — BIGINT — 외래 키 → 동아리.Key — NOT NULL