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