Click here to Skip to main content
15,879,535 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:

I tell you what I have in mind and I would need the vision of more people to design/organize the database in the best possible way.

As a first note, I need a database to control the times of the participants during an event which can be divided into several days.

Starting from that first note, the minimum tables I would need:

EVENTS (id, name, start_date, end_date, location..........)
STAGE (id, id_event, name, date..............)
PARTICIPANTS (id, name, surname.....)
PARTICIPANT_EVENT (id, id_participant, id_event)
CATEGORIES (id, name..........)
PARTICIPANTS_CATEGORIES (id_participant_event, id_category)
TIMES (id_event_participant, stage_id, start_time, end_time)
PENALTIES (i_:participant_event, time)

I plan to do something like this with the tables, although if you see any improvement correction to be made, I would appreciate it if you told me.

All this will be to exploit it with PHP, what interests me is:
- A classification per day event (this has no major problem)
- If it consists of several stages, on the second stage and later see if it has advanced or not some position of the classification of the previous day (to do this I do not know what would be the best way to do it, I would need a little help)
- A history per participant of all the events where he has taken part and his position in that event (I don't know how to guide him either quite well to be able to do it)

Any help, recommendation will be welcome.

Thank you :)

What I have tried:

I am in full analysis of how to do what is described
Updated 3-Jun-22 13:08pm
PIEBALDconsult 3-Jun-22 19:11pm    
The choice of database technology is probably the least important thing to consider.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900