primary key

[ˈpraɪ.mer.i kiː]
nounpl: primary keys
chave primária
1. A database field or combination of fields that uniquely identifies each record in a table, ensuring no duplicate entries and serving as the main reference for relationships between tables.
The user ID serves as the primary key in the customers table.
O ID do usuário funciona como a chave primária na tabela de clientes.
2. The unique identifier attribute in a relational database that must contain unique values and cannot be null.
Every row in the database must have a primary key to maintain data integrity.
Cada linha no banco de dados deve ter uma chave primária para manter a integridade dos dados.
This is technical terminology primarily used in database design and software development. Both English and Portuguese versions are widely understood in Brazilian and Portuguese tech communities, though the English term 'primary key' is often retained in technical documentation and code comments even in Portuguese-speaking countries.
Synonyms / Sinônimos
unique identifierunique keycandidate keymain key
Antonyms / Antônimos
foreign keysecondary key

Regional Variations

General Brazilian Portuguese
chave primária
Standard term used in database contexts across Brazil
Portugal
chave primária
Same translation used in European Portuguese technical contexts
Technical communities
primary key (often kept in English)
Frequently used in English even in Portuguese-speaking technical environments

Related Words

databaseforeign keyindexrelational databasetableconstraintunique constraint

Related Idioms & Phrases

enforce a primary key constraint
set as primary key
composite primary key
Look up more words on Fala2Me
The free English-Portuguese dictionary with real Brazilian accents, NYC slang, conjugator and more
Open Fala2Me →