Database Definition
The Database Definition (.dbd or .db-schema) file, Tables shows the list of tables.
| Columns | Description |
|---|---|
| Type | Identifies the data type. For example, VARCHAR or SLONG. |
| Ext Type | Identifies the Extended Type of the field such as color, currency, percentage,
date, time, and where appropriate, the unit type. The Extended Type is specific to Trapeze applications and is not used or recognized by the database server itself. |
| Precision | Shows the length of the text string. |
| Display Width | Shows the width of the field or column as shown by default in the user
interface. In most cases, display width is hard-coded or set in translation files. |
| Caption | Identifies the name or heading of the field as shown by default in the user
interface. In most cases, captions are hard-coded or set in translation files. |
| Allow Nulls | If selected, no error occurs if no value has been entered or selected in the field when a query is run. |
| Identity | If selected, the system adds to the value in the field (typically, by one) when a query is run that contains the identity name of the field in the database. |
| No Audit | If selected, the field is not included in the History or Action Audit that you may have set for the table. |
| In Use | Identifies the tables where the field name is used. Note that fields used in multiple tables may serve a different purpose in each table. |
| Documentation | Explains the purpose of the table field and any other information that may be relevant for users or developers. |