"foreign key" meaning in English

See foreign key in All languages combined, or Wiktionary

Noun

Forms: foreign keys [plural]
Head templates: {{en-noun}} foreign key (plural foreign keys)
  1. (databases) A column (or group of columns) in a relational table that identifies another table, so that items in the two tables can be conceptually linked. Wikipedia link: foreign key Categories (topical): Databases Related terms: referential integrity, primary key Translations (column referencing another table): 外鍵 (Chinese Mandarin), 外键 (wàijiàn) (Chinese Mandarin), cizí klíč [masculine] (Czech), viiteavain (Finnish), clé étrangère [feminine] (French), Fremdschlüssel [masculine] (German), 外部キー (gaibu kī) (Japanese), شناسال (Persian), chave estrangeira [feminine] (Portuguese), cheie străină [feminine] (Romanian), вне́шний ключ (vnéšnij ključ) [masculine] (Russian), främmande nyckel [common-gender] (Swedish), yabancı anahtar (Turkish)

Inflected forms

Alternative forms

Download JSON data for foreign key meaning in English (3.1kB)

{
  "forms": [
    {
      "form": "foreign keys",
      "tags": [
        "plural"
      ]
    }
  ],
  "head_templates": [
    {
      "args": {},
      "expansion": "foreign key (plural foreign 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": "Japanese terms with redundant script codes",
          "parents": [
            "Terms with redundant script codes",
            "Entry maintenance"
          ],
          "source": "w"
        },
        {
          "kind": "topical",
          "langcode": "en",
          "name": "Databases",
          "orig": "en:Databases",
          "parents": [
            "Computing",
            "Technology",
            "All topics",
            "Fundamental"
          ],
          "source": "w"
        }
      ],
      "glosses": [
        "A column (or group of columns) in a relational table that identifies another table, so that items in the two tables can be conceptually linked."
      ],
      "id": "en-foreign_key-en-noun-AQKjHvlq",
      "links": [
        [
          "database",
          "database"
        ],
        [
          "column",
          "column"
        ],
        [
          "relational",
          "relational"
        ],
        [
          "table",
          "table"
        ],
        [
          "identifies",
          "identifies"
        ]
      ],
      "raw_glosses": [
        "(databases) A column (or group of columns) in a relational table that identifies another table, so that items in the two tables can be conceptually linked."
      ],
      "related": [
        {
          "word": "referential integrity"
        },
        {
          "word": "primary key"
        }
      ],
      "topics": [
        "computing",
        "databases",
        "engineering",
        "mathematics",
        "natural-sciences",
        "physical-sciences",
        "sciences"
      ],
      "translations": [
        {
          "code": "cmn",
          "lang": "Chinese Mandarin",
          "sense": "column referencing another table",
          "word": "外鍵"
        },
        {
          "code": "cmn",
          "lang": "Chinese Mandarin",
          "roman": "wàijiàn",
          "sense": "column referencing another table",
          "word": "外键"
        },
        {
          "code": "cs",
          "lang": "Czech",
          "sense": "column referencing another table",
          "tags": [
            "masculine"
          ],
          "word": "cizí klíč"
        },
        {
          "code": "fi",
          "lang": "Finnish",
          "sense": "column referencing another table",
          "word": "viiteavain"
        },
        {
          "code": "fr",
          "lang": "French",
          "sense": "column referencing another table",
          "tags": [
            "feminine"
          ],
          "word": "clé étrangère"
        },
        {
          "code": "de",
          "lang": "German",
          "sense": "column referencing another table",
          "tags": [
            "masculine"
          ],
          "word": "Fremdschlüssel"
        },
        {
          "code": "ja",
          "lang": "Japanese",
          "roman": "gaibu kī",
          "sense": "column referencing another table",
          "word": "外部キー"
        },
        {
          "code": "fa",
          "lang": "Persian",
          "sense": "column referencing another table",
          "word": "شناسال"
        },
        {
          "code": "pt",
          "lang": "Portuguese",
          "sense": "column referencing another table",
          "tags": [
            "feminine"
          ],
          "word": "chave estrangeira"
        },
        {
          "code": "ro",
          "lang": "Romanian",
          "sense": "column referencing another table",
          "tags": [
            "feminine"
          ],
          "word": "cheie străină"
        },
        {
          "code": "ru",
          "lang": "Russian",
          "roman": "vnéšnij ključ",
          "sense": "column referencing another table",
          "tags": [
            "masculine"
          ],
          "word": "вне́шний ключ"
        },
        {
          "code": "sv",
          "lang": "Swedish",
          "sense": "column referencing another table",
          "tags": [
            "common-gender"
          ],
          "word": "främmande nyckel"
        },
        {
          "code": "tr",
          "lang": "Turkish",
          "sense": "column referencing another table",
          "word": "yabancı anahtar"
        }
      ],
      "wikipedia": [
        "foreign key"
      ]
    }
  ],
  "word": "foreign key"
}
{
  "forms": [
    {
      "form": "foreign keys",
      "tags": [
        "plural"
      ]
    }
  ],
  "head_templates": [
    {
      "args": {},
      "expansion": "foreign key (plural foreign keys)",
      "name": "en-noun"
    }
  ],
  "lang": "English",
  "lang_code": "en",
  "pos": "noun",
  "related": [
    {
      "word": "referential integrity"
    },
    {
      "word": "primary key"
    }
  ],
  "senses": [
    {
      "categories": [
        "English countable nouns",
        "English entries with incorrect language header",
        "English lemmas",
        "English multiword terms",
        "English nouns",
        "Japanese terms with redundant script codes",
        "en:Databases"
      ],
      "glosses": [
        "A column (or group of columns) in a relational table that identifies another table, so that items in the two tables can be conceptually linked."
      ],
      "links": [
        [
          "database",
          "database"
        ],
        [
          "column",
          "column"
        ],
        [
          "relational",
          "relational"
        ],
        [
          "table",
          "table"
        ],
        [
          "identifies",
          "identifies"
        ]
      ],
      "raw_glosses": [
        "(databases) A column (or group of columns) in a relational table that identifies another table, so that items in the two tables can be conceptually linked."
      ],
      "topics": [
        "computing",
        "databases",
        "engineering",
        "mathematics",
        "natural-sciences",
        "physical-sciences",
        "sciences"
      ],
      "wikipedia": [
        "foreign key"
      ]
    }
  ],
  "translations": [
    {
      "code": "cmn",
      "lang": "Chinese Mandarin",
      "sense": "column referencing another table",
      "word": "外鍵"
    },
    {
      "code": "cmn",
      "lang": "Chinese Mandarin",
      "roman": "wàijiàn",
      "sense": "column referencing another table",
      "word": "外键"
    },
    {
      "code": "cs",
      "lang": "Czech",
      "sense": "column referencing another table",
      "tags": [
        "masculine"
      ],
      "word": "cizí klíč"
    },
    {
      "code": "fi",
      "lang": "Finnish",
      "sense": "column referencing another table",
      "word": "viiteavain"
    },
    {
      "code": "fr",
      "lang": "French",
      "sense": "column referencing another table",
      "tags": [
        "feminine"
      ],
      "word": "clé étrangère"
    },
    {
      "code": "de",
      "lang": "German",
      "sense": "column referencing another table",
      "tags": [
        "masculine"
      ],
      "word": "Fremdschlüssel"
    },
    {
      "code": "ja",
      "lang": "Japanese",
      "roman": "gaibu kī",
      "sense": "column referencing another table",
      "word": "外部キー"
    },
    {
      "code": "fa",
      "lang": "Persian",
      "sense": "column referencing another table",
      "word": "شناسال"
    },
    {
      "code": "pt",
      "lang": "Portuguese",
      "sense": "column referencing another table",
      "tags": [
        "feminine"
      ],
      "word": "chave estrangeira"
    },
    {
      "code": "ro",
      "lang": "Romanian",
      "sense": "column referencing another table",
      "tags": [
        "feminine"
      ],
      "word": "cheie străină"
    },
    {
      "code": "ru",
      "lang": "Russian",
      "roman": "vnéšnij ključ",
      "sense": "column referencing another table",
      "tags": [
        "masculine"
      ],
      "word": "вне́шний ключ"
    },
    {
      "code": "sv",
      "lang": "Swedish",
      "sense": "column referencing another table",
      "tags": [
        "common-gender"
      ],
      "word": "främmande nyckel"
    },
    {
      "code": "tr",
      "lang": "Turkish",
      "sense": "column referencing another table",
      "word": "yabancı anahtar"
    }
  ],
  "word": "foreign 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.