Domain Properties

To view or edit a domain's properties, double-click its Browser or list entry. The property sheet tabs and fields listed here are those available by default, before any customization of the interface by you or an administrator.

The General tab contains the following properties:

Property

Description

Name/Code/Comment

Identify the object. The name should clearly convey the object's purpose to non-technical users, while the code, which is used for generating code or scripts, may be abbreviated, and should not normally include spaces. You can optionally add a comment to provide more detailed information about the object. By default the code is generated from the name by applying the naming conventions specified in the model options. To decouple name-code synchronization, click to release the = button to the right of the Code field.

Stereotype

Extends the semantics of the object. You can enter a stereotype directly in this field, or add stereotypes to the list by specifying them in an extension file.

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

[where supported] 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

Keywords

Provide a way of loosely grouping objects through tagging. To enter multiple keywords, separate them with commas.

The following tabs are also available:
  • Standard Checks - contains checks which control the values permitted for the column/entity attribute (see Setting Data Profiling Constraints)

  • 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)).