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)