Events: the event itself, with a date, optional name and description and a type
Event types: what kind of event it is, also determines the primary participants role name
Event roles: events can consist of multiple people in different roles, one being "Primary", which has a special name determined by the event type table. The primary role is not editable (should others be?)
Event relations: tuples of (person, event, role)
The event primary event role is also special, since it will determine which events are shown where (e.g. all primary events on top, with secondary ones below it or on another screen)
We need:
The event primary event role is also special, since it will determine which events are shown where (e.g. all primary events on top, with secondary ones below it or on another screen)