sportify
Tables (9)
MatchRecord
- id — INT
- reservation_id — INT — NOT NULL
- team_a_score — INT
- team_b_score — INT
- status — ENUM('COMPLETED', 'CANCELLED')
Notice
- id — INT
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME
Reservation
- id — INT
- stadium_id — INT — NOT NULL
- user_id — INT — NOT NULL
- date — DATE — NOT NULL
- time_slot — VARCHAR(50) — NOT NULL
- team_id — INT
- status — ENUM('PENDING', 'CONFIRMED', 'CANCELLED')
- payment_amount — FLOAT
- guest_recruitment — BOOLEAN
Review
- id — INT
- reservation_id — INT — NOT NULL
- user_id — INT — NOT NULL
- rating — INT
- comment — TEXT — EX
Stadium
- id — INT
- name — VARCHAR(100) — NOT NULL
- location — VARCHAR(255) — NOT NULL
- capacity — INT — NOT NULL
- time_slots — TEXT — NOT NULL
- price_per_slot — FLOAT
- owner_id — INT
Team
- id — INT
- name — VARCHAR(100) — NOT NULL
- region — VARCHAR(100) — NOT NULL
- activity_time — TEXT — NOT NULL
- skill_level — ENUM('BEGINNER', 'INTERMEDIATE', 'ADVANCED')
- sport_type — ENUM('축구', '풋살', '농구') — NOT NULL
- description — TEXT
- leader_id — INT — NOT NULL
TeamMember
- id — INT
- team_id — INT — NOT NULL
- user_id — INT — NOT NULL
- role — ENUM('LEADER', 'MANAGER', 'MEMBER')
Ticket
- id — INT
- user_id — INT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- status — ENUM('OPEN', 'RESOLVED')
User
- id — INT
- name — VARCHAR(100) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- role — ENUM('ADMIN', 'OWNER', 'MEMBER')
- gender — VARCHAR(10)
- region — VARCHAR(100)
- age_group — VARCHAR(50)
- sports_interest — TEXT
- level — VARCHAR(50)
- cash_balance — FLOAT