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')