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