Question : I’m designing a domotic system database and I’m trying to figure out how to represent two foreign keys. […]
Tag: inheritance
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, […]
How to enforce data consistency across one-to-one relationship in an inheritance hierarchy
Question : Consider this design for a typical school database: Person: —————– FirstName LastName SocialSecurityNumber Phone Email Student: —————– Grade […]
PostgreSQL migrate data from one table to another (which inherits the first one)
Question : I have a table “company” and another named “school” (“school” table inherits “company”). Most of the data is […]
PostgreSQL 10.6: Alter parent table will block ALL children?
Question : I want to add a column to near 74.000 child tables. These tables continually have insertions and reads […]
Modeling a product database and dealing with inheritance
Question : So, to get better at designing databases, I’m attempting to model a database system after the AR15 Builder. […]
Using table inheritance instead of mapping tables
Question : This seems like a pretty common scenario: several types that all compose the same child type. This could […]
Postgres 9.5 foreign table inheritance not using indexes
Question : In PostgreSQL 9.5.0 I have a partitioned table that collects data by months. I tried to use the […]