This dialog box displays the properties of a table column, which is part of the Relational Models.
General
Name: Name of the column.
Long Name: Long name in the format: table-name.column-name
Engineer: Controls whether the column will be considered during reverse engineering operations. If this option is disabled, this column and its properties are not considered when the table is reverse engineered into the associated entity in the logical model.
Allow Nulls: Controls whether null values are allowed for the column. If this option is enabled, a non-null value is mandatory.
Table: Name of the table with which the column is associated.
Datatype: Enables you to specify a domain, logical type, distinct type, collection type, or structured type as the data type of the column. You can click the ellipsis (...) button to specify further details for the selected type.
Type: Manual, System, Derived, or Aggregate.
Formula Description: For a derived or aggregate type, the formula for the attribute.
Scope: For a structured type with Reference enabled, limits the scope by specifying the table in which the type is implemented.
Type Substitution: For a structured type with Reference disabled, or for a structured type applied to an entity, controls whether a substitutional structured type is generated in the DDL.
Default and Constraint
Constraint Name: Name of the constraint.
Uses Default: Controls whether the default value is used for this column.
Default Value: Default value for the column.
Use Domain Constraints: Controls whether the properties defined in Domains Administration for the associated domain are used. If this option is disabled, you can use the remaining fields to specify the database type for the constraint and the ranges or a list of values.
Constraint: Enables you to specify a constraint for one or more types of databases.
Ranges: Enables you to specify one or more value ranges for the column.
Value List: Enables you to specify a list of valid values for the column.
Permitted Subtypes
For a structured data type, lists all subtypes for the attribute, and lets you specify whether each is permitted for the attribute.
Comments in RDBMS
Comment text to be included in database objects that are generated based on this modeling object.
Comments, Notes, Measurements, Change Requests, Responsible Parties, Documents, Summary