LOL
Tables (8)
Untitled (Records)
- Key (id) — BIGINT — Primary key — NOT NULL
- Field (champ_name) — varchar
- Field2 (champ_level) — BIGINT
- Field3 (kills) — BIGINT
- Field (deaths) — BIGINT
- Field (assists) — BIGINT
- Field (win) — BOOL
- Key (summoner_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
Untitled (Post)
- Key (id) — BIGINT — Primary key — NOT NULL
- Field (title) — varchar
- Field (content) — varchar
- Field (created_date) — DATETIME
- Field (modified_date) — DATETIME
- Field (like) — BIGINT
- Field2 (dislike) — BIGINT
- Key (user_id) — BIGINT — Foreign key → User.Key — NOT NULL
Untitled (ChatMessage)
- Key (id) — BIGINT — Primary key — NOT NULL
- Field (content) — varchar
- Field (send_date) — DATETIME
- Key (chatroom_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Key (user_id) — BIGINT — Foreign key → User.Key — NOT NULL
Untitled (MatchingResult)
- Key (id) — BIGINT — Primary key — NOT NULL
- Field (matching_date) — DATETIME
- Key (user_id) — BIGINT — Foreign key → User.Key — NOT NULL
- Key (user_id2) — BIGINT — Foreign key → User.Key — NOT NULL
Untitled (ChatRoom)
- Key (id) — BIGINT — Primary key — NOT NULL
- Field (title) — varchar
- Key (matching_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
- Key (user_id) — BIGINT — Foreign key → User.Key — NOT NULL
- Key (user_id2) — BIGINT — Foreign key → User.Key — NOT NULL
Untitled (SummonerInfo)
- Key (id) — BIGINT — Primary key — NOT NULL
- Field (summoner_nickname) — varchar
- Field (solo_tier) — varchar
- Field (team_tier) — varchar
- Field (solo_wins) — BIGINT
- Field (solo_losses) — BIGINT
- Field (team_wins) — BIGINT
- Field (team_losses) — BIGINT
- Field (summoner_level) — BIGINT
Untitled2 (Comment)
- Key (id) — BIGINT — Primary key — NOT NULL
- Field (content) — varchar
- Field (created_date) — DATETIIME
- Field (modified_date) — DATETIME
- Field (like) — BIGINT
- Field (dislike) — BIGINT
- Key (user_id) — BIGINT — Foreign key → User.Key — NOT NULL
- Key (post_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
User
- Key (id) — BIGINT — Primary key — NOT NULL
- Field (user_id) — varchar
- Field2 (password) — varchar
- Field3 (role) — varchar