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