Column (dictionary item)

Model Parts, Diagrams, Dictionary Items, and Properties > Dictionary items > Column (dictionary item)

For automation interface information about a Column, see Column (automation interface).

A Column of a Database Table.

You can create a Column through the context menu of a Table, and through the Table Relationships Diagram.

You can use Storage Mapper to create Tables from Classes defined in the model. Storage Mapper creates a Column for each Attribute of a Class. For more information about Storage Mapper, see Storage mapping overview (Storage Mapper).

When used on a Table Relationships Diagram, a Column's notation is as follows:

In the Modeler panes, a short-cut symbol

on the Column's icon indicates that the item is a stub.

On a Table Relationships Diagram the View Options for a Table allow you to show or hide its Columns.

If you select the Proprietary\Columns folder in the Dictionary pane, the Contents pane displays the following information about each Column in the model: Data Type, Prime, Unique and Table.

The following sections provide information about how a Column is used in the model. For more information about a property, item, model part or diagram, click it.

Properties

In addition to the standard properties, a Column has these properties:

• Can Be Null

• Data Type

• Default Values

• Domain Values

• Foreign (Is Foreign through the automation interface)

• Precision

• Prime (Is Prime through the automation interface)

• Unique (Is Unique through the automation interface)

Owned by

Table

Owns

Comment

Constraint

Dependency — The Dependency is owned jointly by the Column and the other associated item. The access permissions you have to a Dependency are determined by the access permissions of the dependent item.