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