Keys
Overview of primary and reference keys in NIM data tables, their roles, and how to assign them.
Primary Keys
A primary aspect of a system's data model are its primary keys. Each of a system's Data tables can have zero or one columns designated as a primary key. For example, the key of an employees
table might be employee_id
.
A table's primary key column is its unique identifier column. Its rows should have unique values. NIM uses the primary key column to establish Intra-system relations and Relation items in Filters.
To get started, Assign primary keys to tables.
Reference Keys
Additionally within the system's data model are its reference keys. Each of a system's Data tables can have zero to many columns designated as a reference. For example, the key of an employees
table might be employee_other_id
.
A table's reference key column is an additional key column that can be used to relate other tables of date. Its rows should have unique values. NIM uses the reference key column to establish Intra-system relations and Relation items in Filters.
To get started, Assign reference keys to tables.