candidate key

noun

candidate key

noun
1

Computing, Databases, Engineering, Mathematics, Natural sciences, Physical sciences, Sciences In the design of a database table, a column (or an irreducible group of them) able to identify every row of the table, having a unique value or set of values in each row. One of the candidate keys (abbreviated CKs) will be the primary key.

Related terms
business key, foreign key, natural key, primary key, first normal form

Entry derived from the Wiktionary, under licence CC BY-SA 4.0 — list of authors.