Terminology table

Different businesses in different verticals will use different terms, and this should be reflected in the user interfaces. The Terminology table provides these terms for some of the important concepts, like the business units and the customers.

These are the valid keys for the terminology table:

KeyDescriptionSample values
unitThe basic reporting unit of the organizationhotel, store, call agent
customerThe industry term for the customercustomer, guest, client

All queries to the terminology table need to include a WHERE condition on the key, like

key='unit'

or

key in ('unit', 'customer')

Table description

DESCRIBE TABLE terminology
 key   | name  | encoding |
 key   | Key   | TEXT     |
 value | Value | TEXT     |

Sample query

SELECT key, value FROM terminology WHERE key in ('unit', 'customer')

Result

 key      | value    |
 unit     | property |
 customer | guest    |