Foreign keys
Running the add_keys function on a dataset adds the following foreign keys, if the tables are present:
| Source | Source_Key | Target | Target_Key |
|---|---|---|---|
| ExampleTable | Speaker_ID | speakers | |
| derivations | Process_ID | derivationalprocesses | |
| derivations | Root_ID | morphs | |
| derivations | Source_ID | stems | |
| derivations | Stempart_IDs | stemparts | |
| derivations | Target_ID | stems | |
| exampleparts | Example_ID | ExampleTable | |
| exampleparts | Parameter_ID | ParameterTable | |
| exampleparts | Wordform_ID | wordforms | |
| examples | Text_ID | texts | |
| formparts | Wordform_ID | wordforms | |
| inflectionalvalues | Category_ID | inflectionalcategories | |
| inflectionalvalues | Gloss_ID | glosses | |
| inflections | Form_ID | forms | |
| inflections | Stem_ID | stems | |
| inflections | Value_ID | inflectionalvalues | |
| inflections | Wordformpart_ID | wordformparts | |
| lexemes | Parameter_ID | ParameterTable | |
| morphemes | Part_Of_Speech | partsofspeech | |
| morphemes | Parameter_ID | ParameterTable | |
| morphemes | Language_ID | LanguageTable | |
| morphs | Language_ID | LanguageTable | |
| morphs | Morpheme_ID | morphemes | |
| morphs | Parameter_ID | ParameterTable | |
| morphs | Part_Of_Speech | partsofspeech | |
| stemparts | Gloss_ID | glosses | |
| stemparts | Morph_ID | morphs | |
| stemparts | Stem_ID | stems | |
| stems | Language_ID | LanguageTable | |
| stems | Part_Of_Speech | partsofspeech | |
| stems | Lexeme_ID | lexemes | |
| stems | Parameter_ID | ParameterTable | |
| wordformparts | Wordform_ID | wordforms | |
| wordformparts | Gloss_ID | glosses | |
| wordformparts | Morph_ID | morphs | |
| wordforms | Parameter_ID | ParameterTable | |
| wordforms | Stem_ID | stems | |
| wordforms | Part_Of_Speech | partsofspeech | |
| wordforms | Language_ID | LanguageTable | |
| wordformstems | Stem_ID | stems | |
| wordformstems | Wordform_ID | wordforms |