MatchOn

Tables (12)

Basketball (basketball)

  • pk (basketball_pk) — int — Primary key — NOT NULL
  • location — text
  • Field

Bowling (bowling)

  • pk (bowling_pk) — int — Primary key — NOT NULL
  • location — text
  • Field

Locations (Untitled3)

  • Key — Primary key — NOT NULL
  • pk (id) — int — Foreign key → Match.pk — NOT NULL
  • location — char
  • x_loc — float
  • y_loc — float
  • Field

Match (Untitled)

  • pk (id) — int — Primary key — NOT NULL
  • sports — char(150)
  • start_time — datetime
  • end_time — datetime
  • Field

Pool (pool)

  • pk (pool_pk) — int — Primary key — NOT NULL
  • location — text
  • Field

Score (Untitled4)

  • Key — int — Primary key — NOT NULL
  • pk (username) — char — Foreign key → User.pk — NOT NULL
  • bowling_win — int
  • bowling_lose — int
  • bowling_average — int
  • pool_win — int
  • pool_lose — int
  • pool_average — int
  • soccer_win — int
  • soccer_lose — int
  • basketball_win — int
  • basketball_lose — int
  • tennis_win — int
  • tennis_lose — int

Soccer (soccer)

  • pk (soccer_pk) — int — Primary key — NOT NULL
  • location — text
  • Field

Team (Untitled6)

  • Key — Primary key — NOT NULL
  • side — bool

Team-Match (Untitled2)

  • Key — Primary key — NOT NULL
  • match_pk (id) — int — Foreign key → Match.pk — NOT NULL
  • Key (Key2) — Foreign key → Team.Key — NOT NULL

Tennis (tennis)

  • pk (tennis_pk) — int — Primary key — NOT NULL
  • location — text
  • Field

User (user)

  • pk (username) — char — Primary key — NOT NULL
  • 닉네임 (nickname) — char(150)
  • 소셜아이디 (social_id) — int
  • 플랫폼 (platform) — char(150)
  • Field (password) — char(150)
  • Field (is_staff) — bool
  • Field (is_active) — bool
  • Field (is_superuser) — bool
  • Field (last_login) — datetime
  • Field (date_joined) — datetime

User-Team (Untitled5)

  • pk (username) — char — Foreign key → User.pk — NOT NULL
  • Key — Foreign key → Team.Key — NOT NULL