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.

Sign up for GitHub

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

Jump to bottom

Rewrite relationships between works, editions, shortstories and people #47

Open
Makistos opened this issue Feb 28, 2024 · 0 comments
Open

Rewrite relationships between works, editions, shortstories and people #47

Makistos opened this issue Feb 28, 2024 · 0 comments
Assignees
@Makistos
Labels
enhancement New feature or request

Comments

@Makistos
Copy link
Owner

Current database model is far too complex with Part table joining all of those mentioned tables together. This makes queries too complex and makes backend logic fraught and error-prone.

New model could have separate WorkContributor and EditionContributor tables. Work and Ediition tables should have a direct 1:n relationship and ShortStory should link to Edition directly in an m:n relationship. ShortStory should also have its own StoryContribur table.
@Makistos Makistos added the enhancement New feature or request label Feb 28, 2024
@Makistos Makistos self-assigned this Feb 28, 2024
@Makistos Makistos added this to SuomiSF Feb 28, 2024
@github-project-automation github-project-automation bot moved this to Todo in SuomiSF Feb 28, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@Makistos Makistos

Labels
enhancement New feature or request
Projects
SuomiSF
Status: Todo
Milestone
No milestone
Development

No branches or pull requests
1 participant
@Makistos