# GlossaryDictionaries: DeepL Glossary Dictionaries ## Documentation The dictionaries of the glossaries, one per language pair. An update of entries replaces the whole dictionary. - Catalog: `DeepL` - Schema: `Glossaries` - Primary Keys: `glossary_id, source_lang, target_lang` - Label: Glossary Dictionaries Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `GlossaryDictionaries` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `entries_format` | `varchar2` | | ☐ | Write only: tsv (default) or csv. | | `entries` | `varchar2` | | ☐ | Write only: the entries, one per line, source and target separated by a tab (tsv) or a comma (csv). | | `entry_count` | `int64` | | ☐ | The number of entries. | | `glossary_id` | `varchar2` | | ☐ | The id of the glossary; empty on an insert which creates the glossary with glossary_name. | | `glossary_name` | `varchar2` | | ☐ | The name of the glossary. | | `source_lang` | `varchar2` | | ☑ | The source language, a root language such as en. | | `target_lang` | `varchar2` | | ☑ | The target language, a root language such as nl; serves every variant. | ## Foreign Keys The values of these columns refer to a row of another table. | Columns | Referenced Table | Referenced Columns | Guarantee | |---|---|---|---| | `glossary_id` | [[Glossaries-Glossaries\|Glossaries.Glossaries]] | `glossary_id` | Declared by the connector, not enforced by the platform | ## Referenced By The columns of these tables refer to a row of this table. | Table | Columns | Guarantee | |---|---|---| | [[Glossaries-GlossaryEntries\|Glossaries.GlossaryEntries]] | `glossary_id`, `source_lang`, `target_lang` | Declared by the connector, not enforced by the platform |