fms4

Tables (9)

AdminActivityLog

  • LogID — INT — Primary key — NOT NULL
  • AdminID — INT
  • ActivityType — VARCHAR(255)
  • TargetID — INT
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • deletedAt — TIMESTAMP

Location

  • LocationID — INT — Primary key — NOT NULL
  • Name — VARCHAR(255)
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • deletedAt — TIMESTAMP

Match

  • MatchID — INT — Primary key — NOT NULL
  • Date — DATE
  • Time — TIME
  • LocationID — INT
  • HomeTeamID — INT
  • AwayTeamID — INT
  • Result — VARCHAR(50)
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • deletedAt — TIMESTAMP

MatchEvent

  • EventID — INT — Primary key — NOT NULL
  • MatchID — INT
  • EventType — VARCHAR(50)
  • PlayerID — INT
  • EventTime — TIME
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • deletedAt — TIMESTAMP

Player

  • PlayerID — INT — Primary key — NOT NULL
  • Name — VARCHAR(255) — NOT NULL
  • Position — VARCHAR(50)
  • TeamID — INT
  • ImageURL — VARCHAR(255)
  • SkillLevel — INT
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • deletedAt — TIMESTAMP

PlayerStatistics

  • StatID — INT — Primary key — NOT NULL
  • PlayerID — INT
  • MatchID — INT
  • Goals — INT
  • Assists — INT
  • YellowCards — INT
  • RedCards — INT
  • Substitutions — INT
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • deletedAt — TIMESTAMP

Team

  • TeamID — INT — Primary key — NOT NULL
  • Name — VARCHAR(255) — NOT NULL
  • Description — TEXT
  • LogoURL — VARCHAR(255)
  • LocationID — INT
  • CreatorID — INT
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • deletedAt — TIMESTAMP

TeamNotification

  • NotificationID — INT — Primary key — NOT NULL
  • TeamID — INT
  • Content — TEXT
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • deletedAt — TIMESTAMP

User

  • UserID — INT — Primary key — NOT NULL
  • Name — VARCHAR(255) — NOT NULL
  • Age — INT
  • Weight — DECIMAL(5, 2)
  • Height — DECIMAL(5, 2)
  • PreferredPosition — VARCHAR(50)
  • Hometown — VARCHAR(255)
  • Role — ENUM('user', 'admin') — NOT NULL
  • SocialLoginToken — VARCHAR(255)
  • createdAt — TIMESTAMP
  • updatedAt — TIMESTAMP
  • deletedAt — TIMESTAMP