 |
|
| 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.
- 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, ColumnRangeOwningForeignKey
Cardinality: 1 to 1
Partner: KeyAssociations
The foreign key associated with this object.
Associated Types:
ForeignKeyUniqueKeyColumn
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
|
|
Copyright © 2011 by SAS Institute Inc., Cary, NC, USA. All rights reserved.