Customization > Automation Interface > Object Attributes and Associations > Relationship (automation interface)
Relationship (automation interface)
An association between two tables in the storage class model whereby the primary key of the master table becomes a foreign key in the detail table.
ATTRIBUTES
In addition to the common attributes.
Description
A textual property that gives an overview of the dictionary item.
Access is read/write.
On Delete Option
A string that specifies what happens when a row is deleted from a related Table. Possible values are RESTRICT, CASCADE or SET NULL. When this attribute is blank, it represents a Delete Action of None.
Access is read/write.
One to One
A string that specifies whether the Relationship is one to one. Possible values are TRUE or FALSE.
Access is read/write.
Parent Optional
A string that specifies whether the parent is optional. Possible values are TRUE or FALSE.
Access is read/write.
ASSOCIATIONS
In addition to the common associations.
Relationship to Comments that are applied to the Relationship.
Multiplicity is 0+, access is read/write.
Relationship to Constraints that are applied to the Relationship item.
Multiplicity is 0+, access is read/write.
Class Model
A collection of Classes the table represents.
Multiplicity is 0+, access is read/write.
The Table at the many end.
Multiplicity is 1, access is read/write.
A collection of Key columns from related Tables.
Multiplicity is 0+, access is read-only.
The Table at the one end.
Multiplicity is 1, access is read/write.
Relationship to Comments that are owned by the Relationship.
Multiplicity is 0+, access is read/write.
Relationship to Constraints that are owned by the Relationship item.
Multiplicity is 0+, access is read/write.
The Table's prime Column.
Multiplicity is 1, access is read-only.