Question : I’m a fan of surrogate keys. There is a risk my findings are confirmation biased. Many questions I’ve […]
Tag: surrogate-key
Can a surrogate key and a primary key be in the same table?
Question : For example we have: Surrogate key: ABC123 Primary key: 1 Name: James Is this legit in a Data […]
What problems are there in not using a primary key column at all?
Question : What purpose would a primary key column serve on a table such as post_versions here? Nothing refers to […]
Should a inherited table have a new surrogate key, or just use parent table’s key?
Question : I am modeling some things with an “is a” relationship (aka inheritance), and there were two ways to […]
PostgreSQL surrogate keys: use sequence/bigint or OID?
Question : I’m looking at a need for surrogate keys in tables I’m designing on a PostgreSQL-derived DBMS (Citus). Would […]
Is it acceptable to have a surrogate/primary key of one table be the primary/foreign key of another table?
Question : For my purposes I’m trying to apply this to Microsoft SQL, but would like to know if there […]
Surrogate keys as Foreign Keys
Question : I have a question about Surrogate keys, say i have two tables(in sql server): Table A: Student_ID, Name, […]
Surrogate key resolution, or what am I missing in the Surrogate v Natural argument?
Question : I’ve read a lot from both camps in the surrogate vs. natural key debate. What I am struggling […]
What are the consequences, positive or negative, to having a surrogate primary key for a table which already has a guaranteed unique column? [closed]
Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]
Composite primary key plus a separate (surrogate) id column for foreign key references
Question : I am trying to build a database about locations like so: Country → Region → Town Countries will […]