space
Previous Page | Next Page

SAS Namespace Types

KeyAssociation


Subclass of SecondaryType


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 list of associations is used to determine if this object should inherit access controls from another object (inheritance), or if the association is allowed for the object (enforcement). An association will not be created unless the calling user is authorized to update one or both objects involved in the association. For more information about inheritance and enforcement rules, see the SAS Intelligence Platform: Security Administration Guide.

Attributes

Inherited Attributes
Name, Id, Desc, MetadataCreated, MetadataUpdated, ChangeState, LockedBy, SecTransctxt, 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

Previous Page | Next Page | Top of Page