query: What would I use a MATCH SIMPLE foreign key for?
positive_passages.docid: 11467
positive_passages.text: Differences between MATCH FULL, MATCH SIMPLE, and MATCH PARTIAL?
negative_passages.docid: 34609
negative_passages.text: How can I define a composite primary key in SQL?
negative_passages.docid: 145311
negative_passages.text: Generate an increment ID that is unique for a given value of a foreign key
negative_passages.docid: 26537
negative_passages.text: Possible to do a MySQL foreign key to one of two possible tables?
negative_passages.docid: 28969
negative_passages.text: MySQL syntax for Join Update
negative_passages.docid: 147230
negative_passages.text: Should every table have a single-field surrogate/artificial primary key?
negative_passages.docid: 89217
negative_passages.text: Adding Foreign Key Error
negative_passages.docid: 72701
negative_passages.text: How to emulate SOQL LIKE matching in Apex?
negative_passages.docid: 112312
negative_passages.text: Create unique sequence per set of rows sharing the same foreign key value
negative_passages.docid: 148712
negative_passages.text: Do I need a composite primary key in a junction table?
negative_passages.docid: 36815
negative_passages.text: SQL: how to select a single id ("row") that meets multiple criteria from a single column
negative_passages.docid: 28430
negative_passages.text: Are composite primary keys bad practice?
negative_passages.docid: 36642
negative_passages.text: Compound primary key in Table type variable
negative_passages.docid: 101199
negative_passages.text: PostgreSQL foreign key not existing, issue of inheritance?
negative_passages.docid: 158985
negative_passages.text: Can a foreign key be NULL and/or duplicate?
negative_passages.docid: 51215
negative_passages.text: Creating entity relationship with renamed fields and non-primary key in primary table
negative_passages.docid: 33417
negative_passages.text: Tune a simple inner join query