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 may not be changed in the table in which it a foreign key.
See also