SAS Namespace Types

KeyAssociation

Overview

Represents the relationship between two columns in a foreign key/unique key relationship. For example, if table a has a unique key of columns a1 and a2, and table b has a foreign key of columns b1 and b2, into table a, there is a keyassociation between the columns that relate to each other, for example, b1 to a1 and b2 to a2.

Security Inheritance and Enforcement Rules

The following is a list of associations that are used to determine if this object should inherit access controls from another object (inheritance) or if the association is allowed for the object (enforcement). For more information about inheritance and enforcement rules, see the SAS 9.2 Intelligence Platform: Security Administration Guide.

OwningForeignKey

Attributes

Inherited Attributes
Name Id Desc MetadataCreated MetadataUpdated ChangeState LockedBy UsageVersion

Associations

= indicates the resident side of an association, or where the association is persisted for cross-repository associations. If no resident side is indicated, this association may not cross repository boundaries.

Name	Cardinality	Description	Associated Types
ForeignKeyColumn Partner: ForeignKeyAssociations	0 to 1	The columns that comprise a foreign key. Through this object, the foreign key columns are associated with the columns that comprise a particular unique key.	Column ColumnRange
OwningForeignKey Partner: KeyAssociations	1 to 1	The foreign key associated with this object.	ForeignKey
UniqueKeyColumn Partner: UniqueKeyAssociations	0 to 1	The column that is part of a unique key that is associated through this object with a column that is part of a foreign key.	Column ColumnRange

Inherited Associations
AccessControls/Objects , Changes/Objects , CustomAssociations/OwningObject , Documents/Objects , Extensions/OwningObject , ExternalIdentities/OwningObject , Groups/Members , Implementors/ImplementedObjects , Keywords/Objects , LocalizedAttributes/AssociatedLocalizedObject , Notes/Objects , PrimaryPropertyGroup/AssociatedObject , Prompts/PromptEnabledObject , Properties/AssociatedObject , PropertySets/OwningObject , ReferencedObjects/AssociatedObjects , ResponsibleParties/Objects , SourceTransformations/TransformationSources , SpecSourceTransformations/SourceSpecifications , SpecTargetTransformations/TargetSpecifications , TargetTransformations/TransformationTargets , Timestamps/Objects , Trees/Members , TSObjectNamespace/TSObjects , UsedByPrototypes/UsingPrototype , UsingPrototype/UsedByPrototypes , Variables/AssociatedObject ,

Association Details

ForeignKeyColumn
     Cardinality: 0 to 1
     Partner: ForeignKeyAssociations

The columns that comprise a foreign key. Through this object, the foreign key columns are associated with the columns that comprise a particular unique key.

Associated Types:
Column ColumnRange

OwningForeignKey
     Cardinality: 1 to 1
     Partner: KeyAssociations

The foreign key associated with this object.

Associated Types:
ForeignKey

UniqueKeyColumn
     Cardinality: 0 to 1
     Partner: UniqueKeyAssociations

The column that is part of a unique key that is associated through this object with a column that is part of a foreign key.

Associated Types:
Column ColumnRange

Top of Page