neighborhood boxing match

Tables (4)

Boxing_Match (복싱 매칭)

  • match_id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → User.user_id — NOT NULL
  • 제목 (title) — varchar(255)
  • 날짜 (date) — date
  • 장소 (region) — enum('SEOUL', 'DAEGU', 'BUSAN', 'GWANGFU', 'DAEJEON', 'GYEONGGI', 'GANGWON', 'JEJU')
  • 설명 (description) — text
  • 성별조건 (gendercondition) — enum( 'MALE_ONLY', 'FEMALE_ONLY', 'ANY')
  • 실력 (SkillLevelCondition) — enum('BEGINNER', 'INTERMEDIATE', 'ADVANCED')
  • 매칭 (matchstatus) — enum('OPEN', 'WAITING', 'CLOSED', 'CANCELED')

MatchRequest (매칭 응답)

  • request_id — bigint — Primary key — NOT NULL
  • match_id — bigint — Foreign key → Boxing_Match.match_id — NOT NULL
  • user_id — bigint — Foreign key → Boxing_Match.user_id — NOT NULL
  • 신청 상태 (status) — enum('PENDING', 'ACCEPTED', 'CANCELED')

Review (리뷰)

  • review_id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → User.user_id — NOT NULL
  • match_id — bigint — Foreign key → Boxing_Match.match_id — NOT NULL
  • 평점 (rating) — int
  • 리뷰 내용 (comment) — text

User (유저)

  • user_id — bigint — Primary key — NOT NULL
  • 이름 (username) — varchar(255)
  • 이메일 (email) — varchar(255)
  • 비밀번호 (password) — varchar(255)
  • 성별 (gender) — enum('male', 'female')
  • 지역 (region) — enum('SEOUL', 'DAEGU', 'BUSAN', 'GWANGFU', 'DAEJEON', 'GYEONGGI', 'GANGWON', 'JEJU')
  • 실력 (SkillLevelCondition) — enum('BEGINNER', 'INTERMEDIATE', 'ADVANCED')