primarykey
nounUK /ˈpraɪməri kiː/
US /ˈpraɪmɛri kiː/
A special label that makes each row in a table different from all the others.
The student ID is the primarykey in the students table.
OTHER MEANINGS
2. A column or set of columns that uniquely identifies each record in a database table.
The database uses customer_id as the primarykey for the customers table.
3. A field that ensures no two rows share the same value and cannot be empty.
You cannot insert a new row without a primarykey value.
4. The main identifier used to link tables together in a relational database.
The orders table references the primarykey of the customers table.