System Architect maintains several properties in the column definition that are read only in the column definition dialog, and others that are not visible; all can be output through the reporting system:
Database name
The database name is specified for a Physical Data Model diagram when the diagram is initially created, and is included as a property for all objects belonging to the diagram (tables, columns, constraints, indexes, and so on). This property represents the target database of the PDM. This property is not displayed in the table, column, constraint, or index definition dialogs, but is printed on report output.
Key Component Number
A Key Component Number is automatically assigned to a column or attribute that is specified as being a component of the primary key. This property is not displayed in the column or attribute definition dialog, but can be displayed in report output.
When a foreign key is propagated in System Architect, a “Logical Foreign Key Component,” “Super-Sub Key Component” or “Physical Foreign Key Component” is created in the dictionary, and can be viewed in the Explorer. The name of the definition is a long string of numerics prefixed with FK.
Source Attribute
When a Physical Data Model is generated from an Entity Relation diagram, each column created in the PDM automatically includes the name of the attribute from which it was derived.
The Source Attribute property is not displayed in the Column definition dialog, but can be printed in output reports.
Source Data Element
When a Physical Data Model is generated from an Entity Relation diagram, each column created in the PDM automatically includes the name of the data element instantiated by the source attribute.
The same reference is created when a column is created by dragging and dropping a data element into the table definition.
The Source Data Element property is not displayed in the Column definition dialog, but can be printed in output reports.
(Read only in column definition dialog.)
Source Diagram Name
The Source Diagram Name property is the original name of a Physical Data Model diagram; it is included as a Key property for all objects belonging to the diagram (tables, columns, constraints, indexes, and so on). The Source Diagram Name does not change even if the diagram is renamed.
This property is not displayed in the Table definition dialog, but can be printed in output reports.
Table Name
The qualified name of any column includes the name of its table.
The Table Name property is not displayed in the Column definition dialog, but can be printed in output reports.