Torneo Data Model Overview
The Torneo data model represents the organizational structure and operational data of a sports tournament ecosystem. Core entities include competitions, teams, squads, matches, venues, host cities, and attractions, each with defined attributes and relationships.
Competitions
Competitions serve as the top-level entity defining a tournament or league. Attributes typically include competition name, season, format, start date, end date, and governing body. A competition is associated with multiple teams and schedules multiple matches.
Teams
Teams represent participating organizations or clubs within a competition. Common attributes include team name, logo, country or region, and establishment details. Each team is registered to one or more competitions and maintains one or more squads over time.
Squads
Squads define the active roster of players representing a team during a specific competition or season. Attributes include squad name, season, and status. A squad belongs to a single team and is linked to matches through participation.
Matches
Matches represent individual competitive events between teams or squads. Key attributes include match date, start time, status, score, and round or stage. Each match is associated with one competition, involves participating teams or squads, and is hosted at a specific venue.
Venues
Venues define the physical locations where matches are played. Attributes include venue name, capacity, surface type, and address. A venue hosts multiple matches and is located within a host city.
Host Cities
Host cities represent the geographic locations supporting tournament activities. Attributes include city name, country, and region. A host city contains one or more venues and provides access to local attractions.
Attractions
Attractions represent points of interest associated with host cities, enhancing the tournament experience. Attributes include attraction name, category, description, and location. Attractions are linked to host cities and may be promoted in relation to competitions and matches.
Entity Relationships Summary
- Competitions include multiple teams and matches.
- Teams manage squads and participate in competitions.
- Squads represent teams in specific competitions or seasons.
- Matches connect competitions, teams or squads, and venues.
- Venues are located in host cities and host matches.
- Host cities contain venues and attractions.
- Attractions are associated with host cities.Describes the data model of Torneoz
