Domain Properties

You can modify an object's properties from its property sheet. To open a domain property sheet, double-click its Browser entry in the Domains folder.

The General tab contains the following properties:

Property

Description

Name

Specifies the name of the item, which should be clear and meaningful, and should convey the item's purpose to non-technical users

Code

Specifies the technical name of the object, which is used for generating code or scripts, which may be abbreviated, and should not generally include spaces

Comment

Specifies a descriptive label for the domain

Stereotype

Sub-classification used to extend the semantics of an object without changing its structure; it can be predefined or user-defined

Owner

[PDM only] Specifies the name of domain owner. You choose an owner from a list of users. A domain can only have one owner at a time. This is normally the domain creator

Data type

Specifies the form of the data corresponding to the domain, such as numeric, alphanumeric, Boolean, or others. The <undefined> data type indicates a domain without a data type. If an <undefined> data type is present when you generate your database, it is replaced by the default data type for your database

Length

[where appropriate] Specifies the maximum number of characters. In the PhysDataType list of available data types (select Database > Edit current database > Script > DataType > PhysDataType), a variable indicates where you have to type a length or precision, as follows:


  • %n - length

  • %s - length with precision

  • %p - decimal precision

For example, if you are using Sybase Adaptive Server Anywhere and you choose the data type
char(%n)
, you can choose a length of ten by typing
char(10)
.

Precision

[where appropriate] Specifies the number of places after the decimal point, for data values that can take a decimal point

Mandatory

Specifies that domain values are mandatory for all columns/entity attributes using that domain

Identity

(For Adaptive Server Enterprise, MS SQL Server and those DBMS that support it). When selected, indicates that the data is auto-incremented for columns using that domain

With default

[PDM only] (For those DBMS that support it). When selected, indicates if a default value is assigned to a column using the domain, when a Null value is inserted

Profile

[PDM only] Specifies the test Data profile assigned to the domain

The following tabs are also available:


  • Standard Checks - contains checks which control the values permitted for the column/entity attribute (see Check Parameters (CDM/LDM/PDM))

  • Additional Checks - allows you to specify additional constraints (not defined by standard check parameters) for the column/entity attribute.

  • Rules - lists the business rules associated with the column/entity attribute (see Business Rules (CDM/LDM/PDM)).