"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, 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

Inflected forms

Alternative forms

{
  "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": [],
          "source": "w"
        },
        {
          "kind": "other",
          "name": "Pages with 1 entry",
          "parents": [],
          "source": "w"
        },
        {
          "kind": "other",
          "name": "Pages with entries",
          "parents": [],
          "source": "w"
        },
        {
          "kind": "other",
          "langcode": "en",
          "name": "Computing",
          "orig": "en:Computing",
          "parents": [],
          "source": "w"
        },
        {
          "kind": "other",
          "langcode": "en",
          "name": "Databases",
          "orig": "en:Databases",
          "parents": [],
          "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, having a unique value or set of values in each row. One of the candidate keys (abbreviated CKs) will be the primary key."
      ],
      "id": "en-candidate_key-en-noun-dcVf4eq5",
      "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, having a unique value or set of values in each row. 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"
      ]
    }
  ],
  "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",
        "Pages with 1 entry",
        "Pages with entries",
        "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, having a unique value or set of values in each row. 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, having a unique value or set of values in each row. One of the candidate keys (abbreviated CKs) will be the primary key."
      ],
      "topics": [
        "computing",
        "databases",
        "engineering",
        "mathematics",
        "natural-sciences",
        "physical-sciences",
        "sciences"
      ]
    }
  ],
  "word": "candidate key"
}

Download raw JSONL data for candidate key meaning in English (1.4kB)


This page is a part of the kaikki.org machine-readable English dictionary. This dictionary is based on structured data extracted on 2025-12-23 from the enwiktionary dump dated 2025-12-02 using wiktextract (6fdc867 and 9905b1f). 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.