# GlossaryEntries: DeepL Glossary Entries ## Documentation The entries of the dictionaries. Filter on glossary_id, source_lang and target_lang to read one dictionary in one request. Source terms differ by case; an insert of a source term already present is refused, an update changes its target. - Catalog: `DeepL` - Schema: `Glossaries` - Primary Keys: `glossary_id, source_lang, target_lang, source_text` - Label: Glossary Entries Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `GlossaryEntries` 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 | |---|:---:|---|:---:|---| | `glossary_id` | `varchar2` | | ☑ | The id of the glossary. | | `glossary_name` | `varchar2` | | ☐ | The name of the glossary. | | `ordinal` | `int32` | | ☑ | The position of the entry in the dictionary as DeepL returns it, starting at 1. | | `source_lang` | `varchar2` | | ☑ | The source language of the dictionary. | | `source_text` | `varchar2` | | ☑ | The source term. | | `target_lang` | `varchar2` | | ☑ | The target language of the dictionary. | | `target_text` | `varchar2` | | ☑ | The target term; equal to the source term for a term that is not to be translated. | ## 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 | | `glossary_id`, `source_lang`, `target_lang` | [[Glossaries-GlossaryDictionaries\|Glossaries.GlossaryDictionaries]] | `glossary_id`, `source_lang`, `target_lang` | Declared by the connector, not enforced by the platform |