Logical Modeling › Domains and Data Modeling › Domains in the Physical Model

Domains in the Physical Model

A domain includes both logical and physical properties. When you work in a physical model, a domain can include any or all the properties that you can assign to an individual column, including physical name, comment, datatype, null option, default value, validation rule, and physical user-defined properties. For servers that provide native application development tools, you can also include server-side column display properties such as the column label.

The following pre-defined domains are available in every model:

• The <default> domain is the root domain in the physical hierarchy. The <default> domain is assigned automatically to all columns that have not been assigned a true domain. Properties defined by the domain include the default datatype and null option selected for the target server.
• The String, Number, Datetime, and Blob domains are children of the <default> domain. You can assign a domain to a column in the physical model to define a datatype for that column. Each of these child domains represents a single logical datatype in the logical model.

In a physical model, the datatype for String, Number, Datetime, and Blob are automatically assigned based on the default datatypes set for the target server selected. You can override the default datatype and any of the other properties (except names and parent domains) for these domains in the Domain Dictionary dialog.

More information:

Add a Domain in the Physical Edit Mode

Specify That a Domain Appears In the Physical Model Only

Change a Physical Domain Name

Add a User-Defined Datatype in a Physical Model

Domain Inheritance and Overrides

Specify Database-Specific Options For a Domain

Specify a Domain Comment in the Physical Model

Specify a Data Source For a Domain

Specify a Validation Rule and Default Value for a Domain