showMeTheBody

Tables (4)

competition (대회)

  • pk (competition_id) — Long — Primary key — NOT NULL
  • 대회명 (competition_name) — varchar(20)
  • 시작일 (start_date) — datetime
  • 종료일 (due_date) — datetime
  • 가이드사진 (pose_guide_photo) — varchar(100)
  • 요구사항 (requirements) — varchar(100)
  • 공개/비공개 (public_or_private) — boolean
  • 비공개_비밀번호 (password) — Long
  • 부상설정 (prize_setting) — varchar(100)

evaluation (비교심사)

  • pk (evaluation_id) — Long — Primary key — NOT NULL
  • 평가자ID (participant_id) — Long — Foreign key → participant.pk — NOT NULL
  • 대회ID (competition_id) — Long — Foreign key → competition.pk — NOT NULL
  • 평가자의점수 (score) — Long

member (사용자)

  • pk (member_id) — Long — Primary key — NOT NULL
  • 이메일 (email) — varchar(50)
  • 비밀번호 (password) — varchar(20)
  • 별명 (nickname) — varchar(20)
  • 경력 (exercise_experience) — varchar(20)
  • 자기소개 (self_introduction) — varchar(100)
  • 지역 (region) — varchar(50)
  • 식단 (diet) — varchar(100)

participant (참가자)

  • pk (participant_id) — Long — Primary key — NOT NULL
  • 참가자ID (member_id) — Long — Foreign key → member.pk — NOT NULL
  • 대회ID (contest_id) — Long — Foreign key → competition.pk — NOT NULL
  • 포즈사진 (pose_photo) — varchar(100)
  • 받은표수 (number_of_votes_received) — Long