15.4 Data Types Report


15.4 Data Types Report

You can use the Types report to report on all aspects of the data types in your database model diagram.

Data Types Report “Selection Tab

You can choose from three data type categories: composite, user -defined, and built-in, as shown in Figure 15-15. If relevant, you can also include any referenced external types that are defined elsewhere. By default, your report sorts by the class of data type and then by type name . You can easily change this.

click to expand
Figure 15-15: Data Types Report “Selection tab.

Table 15-10 summarizes the meaning of these options.

Table 15-10: Data types report “selection tab meaning.

Selection

Meaning

Composite types

Types with a composite structure.

User defined types

Shows any user defined data types. With physical data type, Notes, and a summary of any related method.

Built in types

Predefined data types for the specific DBMS.

Include external types

External types are data types that you have referenced in your model, but that are defined in a different model.

Data Types Report “Attributes Tab

You can select attribute information, such as data type names , base data types, and derived data types, by using the Attributes tab shown in Figure 15-16.

click to expand
Figure 15-16: Data Types Report “Attributes tab.

Data Types Report ” Sort / Group Tab

The Sort/Group tab works similarly to the Sort/Group tab described in the Object Type report in Chapter 9. Please refer to the detailed description of the Sort/Group tab in the Object Type report in Chapter 9.

Data Types Report ”Header Tab

The header tab works in exactly the same way as the other headers. Please refer to the detailed description of the header tab in the Object Type report in Chapter 9.

Data Types Report ”Pagination Tab

The pagination tab works in exactly the same way as the other pagination tabs. Please refer to the detailed description of the pagination tab in the Object Type report in Chapter 9.

Data Types Report ”Bottom Row Buttons

The four buttons along the bottom of the window (Print , Preview, Export to RTF , and Close) work in exactly the same way as in all other reports . Please refer to the detailed description of the bottom row buttons in the Object Type report in Chapter 9.

Table 15-11: Data types report types attribute.

Attribute

Meaning

Show type

Creates a placeholder for each individual data type instance. Not for use on its own.

Type name

The data types reported here are the DBMS-specific physical data types.

Attributes

Shows the data type names and their physical types. You must also select at least "Show type" and "Type name" checkboxes to get anything on your report.

Derived types

Derived types.

Base type

Base type.

Notes

Notes for user defined types.

Type summary

Type summary.

Verbalization

Verbalization.

click to expand
Figure 15-17: Data Types Report “Sort/Group Tab.

Table 15-12: Data types report sort group.

Sort Key

Meaning

Class of Data Type

Sorts your report into the four classes shown on the selection tab in Figure 15-15.

Type Name

Sorts your report into alphabetical order of data type name.

Table 15-13: Data Types report-grouping.

Sort Key

Meaning

Class of Data Type

Groups your data types into the four classes shown in Figure 15-15. (e.g., If you sort by data type name and group by class of data type, your report will have four subsections with data types sorted alphabetically within each subsection).

Type Name

If you group by this sort key, then you will get one report page for each type of data type in your report. For example, if you select only built in types, you will get at least 24 pages in your report “one page for each of the 24 built in data types.