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

Create relationship table between pub and pub_history #35

Open
LegalizeAdulthood opened this issue Oct 17, 2019 · 1 comment
Open

Create relationship table between pub and pub_history #35

LegalizeAdulthood opened this issue Oct 17, 2019 · 1 comment
Labels
codeplex For issues that were imported from codeplex enhancement

Comments

@LegalizeAdulthood
Copy link
Owner

pub references pub_history and pub_history references pub.

This creates an awkward situation when you add a publication, you first add to the pub table and get the id for that and add to the pub_history table, then you have to update the pub table again to reference the new pub_history row.

Fix this by creating a table that explicitly links publications to their edit history.

The pub table would have it's pub_history reference removed. The new table would be used instead to obtain the current pub_history entry for a pub.

Adding a publication would be:

  • add a pub row
  • add a pub_history row using pub_id
  • add a pub_revision row using pub_id, pub_history_id
@LegalizeAdulthood LegalizeAdulthood added the codeplex For issues that were imported from codeplex label Oct 17, 2019
@LegalizeAdulthood
Copy link
Owner Author

See Paul's design notes about the pub/pubhistory table origin.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
codeplex For issues that were imported from codeplex enhancement
Projects
None yet
Development

No branches or pull requests

1 participant