Overview
Panorama stores information in a relational database. This relational database is made up of numerous tables that can be grouped into several general Table Types.A relational database "relates" tables to one another through key fields that tie tables together. The most common major table relationships are included in this file.
There are three basic types of relationships:
- One to One relationship, such as between dg_set and dg_status.
- One to Many relationship, such as between reject_set and reject_def.
- Many to Many relationship, such as between job_cur_base and job_cur_pvar. For a given family in job_cur_base there are
several records in job_cur_pvar that match. Since there are many job_cur_base records in a family, this is a many to many
relationship.