Create Columns

Columns are represented in the UML Data Modeling Profile as a stereotyped attribute; that is, an attribute with the Column stereotype.

Create columns in a table

Step

Action

See also

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:

Property

DBMS

Notes

Autonum

Oracle

MySQL

SQL Server

DB2

PostgreSQL

Sybase ASA

Sybase ASE

 

If you require a sequence, select the Autonum property, set the value to True and, if necessary, define the start number and increment

Zerofill

MySQL

 

 

Unsigned

MySQL

 

 

LengthType

Oracle

 

Character semantics

 

6

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

 

 

7

Click on the:

New button to define another column or
Close button to exit from the dialog

 

 

Options

Field/Option/Button

Description

See also

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:

A single column, each row in the table must have a unique value
Multiple columns, the combination of all columns involved must be unique in each record
 

 

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.
 

 

Notes

For MySQL, before creating columns you must first add ENUM and SET datatypes
 

Learn more

 

Learning Center topics

(Alt+F1) | Enterprise Architect | Database Engineering | Physical Data Model | Add Column