# Technical Background
# Database Entries
The 4App Thesaurus comes and works with two new modules: Thesaurus and Thesaurus Entry. Each module gets its own table in the database:
thesaurus for all created thesauri:
- id
- name (unique)
- active (CEBoolean, default: false)
- assigned_Fields (CEVarcharList, syntax “modulename.fieldname”)
thesaurus_entry for all entries from all created thesauri:
- active (CEBoolean, default: true)
- thesaurus (CEId from table thesaurus)
- name (CEVarchar)
- synonyms (CEVarcharList)
- misspellings (CEVarcharList)
- pid (CEId self reference to parent term)
- uniqueKey (via thesaurus fields, name)
# Field Types
A thesaurus can be assigned to the following field types:
- CEVarchar
- CEVarcharList
- CEText
- CETextList
- CEEmail
- CEEmailList
# Thesaurus Query
As soon as a thesaurus is configured for a field, all its entries apply for each query, e.g. in the Global search. You do not have to do extra configuring for each search position.