"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), klucz główny [masculine] (Polish), klucz podstawowy [masculine] (Polish), 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

{
  "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": "other",
          "name": "Entries with translation boxes",
          "parents": [],
          "source": "w"
        },
        {
          "kind": "other",
          "name": "Pages with 1 entry",
          "parents": [],
          "source": "w"
        },
        {
          "kind": "other",
          "name": "Pages with entries",
          "parents": [],
          "source": "w"
        },
        {
          "kind": "other",
          "name": "Terms with Czech translations",
          "parents": [],
          "source": "w"
        },
        {
          "kind": "other",
          "name": "Terms with Esperanto translations",
          "parents": [],
          "source": "w"
        },
        {
          "kind": "other",
          "name": "Terms with Finnish translations",
          "parents": [],
          "source": "w"
        },
        {
          "kind": "other",
          "name": "Terms with French translations",
          "parents": [],
          "source": "w"
        },
        {
          "kind": "other",
          "name": "Terms with German translations",
          "parents": [],
          "source": "w"
        },
        {
          "kind": "other",
          "name": "Terms with Greek translations",
          "parents": [],
          "source": "w"
        },
        {
          "kind": "other",
          "name": "Terms with Hungarian translations",
          "parents": [],
          "source": "w"
        },
        {
          "kind": "other",
          "name": "Terms with Japanese translations",
          "parents": [],
          "source": "w"
        },
        {
          "kind": "other",
          "name": "Terms with Mandarin translations",
          "parents": [],
          "source": "w"
        },
        {
          "kind": "other",
          "name": "Terms with Polish translations",
          "parents": [],
          "source": "w"
        },
        {
          "kind": "other",
          "name": "Terms with Romanian translations",
          "parents": [],
          "source": "w"
        },
        {
          "kind": "other",
          "name": "Terms with Russian translations",
          "parents": [],
          "source": "w"
        },
        {
          "kind": "other",
          "name": "Terms with Serbo-Croatian translations",
          "parents": [],
          "source": "w"
        },
        {
          "kind": "other",
          "name": "Terms with Swedish translations",
          "parents": [],
          "source": "w"
        },
        {
          "kind": "other",
          "name": "Terms with Turkish translations",
          "parents": [],
          "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": "pl",
          "lang": "Polish",
          "sense": "key in database table",
          "tags": [
            "masculine"
          ],
          "word": "klucz główny"
        },
        {
          "code": "pl",
          "lang": "Polish",
          "sense": "key in database table",
          "tags": [
            "masculine"
          ],
          "word": "klucz podstawowy"
        },
        {
          "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",
        "Entries with translation boxes",
        "Pages with 1 entry",
        "Pages with entries",
        "Requests for review of Esperanto translations",
        "Terms with Czech translations",
        "Terms with Esperanto translations",
        "Terms with Finnish translations",
        "Terms with French translations",
        "Terms with German translations",
        "Terms with Greek translations",
        "Terms with Hungarian translations",
        "Terms with Japanese translations",
        "Terms with Mandarin translations",
        "Terms with Polish translations",
        "Terms with Romanian translations",
        "Terms with Russian translations",
        "Terms with Serbo-Croatian translations",
        "Terms with Swedish translations",
        "Terms with Turkish 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": "pl",
      "lang": "Polish",
      "sense": "key in database table",
      "tags": [
        "masculine"
      ],
      "word": "klucz główny"
    },
    {
      "code": "pl",
      "lang": "Polish",
      "sense": "key in database table",
      "tags": [
        "masculine"
      ],
      "word": "klucz podstawowy"
    },
    {
      "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"
}

Download raw JSONL data for primary key meaning in English (4.2kB)


This page is a part of the kaikki.org machine-readable English dictionary. This dictionary is based on structured data extracted on 2024-12-15 from the enwiktionary dump dated 2024-12-04 using wiktextract (8a39820 and 4401a4c). 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.