lol watcher

Tables (7)

lolwatcher (user_authorization)

  • user_id (Key2) — big_integer — Foreign key → lolwatcher.user_id — NOT NULL
  • account (Field) — varchar
  • password (Field2) — varchar

lolwatcher (user_info)

  • user_id (Key) — big_integer — Primary key — NOT NULL
  • account (Field) — varchar(14)
  • password (Field2) — varchar(20)
  • riot_account_count (Field3) — int

lolwatcher (riot_Account)

  • riot_user_key (Key) — big_integer — Primary key — NOT NULL
  • user_id (Key2) — big_integer — Foreign key → lolwatcher.user_id — NOT NULL
  • riot_user_puid (Field2) — varchar(80)

lolwatcher (analyze_data_key)

  • result_id (Key) — big_integer — Primary key — NOT NULL
  • riot_user_key (Key3) — big_integer — Foreign key → lolwatcher.riot_user_key — NOT NULL
  • user_id (Key2) — big_integer — Foreign key → lolwatcher.user_id — NOT NULL
  • riot_user_key (Field) — big_integer
  • match_id (Field4) — varchar(80)
  • analyze_data_key (Field2) — varchar(100)
  • user_game_score (Field3) — int

lolwatcher (Untitled2)

    lolwatcher (image_route)

    • image_id (Key) — big_integer — Primary key — NOT NULL
    • image_name (Field) — varchar(20)
    • image_type (Field2) — varchar(20)
    • image_route (Field3) — varchar(50)

    lolwatcher (match_id)

    • match_id (Key) — big_integer — Primary key — NOT NULL
    • match_puid (Field)