LeagueOfLegend

Tables (7)

Chat (Untitled5)

  • chat_id (Key) — NOT NULL — Primary key — NOT NULL
  • send_user_id (Key2) — NOT NULL — Foreign key → User.user_id — NOT NULL
  • recv_user_id (Key3) — NOT NULL — Foreign key → User.user_id — NOT NULL
  • message (Field) — NOT NULL
  • created (Field2) — NOT NULL

FriendRequest (Untitled7)

  • request_id (Key3) — NOT NULL — Primary key — NOT NULL
  • requester_user_id (Key) — NOT NULL — Foreign key → User.user_id — NOT NULL
  • requested_user_id (Key2) — NOT NULL — Foreign key → User.user_id — NOT NULL

Friends (Untitled4)

  • friends_id (Key3) — NOT NULL — Primary key — NOT NULL
  • user_id (Key) — NOT NULL — Foreign key → User.user_id — NOT NULL
  • friend_id (Key2) — NOT NULL — Foreign key → User.user_id — NOT NULL

LeagueOfLegendProfile (Untitled2)

  • lol_id (Key) — NOT NULL — Primary key — NOT NULL
  • current_uid (Field) — NOT NULL
  • previous_uid (Field3) — NOT NULL
  • puuid (Field2) — NOT NULL

Report (Untitled6)

  • report_id (Key) — NOT NULL — Primary key — NOT NULL
  • detail (Field) — NOT NULL
  • reporter_user_id (Key2) — NOT NULL — Foreign key → User.user_id — NOT NULL
  • reported_user_id (Key3) — NOT NULL — Foreign key → User.user_id — NOT NULL
  • created (Field2) — NOT NULL

User (Untitled)

  • user_id (Key) — NOT NULL — Primary key — NOT NULL
  • champion_top3_id (Key3) — NOT NULL — Foreign key → UserCampionTop3.champion_top3_id — NOT NULL
  • lol_id (Key2) — NOT NULL — Foreign key → LeagueOfLegendProfile.lol_id — NOT NULL
  • discord_id (Field) — NOT NULL
  • description (Field2)
  • popular (Field3) — NOT NULL
  • avator_url (Field4)
  • gender (Field5) — NOT NULL

UserCampionTop3 (Untitled3)

  • champion_top3_id (Key) — NOT NULL — Primary key — NOT NULL
  • champion_id (Field) — NOT NULL
  • total (Field2) — NOT NULL
  • wins (Field3) — NOT NULL
  • losses (Field4) — NOT NULL