"candidate key" meaning in All languages combined

See candidate key on Wiktionary

Noun [English]

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

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": [
            "Entries with incorrect language header",
            "Entry maintenance"
          ],
          "source": "w"
        },
        {
          "kind": "other",
          "name": "Pages with 1 entry",
          "parents": [],
          "source": "w"
        },
        {
          "kind": "other",
          "name": "Pages with entries",
          "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, 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",
        "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. 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"
}

Download raw JSONL data for candidate key meaning in All languages combined (1.4kB)


This page is a part of the kaikki.org machine-readable All languages combined dictionary. This dictionary is based on structured data extracted on 2024-12-01 from the enwiktionary dump dated 2024-11-21 using wiktextract (95d2be1 and 64224ec). 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.