"foreign key" meaning in All languages combined

See foreign key on Wiktionary

Noun [English]

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 All languages combined (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 All languages combined dictionary. This dictionary is based on structured data extracted on 2024-05-10 from the enwiktionary dump dated 2024-05-02 using wiktextract (a644e18 and edd475d). 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.