footballproject
Tables (3)
Comment (3)
- commentId (Key) — bigint — Primary key — NOT NULL
- title (Field) — varchar(255)
- body (Field2) — varchar(255)
- username (Field3) — varchar(255)
- path (Field4) — varchar(255)
- depth (Field5) — bigint
- userId (user) — bigint — Foreign key → User.userId — NOT NULL
- gameId (game) — bigint — Foreign key → Game.gameId — NOT NULL
Game (2)
- gameId (game) — bigint — Primary key — NOT NULL
- teamA (Field2) — varchar(255)
- teamB (Field) — varchar(255)
- scoreA (Field3) — bigint
- scoreB (Field4) — bigint
- imageA (Field5) — varchar(255)
- imageB (Field6) — varchar(255)
User (1)
- userId (user) — bigint — Primary key — NOT NULL
- username (Field) — varchar(255)
- password (Field2) — varchar(255)