Fix/243/new api

Todo: 
- [ ] use the clubs table for an event instead of a string (simplifies abilities and enables the use of the `display_name` and `full_name`)
- [ ] Merge the organisation and club columns as they both mean the same