# SpokenTermLists: DeepL Spoken Term Lists
## Documentation
The term lists of the spoken terms collections. An update of entries replaces the whole list.
- Catalog: `DeepL`
- Schema: `Voice`
- Primary Keys: `spoken_terms_id, lang`
- Label: Spoken Term Lists
Can retrieve data and change data using insert, update and delete.
## Table Columns
The columns of the table `SpokenTermLists` 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` | `varchar2` | | ☐ | Write only: the terms, one per line, at most 300 characters in total. |
| `entry_count` | `int32` | | ☐ | The number of terms. |
| `lang` | `varchar2` | | ☑ | The language (ISO 639-1). |
| `spoken_terms_id` | `varchar2` | | ☐ | The id of the collection; empty on an insert which creates the collection with spoken_terms_name. |
| `spoken_terms_name` | `varchar2` | | ☐ | The name of the collection. |
## Foreign Keys
The values of these columns refer to a row of another table.
| Columns | Referenced Table | Referenced Columns | Guarantee |
|---|---|---|---|
| `spoken_terms_id` | [[Voice-SpokenTermCollections\|Voice.SpokenTermCollections]] | `spoken_terms_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 |
|---|---|---|
| [[Voice-SpokenTerms\|Voice.SpokenTerms]] | `spoken_terms_id`, `lang` | Declared by the connector, not enforced by the platform |