Create DB schema/tables for events

[fennifith]

erDiagram
	direction TB
	Event {
		string slug PK ""  
		string banner_image
		string title  ""  
		string description  ""
		string location_description 
		string location_address
		string location_url
	}

	EventBlock {
		int id PK ""  
		string slug FK ""  
		string banner_image
		string title  ""  
		string description  ""  
		timestamptz starts_at  ""  
		timestamptz ends_at  ""
		string location_description
		string location_address
		string location_url
	}

	People {
		int id PK ""  
		string picture  ""  
		string name  ""  
	}

	EventOrganizer {
		int id PK ""  
		int person_id PK
		int order
	}

	EventPresenter {
		int id PK ""  
		int person_id PK
		int order
	}

	EventBlock}|--||Event:"  "
	EventPresenter}|--||EventBlock:"  "
	EventOrganizer}|--||Event:"  "
	EventPresenter}|--||People:"  "
	EventOrganizer}|--||People:"  "

Loading

TODO (create issues for this):

• API routes for accessing data
• routes for subscribing to ICS events for automated event pull
• schedule automated mailing list reminders for event blocks
• with user login, allow subscribing + unsubscribing from specific event notifications (on the mailing list)