Question

MySQL: Using natural primary index or adding surrogate when tables are given

score 756 · Answer 1 · 2015-06-08 14:08:41

756

Views

MySQL: Using natural primary index or adding surrogate when tables are given

Published on 08 June 2015 at 14:08

score 1.1k · Answer 2 · 2014-11-10 09:51:52

1.1k

Views

Why doesn't @NaturalId create a unique constraint in the database?

Published on 10 November 2014 at 09:51

score 2.1k · Answer 3 · 2014-11-26 17:36:52

2.1k

Views

Email address as resource identifier in a REST API

Published on 26 November 2014 at 17:36

score 455 · Answer 4 · 2014-12-08 18:28:49

455

Views

Phalcon PHP: Update a primary natural key

Published on 08 December 2014 at 18:28

score 323 · Answer 5 · 2018-11-07 16:39:24

323

Views

What are some good candidate keys for ‘person’?

Published on 07 November 2018 at 16:39

score 2.7k · Answer 6 · 2013-08-11 00:42:31

2.7k

Views

Django fixtures primary key error, need natural keys solution

Published on 11 August 2013 at 00:42

score 1k · Answer 7 · 2009-10-22 14:22:10

1k

Views

Must Django ManyToManyField association tables have a surrogate key?

Published on 22 October 2009 at 14:22

score 160 · Answer 8 · 2021-05-25 09:16:56

160

Views

Filtering by natural key?

Published on 25 May 2021 at 09:16

score 1k · Answer 9 · 2014-05-16 19:26:33

1k

Views

Get_by_natural_key throwing AttributeError?

Published on 16 May 2014 at 19:26

score 3.9k · Answer 10 · 2010-09-19 22:27:07

3.9k

Views

Relational database design question - Surrogate-key or Natural-key?

Published on 19 September 2010 at 22:27

score 3.2k · Answer 11 · 2011-04-28 12:35:10

3.2k

Views

Hibernate: bug when mapping a reference to an alternative/natural key column of a sub table?

Published on 28 April 2011 at 12:35

score 306 · Answer 12 · 2019-12-11 10:11:02

306

Views

Why would one consider using Surrogate keys vs Natural with ON UPDATE CASCADE?

Published on 11 December 2019 at 10:11

score 314 · Answer 13 · 2010-04-08 18:15:33

314

Views

Unique identifiers for users

Published on 08 April 2010 at 18:15

score 868 · Answer 14 · 2013-01-21 00:14:19

868

Views

Django deserialization of a natural key that contains another natural key

Published on 21 January 2013 at 00:14

score 884 · Answer 15 · 2014-08-24 04:23:06

884

Views

@NaturalId only valid on root entity (or its @MappedSuperclasses), using Natural Id in Joined, Multiple Table Inheritance

Published on 24 August 2014 at 04:23

score 1.5k · Answer 16 · 2013-05-13 07:57:56

1.5k

Views

Surrogate key 'preference' explanation

Published on 13 May 2013 at 07:57

score 395 · Answer 17 · 2012-03-28 18:51:44

395

Views

How can I update a MySQL natural key while avoiding duplicate foreign keys?

Published on 28 March 2012 at 18:51

score 2.7k · Answer 18 · 2009-04-06 15:04:54

2.7k

Views

Entity Framework and associations between string keys

Published on 06 April 2009 at 15:04

score 33 · Answer 19 · 2015-03-23 21:48:09

33

Views

MySQL/Percona: Date Range data integrity (via natural key)

Published on 23 March 2015 at 21:48

score 601 · Answer 20 · 2011-12-22 08:27:25

601

Views

Using National ID as Primary Key

Published on 22 December 2011 at 08:27

List Question

MySQL: Using natural primary index or adding surrogate when tables are given

Why doesn't @NaturalId create a unique constraint in the database?

Email address as resource identifier in a REST API

Phalcon PHP: Update a primary natural key

What are some good candidate keys for ‘person’?

Django fixtures primary key error, need natural keys solution

Must Django ManyToManyField association tables have a surrogate key?

Filtering by natural key?

Get_by_natural_key throwing AttributeError?

Relational database design question - Surrogate-key or Natural-key?

Hibernate: bug when mapping a reference to an alternative/natural key column of a sub table?

Why would one consider using Surrogate keys vs Natural with ON UPDATE CASCADE?

Unique identifiers for users

Django deserialization of a natural key that contains another natural key

@NaturalId only valid on root entity (or its @MappedSuperclasses), using Natural Id in Joined, Multiple Table Inheritance

Surrogate key 'preference' explanation

How can I update a MySQL natural key while avoiding duplicate foreign keys?

Entity Framework and associations between string keys

MySQL/Percona: Date Range data integrity (via natural key)

Using National ID as Primary Key

Trending Questions

Popular # Hahtags

Popular Questions