playfulprogramming / playfulprogramming/hoof
Create DB schema/tables for events
Open
@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
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Assessment
This issue has not been assessed yet.