Column (automation interface)
Attribute of a Table in which data of identical format is stored for each record of the Table.
ATTRIBUTES:
In addition to the common attributes
Can Be Null
This indicates whether a Column can contain a null value. Possible values are TRUE or FALSE.
Access is read/write.
Datatype
A string describing the type of data to which values in the Column must conform.
Access is read/write.
Default Values
The value of this Column which each record should initially take.
Access is read/write.
Description
A textual property that gives an overview of the dictionary item.
Access is read/write.
Domain Values
Possible values that data in the Column can take.
Access is read/write.
Is Foreign
Indicates whether this column is a foreign key. Possible values are TRUE or FALSE.
Access is read-only.
Is Prime
This indicates whether a Column forms part of the Primary Key of the Table. Possible values are TRUE or FALSE.
Access is read/write.
Is Unique
This indicates whether each value in a Column must contain a unique value. Possible values are TRUE or FALSE.
Access is read/write.
Precision
The precision and scale of a numerical value or the size of a textual value.
Access is read/write.
ASSOCIATIONS:
In addition to the common associations
Relationship to Comments that are applied to the Column.
Multiplicity is 0+, access is read/write.
Relationship to Constraints that are applied to the Column.
Multiplicity is 0+, access is read/write.
Class Model
A collection of related items in the Class Model, indicating where this Column came from in the storage mapping.
Multiplicity is 0+, access is read/write.
If this Column is prime, then this collection is the corresponding foreign key Columns. There will be one per Relationship where the Table of this Column is the master.
Multiplicity is 0+, access is read/write.
A collection of dictionary items of type Index.
Multiplicity is 0+, access is read/write.
Relationship to Comments that are owned by the Column.
Multiplicity is 0+, access is read/write.
Relationship to Constraints that are owned by the Column.
Multiplicity is 0+, access is read/write.
If this Column is a foreign Column, it will get the corresponding prime Column.
Multiplicity is 1, access is read-only.
A relationship with a Dictionary Item of type Table.
Multiplicity is 1, access is read/write.