Class ForeignKey {Analysis} derived from: ReferenceConstraint

Documentation
Section 4.17
In the case that a table constraint is a referential constraint, the table is referred to as the referencing table. The referenced columns of a referential constraint shall be the unique columns of some unique constraint of the
referenced table.

Section 11.8
5) The referenced table shall be a base table.
Case:
a) If the referencing table is a persistent base table, then the referenced table shall be a persistent base table.
b) If the referencing table is a global temporary table, then the referenced table shall be a global temporary table.
c) If the referencing table is a created local temporary table, then the referenced table shall be either a global temporary table or a created local temporary table.
d) If the referencing table is a declared local temporary table, then the referenced table shall be either a global temporary table, a created local temporary table or a declared local temporary table.

6) If the referenced table is a temporary table with ON COMMIT DELETE ROWS specified, then the ref-erencing table shall specify ON COMMIT DELETE ROWS .
7) Each referencing column shall identify a column of the referencing table, and the same column shall not be identified more than once.
9) The <referencing columns> shall contain the same number of <column name> s as the <referenced table and columns> . The i-th column identified in the <referencing columns> corresponds to the i-th column identified in the <referenced table and columns> . The declared type of each referencing column shall be comparable to the declared type of the corresponding referenced column. There shall not be corresponding constituents of the declared type of a referencing column and the declared type of the corresponding referenced column such that one constituent is datetime with time zone and the other is datetime without time zone.
10) If a <referential constraint definition> does not specify any <update rule> , then an <update rule> with a <referential action> of NO ACTION is implicit.
11) If a <referential constraint definition> does not specify any <delete rule> , then a <delete rule> with a <referential action> of NO ACTION is implicit.


Parent PackageConstraintsAbstractNo
Export ControlPublicAccessLink Class forNone
Class KindNormalClassCardinalityn
Space ConcurrencySequential
PersistenceNo  


Attributes
NameClassTypeInitial Value
matchForeignKeyMatchTypeMATCH_SIMPLE
onUpdateForeignKeyReferentialActionTypeNO_ACTION
onDeleteForeignKeyReferentialActionTypeNO_ACTION
deferrableConstraintboolean 
initiallyDeferredConstraintbooleanfalse
nameSQLObjectString 
descriptionSQLObjectString 
labelSQLObjectString 


Associations
NameMy RoleMy ClassOther RoleOther Element
--Not Named----Not Named--ForeignKeyuniqueConstraintUniqueConstraint
--Not Named----Not Named--ForeignKeyreferencedMembersColumn
--Not Named----Not Named--ReferenceConstraintmembersColumn
table-constraintconstraintsTableConstraint--Not Named--BaseTable


Generalization Relationships
NameClassSupplier
--Not Named--ForeignKeyReferenceConstraint
--Not Named--ReferenceConstraintTableConstraint
--Not Named--TableConstraintConstraint
--Not Named--ConstraintSQLObject



Property Settings

Data Modeler
dmItemFalseDMName 
IsTableFalseIsViewFalse
IsDomainFalseIsSPPackageFalse
Synonymns TableSpaceID 
SourceId SourceType 
CorrelationName SelectClause 
IsUpdateableTrueCheckOptionNone
IsSnapShotFalseIsDistinctFalse
PersistToServer IsPackageFalse