Create Columns

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

How to

To create columns

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

 

 

Reference

Field

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.

 

 

Unique

Indicates whether it is forbidden for any two values of this column to be identical.

The unique stereotype applied to an index ensures that no two combinations of values across a set of columns can be identical.

 

 

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) | Database Engineering | Physical Data Model | Add Column