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

Add foreign key constraints to database scheme #23

Open
slodki opened this issue Apr 28, 2018 · 3 comments
Open

Add foreign key constraints to database scheme #23

slodki opened this issue Apr 28, 2018 · 3 comments
Assignees

Comments

@slodki
Copy link
Contributor

slodki commented Apr 28, 2018

Foreign key constraints will allow:

@slodki
Copy link
Contributor Author

slodki commented Dec 1, 2018

I think this is a complete entity-relationship diagram for the current db schema.
tables

Relations not implemented at SQL level:

  • CUSTOMFIELDDATA.REFID (depends on CUSTOMFIELD.REFTYPE)
  • ATTACHMENT.REFID (depends on ATTACHMENT.REFTYPE)
  • TRANSLINK.LINKRECORDID (depends on TRANSLINK.LINKTYPE)

slodki added a commit to slodki/database that referenced this issue Dec 1, 2018
@slodki
Copy link
Contributor Author

slodki commented Dec 1, 2018

TODO: prepare upgrade script (similar to v12)

@slodki
Copy link
Contributor Author

slodki commented Dec 2, 2018

This will require to replace all -1 values with NULL in db...

slodki added a commit to slodki/database that referenced this issue Jun 20, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant