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