playfulprogramming / playfulprogramming/hoof

Create DB schema/tables for events

Open
#40 1 comment 0 reactions 1 assignee View on GitHub

@LadyBluenotes is already working on this.

Since Jan 23, 2026.

backend
Dominant language
TypeScript
Stars
9
Forks
7
Avg merge
1d 2h
Merged PRs (30d)
23

Description

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:"  "



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)

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.