Question : If I create a new schema and set the schema owner to another schema, for example dbo, what […]
Tag: inheritance
Partial unique constraint spanning multiple tables in postgres
Question : To enforce partial uniqueness in postgres, it is a well known workaround to create a partial unique index […]
Is this a step in the right direction for normalization? SQL ‘inheritance’ and Many-to-Many relationships
Question : Context: So, this is kind of a compound question, but they go together, and definitely wouldn’t make sense […]
When using class inheritance, can all PKs of the derived tables exist as PKs of the base table?
Question : Brief questions When class inheritance is used, the child table inherits the key from the parent, right? Thus, […]
Finding a good DB design for my project
Question : I’ve posted this on stackOverflow but this might be a more suitable place. I’m really struggling to find […]
Designing an extensible authentication system
Question : I need to design an authentication system, where different type of authentication schemes may exist. At the end, […]
Foreign key double inheritance SQLITE
Question : I’m designing a domotic system database and I’m trying to figure out how to represent two foreign keys. […]
Will switching from Concrete Table Inheritance to Single Table Inheritance improve the performance of my queries?
Question : I currently have an application that allows people to view and share 10 different types of posts (ex […]
Query parent table and get child tables columns
Question : I have two tables, one inherits the other: CREATE TABLE parent ( col1 INTEGER ); CREATE TABLE child […]
Designing an extensible authentication system
Question : I need to design an authentication system, where different type of authentication schemes may exist. At the end, […]