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.
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 ), a variable indicates where you have to type a length or precision, as follows: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)).