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