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)