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