soccer
Tables (8)
Location (location)
- Key (id) — int — Primary key — NOT NULL
- latitude — double
- longitude — double
- name — varchar(100)
- address — text
- detail — varchar(100)
- createdAt (created_at) — Date
- updatedAt (updated_at) — Date
Match (match)
- Key (id) — int — Primary key — NOT NULL
- type — enum(SOCCKER, FOOTSAL5, FOOTSAL6)
- description — text
- startAt (start_at) — Date
- duration — int
- fee — int
- phone — varchar(13)
- totalQuota (total_quota) — int
- status — enum(WAITING, CONFIRMED, CANCERED)
- createdAt (created_at) — Date
- updatedAt (updated_at) — Date
- writerId (writer_id) — int — Foreign key → User.Key — NOT NULL
- homeTeam (home_team) — int — Foreign key → Team.Key — NOT NULL
- locationId (location_id) — int — Foreign key → Location.Key — NOT NULL
MatchTeamApplication (match_team_application)
- Key (id) — Primary key — NOT NULL
- quota — int
- status — enum(CONFIRMED, WAITING, DENIED)
- createdAt (created_at) — Date
- updatedAt (updated_at) — Date
- matchId (match_id) — int — Foreign key → Match.Key — NOT NULL
- TeamId (team_id) — int — Foreign key → Team.Key — NOT NULL
MatchUserApplication (match_user_application)
- Key (id) — Primary key — NOT NULL
- quota — int
- status — enum(CONFIRMED, WAITING, DENIED)
- createdAt (created_at) — Date
- updatedAt (updated_at) — Date
- matchId (match_id) — int — Foreign key → Match.Key — NOT NULL
- userId (user_id) — int — Foreign key → User.Key — NOT NULL
NotifiableUserMatch (notifiable_user_match)
- Key (id) — Primary key — NOT NULL
- matchId (match_id) — int
- userId (user_id) — int
Review (review)
- Key (id) — Primary key — NOT NULL
- matchId (match_id) — int
- reviewer — int
- reviewee — int
- score — int
Team (team)
- Key (id) — Primary key — NOT NULL
- name — varchar(30)
- description — text
- age — int
- level — enum(high, medium, low)
- leader — varchar(13)
- phone — varchar(13)
- createdAt (created_at) — Date
- updatedAt (updated_at) — Date
User (유저)
- Key (id) — int — Primary key — NOT NULL
- Name (name) — varchar(20)
- age — int
- email
- socialType (social_type) — enum(KAKAO)
- phone — varchar(13)
- pushToken (push_token)
- level — enum(high, medium, low)
- description — text
- picture — String
- createdAt (created_at)
- updatedAt (updated_at)
- teamId (team_id) — int — Foreign key → Team.Key — NOT NULL