| Previous | Table of Contents | Next |
A Foreign Key associates columns from one table with columns of another table.
Superclasses
KeyRelationship
Attributes
deleteRule
An enumerated type. Indicates the disposition of the data records containing the foreign key value when the record of the matching primary key is deleted.type:multiplicity: |
|||||
| ReferentialRuleType ( importedKeyNoAction | importedKeyCascade | importedKeySetNull | importedKeyRestrict | importedKeySetDefault ) | |||||
| exactly one |
updateRule
Same as deleteRule for updates of the primary key data recordtype:multiplicity: |
|||||
| ReferentialRuleType ( importedKeyNoAction | importedKeyCascade | importedKeySetNull | importedKeyRestrict | importedKeySetDefault ) | |||||
| exactly one |
deferrability
Indicates if the validity of the ForeignKey is to be tested at each statement or at the end of a transaction.type:multiplicity: |
|||||
| DeferrabilityType ( initiallyDeferred | initiallyImmediate | notDeferrable ) | |||||
| exactly one |