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