Chapter 3 Building Physical Diagrams
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 item used for generating code or scripts, which may be abbreviated, and should not generally include spaces |
| Comment | Specifies a descriptive label for the table |
| Stereotype | Sub-classification used to extend the semantics of an object without changing its structure; it can be predefined or user-defined |
| Owner | Specifies the name of the table owner. You choose an owner from a list of users. A table can only have one owner at a time. This is normally the table creator |
| Number | Specifies the estimated number of records in the table in the physical database, which is used to estimate database size. This box is automatically populated during reverse engineering if you select the Statistics check box in the Reverse Engineering dialog box (see "Reverse Engineering from a Live Database" in the "Reverse Engineering a Database into a PDM" chapter).
You can enter your own value in this field, or refresh its statistics (along with those for all of the table's columns) at any time by right-clicking the table symbol or its entry in the Browser and selecting Update Statistics from the contextual menu. You can also update the statistics for all tables by selecting Tools→Update Statistics (see "Reverse Engineering Database Statistics" in the "Reverse Engineering a Database into a PDM" chapter). |
| Generate | Specifies that the table is generated in the database |
| Dimensional type | Specifies the multidimensional type of the table. You can choose between:
|
| Type | Specifies the type of the table. You can choose between:
|
| Copyright (C) 2007. Sybase Inc. All rights reserved. |
| |