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