Chapter 3 Building Physical Diagrams
Each domain definition includes the following properties:
| Property | Description |
|---|---|
| Name | The name of the item which should be clear and meaningful, and should convey the item's purpose to non-technical users |
| Code | The technical name of the item used for generating code or scripts, which may be abbreviated, and should not generally include spaces |
| Comment | 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 | 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 | Form of the data corresponding to the domain, such as numeric, alphanumeric, Boolean, or others |
| Length | Maximum number of characters |
| Precision | Number of places after the decimal point, for data values that can take a decimal point |
| Mandatory | Domain values are mandatory for all columns 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 | (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 | Test Data profile assigned to the domain |
A domain definition can also include the following properties, which have associated values or information used by columns attached to the domain:
| Property | Description |
|---|---|
| Standard checks | Check parameters defined for the domain |
| Additional checks | Domain constraints or validation rules not defined by standard check parameters |
| Rules | Business rules attached to the domain |
| Copyright (C) 2005. Sybase Inc. All rights reserved. |
| |