Tag: foreign-key


Found 306 results for 'foreign-key'.


1) postgresql - Select orphaned rows (in a generic way)
2) mysql - Proper database structure for storing multiple foreign keys
3) database-design - Are there DBMS that allow a Foreign Key that References a View (and not only base tables)?
4) postgresql - Design: similar tables and foreign keys
5) mysql - Insert Row With Foreign Key Equal to ID - Circular Reference
6) postgresql - Retrieving all PK and FK
7) postgresql - DROP TABLE ... CASCADE does not drop any dependent table
8) postgresql - Finding entries which have no foreign key mapping in any other table
9) postgresql - ENUM and ID as a Foreign Key
10) postgresql - Two-column foreign key constraint only when third column is NOT NULL
11) postgresql - Postgres - Only allow insert if TWO columns match with a separate table
12) postgresql - Postgres - Importing multiple rows with Foreign key constraint
13) mysql - Foreign key set to cascading but fails to update - why?
14) mysql - How to design table to allow marking records as related to each other?
15) mysql - Database design of Room Booking system in a Hotel
16) database-design - Designing a friendships database structure: Should I use a multivalued column?
17) database-design - Whats the right table relationship for these entities?
18) mysql - MySQL - Delete row that has a foreign key constraint which reference to itself
19) postgresql - Foreign key on PostgreSQL range bounds
20) mysql - Mysql might have too many indexes
21) mysql - MySQL - automatically update all references to specific table to use on delete cascade?
22) mysql - How do I prove that the act of removing foreign keys doesn't corrupt existing data?
23) database-design - How to relate two rows in the same table
24) postgresql - Designing a database structure for companies and stock owners
25) mysql - SQL Query; Admin Log System; Foreign Keys; Retriving multiple rows form different tables at once
26) database-design - Table Design for user-specific and user-agnostic criteria
27) mysql - Advice on a basic design, first time database design
28) database-design - How to link a customer to a country when the city/state isn't known
29) database-design - What's an alternative solution to using a null value for a foreign key field?
30) postgresql - Tricky condition for PostgreSQL UPDATE query
31) postgresql - Discover missing foreign keys and/or indexes
32) database-design - Two tables, one foreign key, and two primary keys
33) sql-server - Referential integrity when two FK columns need to match themselves in the same table?
34) postgresql - two-table-over <+> functional relationship: maintaining referential integrity
35) mysql - LEFT JOIN not working as intended
36) sql-server - How can a primary key be inserted as foreign key?
37) postgresql - ON CONFLICT DO UPDATE command cannot affect row a second time when trying to pass additional columns from a CTE in postgresql
38) postgresql - Exclusion constraint on recursive foreign key (on the example of a Tree)
39) foreign-key - Foreign Keys to tables where primary key is not clustered index
40) postgresql - Automatic index creation for primary vs. foreign keys in Postgresql
41) sql-server - Change clustered index without dropping the primary key
42) postgresql - Why do composite foreign keys need a separate unique constraint?
43) postgresql - PostgreSQL - insert/update violates foreign key constraints
44) performance - MariaDB Uuid as Primary Key Performance Problem / Tweaks
45) mysql - Foreign Key Constraint fails
46) postgresql - Key/value table: what is a good way to organize it if value could be foreign key?
47) postgresql - Access articles from a table if user belongs to qualified group
48) mysql - Auto-increment key and Foreign Key as composite for relational database
49) database-design - Enforce uniqueness across optional attributes for an entity
50) database-design - Is it possible to enforce corresponding hierarchies?