ClimbingWork
테이블 (9)
Copy Of 파일 (files)
- fileId (file_id) — bigint(20) — 기본 키 — NOT NULL
- imageUrl (single_url) — varchar(200)
- Field (multi_url) — varchar(200)
Untitled (user_authority)
- userId (member_id) — bigint(20) — 외래 키 → 유저.userId — NOT NULL
- Key (authority_name) — varchar(50) — 외래 키 → Untitled.Key — NOT NULL
Untitled (authority)
- Key (authority_name) — varchar(50) — 기본 키 — NOT NULL
경기신청 (reservations)
- applicationId (reservation_id) — bigint(20) — 기본 키 — NOT NULL
- userId (member_id) — bigint(20) — 외래 키 → 유저.userId — NOT NULL
- matchId (match_id) — bigint(20) — 외래 키 → 매치.matchId — NOT NULL
경기장 (stadiums)
- stadiumId (stadium_id) — bigint(20) — 기본 키 — NOT NULL
- name — varchar(50)
- content — longtext
- parking — bit(1)
- rental — bit(1)
- address — varchar(100)
- Field (single_url) — varchar(200)
- Field2 (multi_url) — varchar(200)
- createAt (created_at) — datetime
- Field (updated_at) — datetime
리뷰 (reviews)
- reviewId (review_id) — bigint(20) — 기본 키 — NOT NULL
- userId (member_id) — bigint(20) — 외래 키 → 유저.userId — NOT NULL
- matchId (match_id) — bigint(20) — 외래 키 → 매치.matchId — NOT NULL
- Field (writer) — varchar(30)
- Field2 (score) — int(2)
- content — longtext
- createDate (created_at) — datetime
- updateDate (updated_at) — datetime
매치 (matches)
- matchId (match_id) — bigint(20) — 기본 키 — NOT NULL
- stadiumId (stadium_id) — bigint(20) — 외래 키 → 경기장.stadiumId — NOT NULL
- status — varchar(10)
- gender (match_gender) — varchar(10)
- matchNum (match_num) — int(2)
- applicantNum (applicant_num) — int(10)
- Field (match_day) — int(10)
- content — longtext
- startAt (start_at) — datetime
- Field (end_at) — datetime
- Field (created_at) — datetime
- Field (updated_at) — datetime
유저 (members)
- userId (member_id) — bigint(20) — 기본 키 — NOT NULL
- userName (username) — varchar(50)
- email (password) — varchar(100)
- phoneNum (nickname) — varchar(50)
- gender — varchar(20)
- role (activated) — bit(1)
좋아요 (likes)
- likeId (like_id) — bigint(20) — 기본 키 — NOT NULL
- userId (member_id) — bigint(20) — 외래 키 → 유저.userId — NOT NULL
- stadiumId (stadium_id) — bigint(20) — 외래 키 → 경기장.stadiumId — NOT NULL
- Field (created_at) — datetime
- Field2 (updated_at) — datetime