ShowMeTheBodyV1

Tables (7)

contests (대회)

  • pk (contest_id) — NOTNULL — Primary key — NOT NULL
  • 호스트 닉네임 (created_by) — NOTNULL
  • 대회제목 (title) — NOTNULL
  • 대회설명 (explanation) — NOTNULL
  • 대회룰 (rule) — NOTNULL
  • 부상 (prize) — NOTNULL
  • 본선최대인원 (maximum_number_of_finallist) — NOTNULL
  • 참가조건 (requirement) — NOTNULL
  • 시작날짜 (start_date) — NOTNULL
  • 마감날짜 (end_date) — NOTNULL
  • 포징에대한평가 (explanation_of_posing) — NOTNULL
  • 생성날짜 (created_date) — NOTNULL
  • 업데이트날짜 (updated_date) — NOTNULL

evaluations (평가)

  • pk (evaluation_id) — NOTNULL — Primary key — NOT NULL
  • 콜아웃 (call_out) — NOTNULL
  • 등수 (rank) — NOTNULL
  • 생성날짜 (created_date) — NOTNULL
  • 업데이트날짜 (updated_date)

participants (참가자)

  • pk (participant_id) — NOTNULL — Primary key — NOT NULL
  • 유저ID (user_id) — NOTNULL — Foreign key → users.pk — NOT NULL
  • 대회ID (contest_id) — NOTNULL — Foreign key → contests.pk — NOT NULL
  • 평가ID (evaluation_id) — NOTNULL — Foreign key → evaluations.pk — NOT NULL
  • 개최자/참가자 (host_or_guest) — NOTNULL
  • 참가 승인 여부 (status) — NOTNULL
  • 한줄 소개 (explanation)
  • 키 (height)
  • 몸무게 (weight)
  • 골격근량 (skeletal _muscle _mass)
  • 체지방률 (body_fat_percentage)
  • 생성날짜 (created_date) — NOTNULL
  • 업데이트날짜 (updated_date)

photos (사진)

  • pk (photo_id) — NOTNULL — Primary key — NOT NULL
  • 참가자ID (participant_id) — NOTNULL — Foreign key → participants.pk — NOT NULL
  • 대회ID (contest_id) — NOTNULL — Foreign key → contests.pk — NOT NULL
  • 생성날짜 (created_date) — NOTNULL
  • 업데이트날짜 (updated_date)

roles (역할)

  • pk (role_id) — NOTNULL — Primary key — NOT NULL
  • 역할명 (name) — NOTNULL

user_roles (유저-역할)

  • 유저ID (user_id) — NOTNULL — Foreign key → users.pk — NOT NULL
  • 역할ID (role_id) — NOTNULL — Foreign key → roles.pk — NOT NULL

users (유저)

  • pk (user_id) — NOTNULL — Primary key — NOT NULL
  • 이메일 (email) — NOTNULL
  • 비밀번호 (password) — NOTNULL
  • 운동경력 (exercise_experience) — NOTNULL
  • 자기소개 (self_introduction)
  • 식단여부 (diet_status) — NOTNULL
  • 닉네임 (nickname) — NOTNULL
  • 이름 (name)
  • 관심운동 (interest)
  • 상태 (status)
  • 오운완 (complete_exercise_today)
  • 대회참가이력 (participation_history)
  • 개인sns (personal_sns_link)
  • 생성날짜 (created_date) — NOTNULL
  • 업데이트날짜 (updated_date)