Questions tagged [foreign-keys]

10

votes

3

answers

Foreign Key constraints missing after phpmyadmin export

asked 2013-07-26T20:26:20.477

11

votes

2

answers

Get all employee who directly or indirectly reports to an employee, with hierarchy level no

sql sql-server foreign-keys iteration primary-key

asked 2013-04-26T08:56:25.490

13

votes

4

answers

MySQL ON UPDATE CASCADE not CASCADEing

mysql foreign-keys cascade

asked 2013-04-12T17:45:25.037

12

votes

1

answers

Should I temporarily disable foreign key constraints? How?

sql database postgresql foreign-keys

asked 2013-02-21T15:57:39.103

37

votes

5

answers

How to disable Constraints for all the tables and enable it?

sql-server sql-server-2008 foreign-keys constraints foreign-key-relationship

asked 2013-02-20T05:21:09.577

14

votes

1

answers

In what scenarios do I need foreign keys AND navigation properties in entity framework

c# entity-framework ef-code-first foreign-keys entity-framework-5

asked 2013-02-16T22:44:31.893

22

votes

3

answers

SQLite foreign key examples

python sql sqlite insert foreign-keys

asked 2012-12-18T14:23:16.703

9

votes

4

answers

Constraint detail from information_schema (on update cascade, on delete restrict)

mysql foreign-keys constraints information-schema

asked 2012-10-04T19:18:46.217

18

votes

2

answers

MongoDB storing arrays of ObjectId's

mongodb foreign-keys objectid

asked 2012-09-17T18:04:18.547

22

votes

3

answers

MySQL find invalid foreign keys

mysql foreign-keys

asked 2012-08-10T18:12:02.593

12

votes

1

answers

EF One-to-many Foreign Keys without child navigation properties

c# entity-framework foreign-keys code-first

asked 2012-07-05T18:40:24.977

26

votes

3

answers

Foreign Key fails to create

sql-server foreign-keys constraints foreign-key-relationship

asked 2012-07-04T07:35:25.090

67

votes

4

answers

POSTGRESQL Foreign Key Referencing Primary Keys of two Different Tables

postgresql foreign-keys

asked 2012-04-09T01:32:53.513

26

votes

1

answers

Does Oracle automatically create a secondary index for FOREIGN KEY columns?

performance oracle-database indexing foreign-keys

asked 2012-02-13T15:18:06.837

18

votes

4

answers

Adding a nullable foreign key

sql sql-server-2008 foreign-keys

asked 2012-02-08T19:09:10.687

9

votes

3

answers

mysql - Mutually dependent foreign keys

mysql database-design foreign-keys

asked 2012-01-24T17:08:21.010

10

votes

2

answers

Foreign key to composite key

sql-server foreign-keys

asked 2011-12-20T11:57:01.790

152

votes

7

answers

SqlAlchemy - Filtering by Relationship Attribute

python filter sqlalchemy foreign-keys

asked 2011-12-19T12:35:48.777

11

votes

3

answers

Doctrine 2 One-To-One unidirectional relationship delete non-owning side

doctrine foreign-keys

asked 2011-12-02T00:51:04.863

9

votes

2

answers

grails composite "unique constraint", but how?

grails foreign-keys grails-orm composite-key

asked 2011-11-06T20:30:32.590

14

votes

2

answers

natural key vs surrogate key an innodb foreign key

mysql database database-design foreign-keys relational-database

asked 2011-11-01T19:11:44.013

19

votes

2

answers

SQL Script to find Foreign keys to a specific table?

sql sql-server-2008 foreign-keys constraints

asked 2011-10-21T17:43:13.687

474

votes

11

answers

Can a foreign key be NULL and/or duplicate?

sql sql-server oracle-database foreign-keys

asked 2011-09-27T17:57:45.437

10

votes

3

answers

Abstract Models and Foreign Keys in Django

django-models foreign-keys abstract-class

asked 2011-09-23T17:31:14.403

20

votes

2

answers

MySql Foreign keys: ON DELETE NO ACTION behavour - how to leave info in referenced field?

mysql foreign-keys

asked 2011-09-22T08:00:19.143

18

votes

2

answers

Foreign Key to User model

django foreign-keys

asked 2011-09-05T14:41:43.707

21

votes

1

answers

Django models: mutual references between two classes and impossibility to use forward declaration in python

python django model foreign-keys forward-declaration

asked 2011-09-04T09:30:53.047

439

votes

4

answers

How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

sql database-design foreign-keys relational-database relationship

asked 2011-09-04T01:17:36.723

17

votes

2

answers

MySQL foreign keys on self

mysql foreign-keys self-reference

asked 2011-08-29T12:35:37.467

14

votes

6

answers

does extracting strings into another table and making the original column a foreign key save space?

mysql sql foreign-keys

asked 2011-08-24T21:41:05.837

24

votes

10

answers

Adding foreign key to existing table gives error 1050 table already exists

mysql foreign-keys mysql-workbench mysql-error-1050

asked 2011-08-10T23:08:27.910

29

votes

3

answers

Why won't my GenericForeignKey cascade when deleting?

django foreign-keys cascading-deletes django-contenttypes generic-foreign-key

asked 2011-07-23T20:12:53.467

17

votes

4

answers

Inline-like solution for Django Admin where Admin contains ForeignKey to other model

python django django-admin foreign-keys

asked 2011-06-21T01:02:25.920

150

votes

7

answers

Foreign keys in mongo?

sql mongodb foreign-keys nosql

asked 2011-06-13T17:40:35.300

11

votes

3

answers

Foreign keys must be Index in mySQL?

mysql sql foreign-keys indexing

asked 2011-06-03T17:34:26.607

74

votes

6

answers

Django "Cannot add or update a child row: a foreign key constraint fails"

mysql django orm foreign-keys

asked 2011-05-30T16:47:41.353

13

votes

10

answers

can't add foreign key in mysql?

mysql foreign-keys mysql-error-1005

asked 2011-04-22T17:22:25.323

46

votes

1

answers

How do I add a Foreign Key Field to a ModelForm in Django?

django django-models django-forms foreign-keys

asked 2011-04-18T20:42:19.863

885

votes

17

answers

How to truncate a foreign key constrained table?

mysql foreign-keys constraints truncate dml

asked 2011-03-27T21:57:42.843

11

votes

3

answers

using self referencing in sql server

sql sql-server sql-server-2005 foreign-keys self-reference

asked 2011-03-26T13:45:10.603

116

votes

3

answers

composite key as foreign key

c# entity-framework ef-code-first foreign-keys composite-key

asked 2011-03-25T18:41:51.267

13

votes

4

answers

MySQL - Unique foreign key

mysql foreign-keys unique

asked 2011-03-15T13:00:33.660

55

votes

3

answers

SQlite - Android - Foreign key syntax

android sqlite foreign-keys

asked 2011-03-13T14:06:21.130

10

votes

4

answers

How can I merge two redundant records in a MySQL table, maintaining all PK/FK relationships?

php mysql merge foreign-keys redundancy

asked 2011-03-08T19:00:39.767

10

votes

2

answers

Rails: can I use polymorphic references with non-integer primary keys?

ruby-on-rails activerecord foreign-keys uuid

asked 2011-01-19T15:30:30.533

18

votes

2

answers

In django, how to limit choices of a foreignfield based on another field in the same model?

django foreign-keys limit

asked 2010-11-08T11:12:20.913

507

votes

11

answers

How to select rows with no matching entry in another table?

sql foreign-keys

asked 2010-11-02T08:47:50.217

9

votes

3

answers

MySQL Foreign Key Constraint - Integer Column

sql mysql foreign-keys

asked 2010-10-28T20:01:03.113

83

votes

4

answers

MySQL InnoDB foreign key between different databases

mysql database foreign-keys innodb

asked 2010-10-11T09:32:41.537

14

votes

3

answers

use the returned value of the query as a foreign key without starting a new transaction or dropping foreign key constraint

postgresql transactions foreign-keys

asked 2010-09-16T20:49:15.127

Questions tagged foreign-keys