search

SwissDataScienceCenter / renku-data-services

Services that handle reading and writing data from a database
Apache License 2.0
3 stars 1 forks source link

Introduce foreign key constraints for related tables #123

Open leafty opened 4 months ago

leafty commented 4 months ago

Postgres allows foreign key constraints between tables in different schemas. These should be added to the relevant tables to preserve data integrity.

Examples Authz and projects.

leafty commented 3 months ago

Migrations merged together in https://github.com/SwissDataScienceCenter/renku-data-services/pull/144.

We can now handle cleanly adding FK constraints on relevant tables.