Create Columns

1

Right-click on the required Table in a diagram, and select the Attributes context menu option.

The Attributes dialog displays, showing the columns of the selected Table.

2

In the Name field, type the column name.

3

In the Data Type field, click on the drop-down arrow and select the data type (ensure the Table's target database is set first; this populates the Data Type drop-down list).

Click on the Save button.

Set the Database Type

Oracle Data Types

4

Complete the required optional fields, listed in the reference table below.

5

Click on the Column Properties button.

The Database Columns Properties dialog displays.

Supported column properties are identified below; it is assumed that you understand which data types these properties apply to:

6

Click on the OK button to return to the Attributes dialog, and then click on the Save button.

7

Click on the:

Primary Key

Indicates whether the column is the primary key for this table.

Primary Key

Not Null

Indicates whether empty values are forbidden for this column.

Participates in Unique

Indicates whether the column participates in any Unique constraints.

A Unique constraint can be applied to either a single column or multiple columns.  When a Unique constraint is applied to:

Initial

A value that can be used as a default value for this column, if required.

Access

Determines the column's scope (Private, Protected or Public).

The default value is Public.

Alias

An alternative name for the field for display and documentation purposes.

Notes

Additional information necessary to document the column.

You can format the text using the Notes toolbar at the top of the field.