1

Tables (6)

Tip (Untitled)

  • id (Key) — Primary key — NOT NULL
  • title (Field)
  • content (Field2)
  • nickname (Field3)
  • likeCount (Field4)
  • user_id (Field5)
  • id (Key2) — Foreign key → User.id — NOT NULL

User (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • username (Field2)
  • password (Field3)
  • nickname (Field4)

admin

  • id (Key) — varchar(50) — Primary key — NOT NULL
  • password (Field) — varchar(255)
  • site_nickname (Field2) — varchar(100)

match_history

  • id (Key) — varchar(255) — Primary key — NOT NULL
  • user_id (Field) — varchar(255)
  • team1 (Field2) — text
  • team2 (Field3) — text
  • created_at (Field4) — timestamp
  • id (Key2) — varchar(255) — Foreign key → users.id — NOT NULL

match_history2

  • id (Key) — varchar(255) — Primary key — NOT NULL
  • user_id (Field) — varchar(255)
  • team (Field2) — int
  • player_name (Field3) — varchar(255)
  • player_rank (Field4) — timestamp
  • Field5 — timestamp
  • id (Key2) — varchar(255) — Foreign key → users.id — NOT NULL

users

  • id (Key) — varchar(255) — Primary key — NOT NULL
  • password (Field) — varchar(255)
  • lol_nickname_tag (Field2) — varchar(255)
  • site_nickname (Field3) — varchar(255)