Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Research: Create an ER diagram to describe DB tables for posts, collections, and authors #6

Open
fennifith opened this issue Feb 5, 2025 · 0 comments

Comments

@fennifith
Copy link
Member

For all the necessary properties, see PostInfo.ts, CollectionInfo.ts, and PersonInfo.ts

Not all of this needs an individual database column; e.g. roles, achievements, socials could be stored in JSONB.

Some of these will need additional tables to define relations; author to post is many-to-many, so we'll need a PostAuthor table to store the authors of each post.

PostInfo and CollectionInfo should also include columns for the raw post markdown.

@fennifith fennifith changed the title (WIP) Create DB tables for posts, collections, and authors Research: Create an ER diagram to describe DB tables for posts, collections, and authors Feb 17, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
Status: No status
Development

No branches or pull requests

1 participant