Back | Forward

The data in the application database is organized logically into tables.

Some tables represent entities that correspond to something that the application manages or tracks. For example, there are tables for equipment units, parts, employees, and vendors. The equipment unit table tracks equipment number, equipment class, assigned department, description, manufacturer, and model.

Other tables define the relationships between different entities. Examples of relationships include the following:

• Parts that a vendor supplies

• Parts used on an equipment type

• Parts stocked at a location

Each table has a unique name. The first segment of the name denotes the type of entity or relationship represented in the table. Additional segments further describe or qualify the table's content. Each entity and relationship has one table named XXX_MAIN, which is the primary table for that entity type or relationship. For example, EQ_MAIN contains main (primary) information about equipment units. ACT_MAIN contains main (primary) information about accounts.

Each table consists of table items, which describe attributes or properties of the type of entity or relationship represented by the table.