"candidate key" meaning in English

See candidate key in All languages combined, or Wiktionary

Noun

Forms: candidate keys [plural]
Head templates: {{en-noun}} candidate key (plural candidate keys)
  1. (computing, databases) In the design of a database table, a column (or an irreducible group of them) able to identify every row of the table. One of the candidate keys (abbreviated CKs) will be the primary key. Wikipedia link: candidate key Categories (topical): Computing, Databases Related terms: business key, foreign key, natural key, primary key, first normal form
    Sense id: en-candidate_key-en-noun-qIUmmEVO Categories (other): English entries with incorrect language header Topics: computing, databases, engineering, mathematics, natural-sciences, physical-sciences, sciences

Inflected forms

Alternative forms

Download JSON data for candidate key meaning in English (1.7kB)

{
  "forms": [
    {
      "form": "candidate keys",
      "tags": [
        "plural"
      ]
    }
  ],
  "head_templates": [
    {
      "args": {},
      "expansion": "candidate key (plural candidate 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, a column (or an irreducible group of them) able to identify every row of the table. One of the candidate keys (abbreviated CKs) will be the primary key."
      ],
      "id": "en-candidate_key-en-noun-qIUmmEVO",
      "links": [
        [
          "computing",
          "computing#Noun"
        ],
        [
          "database",
          "database"
        ],
        [
          "table",
          "table"
        ],
        [
          "column",
          "column"
        ],
        [
          "row",
          "row"
        ],
        [
          "CK",
          "CK"
        ],
        [
          "primary key",
          "primary key"
        ]
      ],
      "raw_glosses": [
        "(computing, databases) In the design of a database table, a column (or an irreducible group of them) able to identify every row of the table. One of the candidate keys (abbreviated CKs) will be the primary key."
      ],
      "related": [
        {
          "word": "business key"
        },
        {
          "word": "foreign key"
        },
        {
          "word": "natural key"
        },
        {
          "word": "primary key"
        },
        {
          "word": "first normal form"
        }
      ],
      "topics": [
        "computing",
        "databases",
        "engineering",
        "mathematics",
        "natural-sciences",
        "physical-sciences",
        "sciences"
      ],
      "wikipedia": [
        "candidate key"
      ]
    }
  ],
  "word": "candidate key"
}
{
  "forms": [
    {
      "form": "candidate keys",
      "tags": [
        "plural"
      ]
    }
  ],
  "head_templates": [
    {
      "args": {},
      "expansion": "candidate key (plural candidate keys)",
      "name": "en-noun"
    }
  ],
  "lang": "English",
  "lang_code": "en",
  "pos": "noun",
  "related": [
    {
      "word": "business key"
    },
    {
      "word": "foreign key"
    },
    {
      "word": "natural key"
    },
    {
      "word": "primary key"
    },
    {
      "word": "first normal form"
    }
  ],
  "senses": [
    {
      "categories": [
        "English countable nouns",
        "English entries with incorrect language header",
        "English lemmas",
        "English multiword terms",
        "English nouns",
        "en:Computing",
        "en:Databases"
      ],
      "glosses": [
        "In the design of a database table, a column (or an irreducible group of them) able to identify every row of the table. One of the candidate keys (abbreviated CKs) will be the primary key."
      ],
      "links": [
        [
          "computing",
          "computing#Noun"
        ],
        [
          "database",
          "database"
        ],
        [
          "table",
          "table"
        ],
        [
          "column",
          "column"
        ],
        [
          "row",
          "row"
        ],
        [
          "CK",
          "CK"
        ],
        [
          "primary key",
          "primary key"
        ]
      ],
      "raw_glosses": [
        "(computing, databases) In the design of a database table, a column (or an irreducible group of them) able to identify every row of the table. One of the candidate keys (abbreviated CKs) will be the primary key."
      ],
      "topics": [
        "computing",
        "databases",
        "engineering",
        "mathematics",
        "natural-sciences",
        "physical-sciences",
        "sciences"
      ],
      "wikipedia": [
        "candidate key"
      ]
    }
  ],
  "word": "candidate 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.