Details
Major Description
On several occasions we have received petitions from our instructors demanding a way to know the order in which the students have signed up to the events, as well as the date and hour.
After some research, we discovered that, with the database structure we have at this moment, this isn't possible (see attached snapshots showing the database model of the tables involved).
Currently there are no columns to store the date signup up, nor, if the student removes their sign-up from the event, there is no record for this either, the row is just deleted.
Allowing instructors to access these details would be a great improvement for this tool.
Taking all the information stated above into account, we consider that at least we would need to make the following changes:
- Add one column to the tables "SIGNUP_TS_ATTENDEES" y "SIGNUP_TS_WAITINGLIST" to store the "INSCRIPTION_DATE".
- Modify the tool to add this attibute to the respective class, to add the logic needed to admin this information and to modify the Hibernate mapping.
- Add the date of inscription in the list of attendes and in the waiting list. keeping current orders (attendees by name and waiting lists by order of suscription).
- Add the date of inscription in the Excel files exported.
