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)