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