Chapter 4 Building Physical Diagrams
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:
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:
| Copyright (C) 2008. Sybase Inc. All rights reserved. |
| |