After thoughts

[Topvennie]

The gitea has a collection of after thoughts of events, it would be nice to link it with events.

The following features are desired in the frontend:

• Add and edit the after thoughts for an event.
• See for an event all the after thoughts of previous editions.
• Browse for each type of event the after thoughts of previous editions.

Taking those requirements into account I would suggest the following (simplified) database structure

after_thought

• event_id
• content

event_type

• display name

event

• add a column 'event_type'

This would also allow for a potential extension 'event categories'. Each event type could have a new field 'category'.
For example

• Codenight
• Social
• Sport

Each event could then, upon creation, get a type assigned based on fuzzy finding. I image it would go like this

1. Go over each type
2. Go over each event of that type
3. Check if the title is similar
   3.1. If it is, assign the type to the event
   3.2. If it isn't, go to the next event for that type. Keep going until every type is checked. If none match create a new type.

The frontend would then also need to support the following

• Rename an event type.
• Manually assign an event to a type.

When an user changes the type of an event we should also check if there are any events left of that type. If not -> delete the type.