"primary key" meaning in English

See primary key in All languages combined, or Wiktionary

Noun

Forms: primary keys [plural]
Head templates: {{en-noun}} primary key (plural primary keys)
  1. (computing, databases) In the design of a database table, the primary key (abbreviated PK) is selected among the non-empty set of candidate keys. The PK is a column (or an irreducible group of columns) able to identify every row of the table. Wikipedia link: primary key Categories (topical): Computing, Databases Related terms: candidate key, foreign key Translations (key in database table): 主鍵 (Chinese Mandarin), 主键 (zhǔjiàn) (Chinese Mandarin), 主碼 (Chinese Mandarin), 主码 (zhǔmǎ) (Chinese Mandarin), primární klíč [masculine] (Czech), pääavain (Finnish), clé primaire [feminine] (French), Primärschlüssel [masculine] (German), πρωτεύον κλειδί (protévon kleidí) [neuter] (Greek), elsődleges kulcs (Hungarian), 主キー (shu-kī) (Japanese), cheie primară (Romanian), перви́чный ключ (pervíčnyj ključ) [masculine] (Russian), примарни кључ [Cyrillic, masculine] (Serbo-Croatian), primarni ključ [Roman, masculine] (Serbo-Croatian), primärnyckel [common-gender] (Swedish), birincil anahtar (Turkish)

Inflected forms

Alternative forms

Download JSON data for primary key meaning in English (3.7kB)

{
  "forms": [
    {
      "form": "primary keys",
      "tags": [
        "plural"
      ]
    }
  ],
  "head_templates": [
    {
      "args": {},
      "expansion": "primary key (plural primary keys)",
      "name": "en-noun"
    }
  ],
  "lang": "English",
  "lang_code": "en",
  "pos": "noun",
  "senses": [
    {
      "categories": [
        {
          "kind": "other",
          "name": "English entries with incorrect language header",
          "parents": [
            "Entries with incorrect language header",
            "Entry maintenance"
          ],
          "source": "w"
        },
        {
          "kind": "topical",
          "langcode": "en",
          "name": "Computing",
          "orig": "en:Computing",
          "parents": [
            "Technology",
            "All topics",
            "Fundamental"
          ],
          "source": "w"
        },
        {
          "kind": "topical",
          "langcode": "en",
          "name": "Databases",
          "orig": "en:Databases",
          "parents": [
            "Computing",
            "Technology",
            "All topics",
            "Fundamental"
          ],
          "source": "w"
        }
      ],
      "glosses": [
        "In the design of a database table, the primary key (abbreviated PK) is selected among the non-empty set of candidate keys. The PK is a column (or an irreducible group of columns) able to identify every row of the table."
      ],
      "id": "en-primary_key-en-noun-j3Naavvy",
      "links": [
        [
          "computing",
          "computing#Noun"
        ],
        [
          "database",
          "database"
        ],
        [
          "table",
          "table"
        ],
        [
          "PK",
          "PK"
        ],
        [
          "candidate key",
          "candidate key"
        ],
        [
          "column",
          "column"
        ],
        [
          "irreducible",
          "irreducible"
        ],
        [
          "row",
          "row"
        ]
      ],
      "raw_glosses": [
        "(computing, databases) In the design of a database table, the primary key (abbreviated PK) is selected among the non-empty set of candidate keys. The PK is a column (or an irreducible group of columns) able to identify every row of the table."
      ],
      "related": [
        {
          "word": "candidate key"
        },
        {
          "word": "foreign key"
        }
      ],
      "topics": [
        "computing",
        "databases",
        "engineering",
        "mathematics",
        "natural-sciences",
        "physical-sciences",
        "sciences"
      ],
      "translations": [
        {
          "code": "cmn",
          "lang": "Chinese Mandarin",
          "sense": "key in database table",
          "word": "主鍵"
        },
        {
          "code": "cmn",
          "lang": "Chinese Mandarin",
          "roman": "zhǔjiàn",
          "sense": "key in database table",
          "word": "主键"
        },
        {
          "code": "cmn",
          "lang": "Chinese Mandarin",
          "sense": "key in database table",
          "word": "主碼"
        },
        {
          "code": "cmn",
          "lang": "Chinese Mandarin",
          "roman": "zhǔmǎ",
          "sense": "key in database table",
          "word": "主码"
        },
        {
          "code": "cs",
          "lang": "Czech",
          "sense": "key in database table",
          "tags": [
            "masculine"
          ],
          "word": "primární klíč"
        },
        {
          "code": "fi",
          "lang": "Finnish",
          "sense": "key in database table",
          "word": "pääavain"
        },
        {
          "code": "fr",
          "lang": "French",
          "sense": "key in database table",
          "tags": [
            "feminine"
          ],
          "word": "clé primaire"
        },
        {
          "code": "de",
          "lang": "German",
          "sense": "key in database table",
          "tags": [
            "masculine"
          ],
          "word": "Primärschlüssel"
        },
        {
          "code": "el",
          "lang": "Greek",
          "roman": "protévon kleidí",
          "sense": "key in database table",
          "tags": [
            "neuter"
          ],
          "word": "πρωτεύον κλειδί"
        },
        {
          "code": "hu",
          "lang": "Hungarian",
          "sense": "key in database table",
          "word": "elsődleges kulcs"
        },
        {
          "code": "ja",
          "lang": "Japanese",
          "roman": "shu-kī",
          "sense": "key in database table",
          "word": "主キー"
        },
        {
          "code": "ro",
          "lang": "Romanian",
          "sense": "key in database table",
          "word": "cheie primară"
        },
        {
          "code": "ru",
          "lang": "Russian",
          "roman": "pervíčnyj ključ",
          "sense": "key in database table",
          "tags": [
            "masculine"
          ],
          "word": "перви́чный ключ"
        },
        {
          "code": "sh",
          "lang": "Serbo-Croatian",
          "sense": "key in database table",
          "tags": [
            "Cyrillic",
            "masculine"
          ],
          "word": "примарни кључ"
        },
        {
          "code": "sh",
          "lang": "Serbo-Croatian",
          "sense": "key in database table",
          "tags": [
            "Roman",
            "masculine"
          ],
          "word": "primarni ključ"
        },
        {
          "code": "sv",
          "lang": "Swedish",
          "sense": "key in database table",
          "tags": [
            "common-gender"
          ],
          "word": "primärnyckel"
        },
        {
          "code": "tr",
          "lang": "Turkish",
          "sense": "key in database table",
          "word": "birincil anahtar"
        }
      ],
      "wikipedia": [
        "primary key"
      ]
    }
  ],
  "word": "primary key"
}
{
  "forms": [
    {
      "form": "primary keys",
      "tags": [
        "plural"
      ]
    }
  ],
  "head_templates": [
    {
      "args": {},
      "expansion": "primary key (plural primary keys)",
      "name": "en-noun"
    }
  ],
  "lang": "English",
  "lang_code": "en",
  "pos": "noun",
  "related": [
    {
      "word": "candidate key"
    },
    {
      "word": "foreign key"
    }
  ],
  "senses": [
    {
      "categories": [
        "English countable nouns",
        "English entries with incorrect language header",
        "English lemmas",
        "English multiword terms",
        "English nouns",
        "Requests for review of Esperanto translations",
        "en:Computing",
        "en:Databases"
      ],
      "glosses": [
        "In the design of a database table, the primary key (abbreviated PK) is selected among the non-empty set of candidate keys. The PK is a column (or an irreducible group of columns) able to identify every row of the table."
      ],
      "links": [
        [
          "computing",
          "computing#Noun"
        ],
        [
          "database",
          "database"
        ],
        [
          "table",
          "table"
        ],
        [
          "PK",
          "PK"
        ],
        [
          "candidate key",
          "candidate key"
        ],
        [
          "column",
          "column"
        ],
        [
          "irreducible",
          "irreducible"
        ],
        [
          "row",
          "row"
        ]
      ],
      "raw_glosses": [
        "(computing, databases) In the design of a database table, the primary key (abbreviated PK) is selected among the non-empty set of candidate keys. The PK is a column (or an irreducible group of columns) able to identify every row of the table."
      ],
      "topics": [
        "computing",
        "databases",
        "engineering",
        "mathematics",
        "natural-sciences",
        "physical-sciences",
        "sciences"
      ],
      "wikipedia": [
        "primary key"
      ]
    }
  ],
  "translations": [
    {
      "code": "cmn",
      "lang": "Chinese Mandarin",
      "sense": "key in database table",
      "word": "主鍵"
    },
    {
      "code": "cmn",
      "lang": "Chinese Mandarin",
      "roman": "zhǔjiàn",
      "sense": "key in database table",
      "word": "主键"
    },
    {
      "code": "cmn",
      "lang": "Chinese Mandarin",
      "sense": "key in database table",
      "word": "主碼"
    },
    {
      "code": "cmn",
      "lang": "Chinese Mandarin",
      "roman": "zhǔmǎ",
      "sense": "key in database table",
      "word": "主码"
    },
    {
      "code": "cs",
      "lang": "Czech",
      "sense": "key in database table",
      "tags": [
        "masculine"
      ],
      "word": "primární klíč"
    },
    {
      "code": "fi",
      "lang": "Finnish",
      "sense": "key in database table",
      "word": "pääavain"
    },
    {
      "code": "fr",
      "lang": "French",
      "sense": "key in database table",
      "tags": [
        "feminine"
      ],
      "word": "clé primaire"
    },
    {
      "code": "de",
      "lang": "German",
      "sense": "key in database table",
      "tags": [
        "masculine"
      ],
      "word": "Primärschlüssel"
    },
    {
      "code": "el",
      "lang": "Greek",
      "roman": "protévon kleidí",
      "sense": "key in database table",
      "tags": [
        "neuter"
      ],
      "word": "πρωτεύον κλειδί"
    },
    {
      "code": "hu",
      "lang": "Hungarian",
      "sense": "key in database table",
      "word": "elsődleges kulcs"
    },
    {
      "code": "ja",
      "lang": "Japanese",
      "roman": "shu-kī",
      "sense": "key in database table",
      "word": "主キー"
    },
    {
      "code": "ro",
      "lang": "Romanian",
      "sense": "key in database table",
      "word": "cheie primară"
    },
    {
      "code": "ru",
      "lang": "Russian",
      "roman": "pervíčnyj ključ",
      "sense": "key in database table",
      "tags": [
        "masculine"
      ],
      "word": "перви́чный ключ"
    },
    {
      "code": "sh",
      "lang": "Serbo-Croatian",
      "sense": "key in database table",
      "tags": [
        "Cyrillic",
        "masculine"
      ],
      "word": "примарни кључ"
    },
    {
      "code": "sh",
      "lang": "Serbo-Croatian",
      "sense": "key in database table",
      "tags": [
        "Roman",
        "masculine"
      ],
      "word": "primarni ključ"
    },
    {
      "code": "sv",
      "lang": "Swedish",
      "sense": "key in database table",
      "tags": [
        "common-gender"
      ],
      "word": "primärnyckel"
    },
    {
      "code": "tr",
      "lang": "Turkish",
      "sense": "key in database table",
      "word": "birincil anahtar"
    }
  ],
  "word": "primary key"
}

This page is a part of the kaikki.org machine-readable English dictionary. This dictionary is based on structured data extracted on 2024-04-26 from the enwiktionary dump dated 2024-04-21 using wiktextract (93a6c53 and 21a9316). The data shown on this site has been post-processed and various details (e.g., extra categories) removed, some information disambiguated, and additional data merged from other sources. See the raw data download page for the unprocessed wiktextract data.

If you use this data in academic research, please cite Tatu Ylonen: Wiktextract: Wiktionary as Machine-Readable Structured Data, Proceedings of the 13th Conference on Language Resources and Evaluation (LREC), pp. 1317-1325, Marseille, 20-25 June 2022. Linking to the relevant page(s) under https://kaikki.org would also be greatly appreciated.