Columns
The column definition in System Architect corresponds to a column in a database table. The following properties can be specified for a column:
•key status (PK component)
•nullity (null value allowed)
•uniqueness (candidate key)
•data type
•type qualifiers (length, precision)
•default value
•user data type (domain)
•check constraints, database comments, and other DBMS-specific column characteristics.
The properties of a column cannot be changed in the table in which it a foreign key.
See also
