JBooky

en français

Summary

1. specifications
2. conception
3. licencing

Conception

Summary

1. Database
1. diagram
2. Objects mapping
3. Objects handling

• Database

1. Database diagram



figure 1 : database diagram

The database is composed of the following tables:
• events,
• heats,
• entries,
• competitors,
• tickets,
• users.

The events table contains the data concerning each events. An event is composed of one or several heats.
The heats table contains the data concerning each heat. A heat is linked to one and only one event and is composed of one or several entries.
The entries table contains the data concerning each entry. An entry is linked to one and only one heat. An entry is the association of a competitor to a heat.
The competitors table contains the data concerning each competitor.
The tickets table contains the data concerning each bet ticket. A ticket is linked to one and only heat.
The users table contains the data concerning each user of the system.