Tracker data are stored in tables, each of which contains several fields (or columns), for example, these simplified versions of the Items and Descriptions tables.
|item id||item #||description id|
|description id||description name|
The Tracker's tables and fields are listed in tables and fields.
The first field in every Tracker table (ITEM ID and DESCRIPTION ID in these examples) contains a value that uniquely identifies its row. Subsequent fields can contain data (like ITEM # or DESCRIPTION NAME) or references to other tables (like DESCRIPTION ID in the items table, which refers to DESCRIPTION ID in the Descriptions table). That reference is a relation.