Create API docs and add them to this repository

[jkleiber]

Summary
Supabase auto creates documentation for interacting with the database. For ease of use by other developers, these docs should be linked to this repo via the README or some other means.

[jkleiber]

While this information is still somewhat unclear, typescript types have been added for the database schema and will be maintained as best as possible. Remaining work in this issue is to integrate the typescript type generation into CI somehow so this can be kept updated. Eventually we will probably want to switch to typescript, but that's far enough out to not make it a ticket.

This is no longer MVP but still highly desirable. Moving off the milestone