Tables Overview - non-sono-bello-ma-patcho/BD_LAB GitHub Wiki

In this page are shown the main feature of each table that composes the database, you can have further information by clicking on table's name.

Buildings

The platform will keep track of:

  • building's name;
  • building's address;
  • an email address;
  • building's coordinates(latitude, longitude);

Categories

The platform needs to manage sports event belonging to many categories, such as soccer, tennis, volley and basket. For each category will be stored the following information:

  • regulation (text field);
  • number of players allowed (numeric);
  • explanatory photo;

Evaluations

Each user, both basic and premium, can evaluate the performance of each player who participated in the same event. Evaluation includes date of input, a score and a possible comment.

Fora

The platform allows users, both premium and basic, to upload posts on thematic fora. Each forum refers to:

  • one of the categories managed by the platform;
  • a study course;

Posts

Each post is uploaded on a forum by a user and includes:

  • a date of input;
  • a text;
  • a possible photo;

Matches

This table memorize:

  • an univocal identifier;
  • the date of execution;
  • a state field that inform teams and players if the event is closed or it allows further candidatures;
  • the category of the event;
  • the identifier of the building where the event will take place;

MatchCandidatures

This table keeps track of the candidatures to all the sports events. Each candidature refers to a single sports event, it has a date field and state field to inform the team or single player wether the candidature have been confirmed or not.

RefereeCandidatures

As for MatchCandidatures, this table keeps track of the candidatures of users whom applied to referee a given event.

Outcomes

This table keep track of the outcome for each closed match. Each outcome has the following fields:

  • date of input;
  • for events regarding soccer, volley and basket events:
    • names of the competing teams;
    • teams compositions;
    • point scored for each team;
    • list of player and point scored by them;
  • for events regarding tennis events:
    • number of sets won by each player;
    • duration of the match;

Teams

In the case of team tournaments, the platform allow premium users to create teams. A premium user can register a team specifying:

  • the team's name;
  • the team's colors;
  • the minimum and maximum number of participants;
  • a description;
  • possible notes;
  • a state field to specify if the team is in it definitive composition or it allows further candidatures;

TeamCandidatures

This table keeps track of all the candidatures for all teams registered on the platform, a user can apply for a team providing:

  • team's name;
  • applicant's name;
  • the role the player wants to play; The premium user who created the team decide wether or not to confirm the candidature.

Tournaments

The platform allow premium users to organize tournaments for each category. Each tournament is provided with:

  • a name;
  • a description;
  • a list of possible sponsors;
  • a list of prizes;
  • a list of possible restrictions;

Users

For each user the database will store:

  • an univocal username;
  • a password;
  • user's name;
  • user's surname;
  • user's year of birth;
  • user's place of birth;
  • a photo of the user;
  • user's phone number;
  • user's registration number;
  • the name of the study course the user is currently attending;
  • user privilege: basic or premium, basic users cannot plan sports events;

StudyCourses