Column Properties

Name

Specifies the name of the item, which should be clear and meaningful, and should convey the item's purpose to non-technical users

Code

Specifies the technical name of the object, which is used for generating code or scripts, which may be abbreviated, and should not generally include spaces

Comment

Specifies a descriptive label for the column

Stereotype

Sub-classification used to extend the semantics of an object without changing its structure; it can be predefined or user-defined

Table

Specifies the table which contains column

Data type

Specifies the form of the data corresponding to the column, such as numeric, alphanumeric, boolean, or others

Displayed

When selected, allows the display of the selected column in the table symbol

Length

Specifies the maximum length of the data type

Precision

Specifies the maximum number of places after the decimal point

Identity

When selected, indicates that the data is auto-incremented (not available for all DBMS)

Domain

Specifies the name of the associated domain. You can use the tools to the right of the list to create an object, browse the complete tree of available objects or view the properties of the currently selected object

Computed

When selected, designates that the column is computed from an expression using values from other columns in the table (not available for all DBMS)

Primary key

When selected, designates a column whose values uniquely identify a row in the table

Foreign key

When selected, designates a column that depends on and migrates from a primary key column in another table

Mandatory

When selected, indicates a column that must be assigned a not null value

With default

When selected, indicates if a default value is assigned to the column when a Null value is inserted (not available for all DBMS)