ryc

Tables (15)

Clubs (동아리)

  • id (Key) — varchar — Primary key — NOT NULL
  • name (Field) — varchar
  • category (Field2) — enum
  • description (Field3) — varchar
  • thumbnail_img (Field4) — varchar
  • img (Field5) — varchar

application (지원)

  • id (Key) — varchar — Primary key — NOT NULL
  • recruitment_id (Key2) — varchar — Foreign key → recruitment.id — NOT NULL
  • applicant_email (Field) — varchar
  • applicant_password (Field2) — varchar
  • step_id (Key32) — varchar — Foreign key → recruitment_step.id — NOT NULL

application_form (지원서 형식)

  • id (Key) — varchar — Primary key — NOT NULL
  • recruitment_id (Key2) — varchar — Foreign key → recruitment.id — NOT NULL
  • form (Field) — JSON
  • Field2

application_response (Untitled)

  • id (Key3) — Primary key — NOT NULL
  • application_id (Key) — varchar — Foreign key → application.id — NOT NULL
  • recruitment_id (Key2) — varchar — Foreign key → application.recruitment_id — NOT NULL
  • response (Field) — JSON

comment (코멘트)

  • Key2 — Primary key — NOT NULL
  • application_id (Key) — varchar — Foreign key → evaluation.application_id — NOT NULL
  • step_id (Key3) — varchar — Foreign key → evaluation.step_id — NOT NULL
  • comment (Field) — varchar

evaluation (평가)

  • application_id (Key) — varchar — Foreign key → application.id — NOT NULL
  • step_id (Key3) — varchar — Foreign key → recruitment_step.id — NOT NULL
  • score (Field)
  • comment (Field2)

interview (면접 테이블)

  • id (Key) — varchar — Primary key — NOT NULL
  • recruitment_id (Key2) — varchar — Foreign key → recruitment.id — NOT NULL
  • start_time (Field)
  • end_time (Field2)

interview_application (면접-지원 매핑)

  • interview_id (Key) — varchar — Foreign key → interview.id — NOT NULL
  • application_id (Key3) — varchar — Foreign key → application.id — NOT NULL

member (동아리원)

  • club_id (Key) — varchar — Foreign key → Clubs.id — NOT NULL
  • user_id (Key2) — varchar — Foreign key → user.id — NOT NULL
  • role (Field) — enum

member_request (동아리 가입 요청)

  • id (Key3) — Primary key — NOT NULL
  • club_id (Key) — varchar — Foreign key → Clubs.id — NOT NULL
  • user_id (Key2) — varchar — Foreign key → user.id — NOT NULL
  • role (Field) — enum
  • status (Field2) — enum

recruitment (모집공고)

  • id (Key2) — varchar — Primary key — NOT NULL
  • club_id (Key) — varchar — Foreign key → Clubs.id — NOT NULL
  • name (Field) — varchar
  • description (Field2) — JSON
  • thumbnail_img (Field3) — varchar
  • due_day (Field4) — DateTime
  • status (Field5) — enum
  • activity_duration (Field6) — varchar

recruitment_img (모집공고 이미지)

  • recruitment_id (Key2) — varchar — Foreign key → recruitment.id — NOT NULL
  • img_url (Field) — varchar

recruitment_step (공고 스텝)

  • id (Key3) — varchar — Primary key — NOT NULL
  • recruitment_id (Key2) — varchar — Foreign key → recruitment.id — NOT NULL
  • step_type (Field) — enum

tag (동아리 소분류)

  • id (Key2) — varchar — Primary key — NOT NULL
  • club_id (Key) — varchar — Foreign key → Clubs.id — NOT NULL
  • name (Field) — varchar

user (유저)

  • id (Key) — varchar — Primary key — NOT NULL
  • email (Field) — varchar
  • password (Field2) — varchar
  • Field3