basketgyo

Tables (8)

Untitled (cash_histories)

  • Key (id) — int — Primary key — NOT NULL
  • Field (uid) — binary
  • ID (user_id) — int — Foreign key → users.ID — NOT NULL
  • Field2 (type) — enum — increase/decrease
  • Field3 (amount) — int — 충전/감소량
  • Field (summary) — varchar(100) — 증가 감소에 대한 요약
  • Field (created_at) — date

Untitled (grounds)

  • Key (id) — int — Primary key — NOT NULL
  • Field (uid) — binary
  • Field2 (name) — varchar(100)
  • Field (image_urls) — _varchar(100)
  • Field3 (address) — varchar(100)
  • Field (memo) — varchar(100)
  • Field (intro) — varchar(200) — 간단하게 오는 법 등을 기입
  • Field (size) — varchar(100) — `${height}x${width}`
  • Field (is_parking_free) — boolean
  • Field (has_shower_booth) — boolean
  • Field (created_at) — date
  • Field (updated_at) — date

Untitled (match_likes)

  • Key (id) — int — Primary key — NOT NULL
  • ID (user_id) — int — Foreign key → users.ID — NOT NULL
  • Key (match_id) — int — Foreign key → match_histories.Key — NOT NULL
  • Field (is_deleted) — boolean
  • Field2 (created_at) — date

Untitled (apply_history)

  • Key (id) — int — Primary key — NOT NULL
  • Key (match_id) — int — Foreign key → match_histories.Key — NOT NULL
  • ID (user_id) — int — Foreign key → users.ID — NOT NULL
  • Field2 (status) — enum — active|cancel|
  • Field3 (created_at) — date
  • Field (updated_at) — date

Untitled (levels)

  • Key (id) — int — Primary key — NOT NULL
  • ID (manager_id) — int — Foreign key → users.ID — NOT NULL
  • ID (user_id) — int — Foreign key → users.ID — NOT NULL
  • Key (match_id) — int — Foreign key → match_histories.Key — NOT NULL
  • Field (level) — int
  • Field (match_date) — date
  • Field (created_at) — date

Untitled3 (refund_histories)

  • Key (id) — int — Primary key — NOT NULL
  • Key (match_id) — int — Foreign key → match_histories.Key — NOT NULL
  • Field (start) — boolean
  • Field2 (result) — boolean
  • Field (created_at) — date
  • Field2 (updated_at) — date

match_histories (matches)

  • Key (id) — int — Primary key — NOT NULL
  • Field (uid) — binary
  • ID (manager_id) — int — Foreign key → users.ID — NOT NULL
  • Key (ground_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field2 (type) — enum — 3team|starter|beginner ...
  • Field (status) — enum — play|refund|finished
  • Field (name) — varchar(100)
  • Field (fee) — int — 비용
  • Field (play_time) — int — 시간 단위로 저장
  • Field (min_player) — int
  • Field3 (max_player) — int
  • Field (start_date) — date — 출력 조건으로 사용될 예정
  • Field (created_at) — date
  • Field2 (updated_at) — date

users

  • ID (id) — int — Primary key — NOT NULL
  • UID (uid) — binary
  • Field (is_deleted) — boolean
  • Field (email) — varchar(50)
  • Field (password) — varchar(200)
  • Field2 (salt) — varchar(100)
  • Field (name) — varchar(50)
  • Field (description) — varchar(100)
  • Field (gender) — enum
  • Field (style) — enum — 플레이 스타일
  • Field (strength) — enum — 강점
  • Field (phone_number) — varchar(10) — 전화번호
  • Field (created_at) — date
  • Field (updated_at) — date