Understanding Sun Master Index Processing

Sample Database Model

The diagrams on the following pages illustrate the table structure and relationships for a sample master index Oracle database designed for storing information about companies. The diagrams display attributes for each database column, such as the field name, data type, whether the field can be null, and primary keys. They also show directional relationships between tables and the keys by which the tables are related. This diagram is very similar to SQL Server, with the exception of a few column name changes and some different data types as noted in the tables above.

Diagram shows a sample database structure for
a master index application (along with the following two diagrams).Diagram shows a sample database structure for
a master index application (along with the previous and following
diagrams).Diagram shows a sample database structure for
a master index application (along with the previous two diagrams).