Question : I am trying to enforce relational integrity across some database design containing sensor data. The relevant parts of […]
Tag: referential-integrity
Are there DBMS that allow a Foreign Key that References a View (and not only base tables)?
Question : Inspired by a Django modeling question: Database Modeling with multiple many-to-many relations in Django. The db-design is something […]
is there some way to give me the order in which inserts should be made so all FK constraint are met? [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Shopping list question – questions about which […]
MySQL cannot create foreign key, errors 1005, 150
Question : I’m trying to add a foreign key to a MySQL InnoDB table, linking a BIGINT with a table […]
How to model very flexible referencing relationships between many tables?
Question : I have various different entity types in my database. For purposes of example, consider an IMDB database: Movie […]
What is the correct way to map relationships between structurally similar comments tables and commentable entities?
Question : I’m working on the usual comments table in postgres that has a one-to-many relationship with a commentable entity. […]
Referential Integrity – Re-using table
Question : This is a simplified example of a design issue that I am facing: I have 3 tables: Car, […]
SELECT + INSERT or INSERT alone
Question : I have an application where several devices send data every second to my server. On the database I […]
Referential integrity when two FK columns need to match themselves in the same table?
Question : It’s possible my design is wrong, or there’s simply a better way. I’ll use a very simple example: […]
How to model very flexible referencing relationships between many tables?
Question : I have various different entity types in my database. For purposes of example, consider an IMDB database: Movie […]