fms5

Tables (9)

admin_activity_log

  • log_id — INT — Primary key — NOT NULL
  • admin_id — INT
  • activity_type — VARCHAR(255)
  • target_id — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

location

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(255)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

match

  • id — INT — Primary key — NOT NULL
  • date — DATE
  • time — TIME
  • location_id — INT
  • home_team_id — INT
  • away_team_id — INT
  • result — VARCHAR(50)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

match_event

  • id — INT — Primary key — NOT NULL
  • match_id — INT
  • event_type — VARCHAR(50)
  • player_id — INT
  • event_time — TIME
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

player

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • position — VARCHAR(50)
  • team_id — INT
  • image_url — VARCHAR(255)
  • skill_level — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

player_statistics

  • id — INT — Primary key — NOT NULL
  • player_id — INT
  • match_id — INT
  • goals — INT
  • assists — INT
  • yellow_cards — INT
  • red_cards — INT
  • substitutions — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

team

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • logo_url — VARCHAR(255)
  • location_id — INT
  • creator_id — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

team_notification

  • notification_id — INT — Primary key — NOT NULL
  • team_id — INT
  • content — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

user

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • age — INT
  • weight — DECIMAL(5, 2)
  • height — DECIMAL(5, 2)
  • preferred_position — VARCHAR(50)
  • hometown — VARCHAR(255)
  • role — ENUM('user', 'admin') — NOT NULL
  • social_login_token — VARCHAR(255)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP