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:
Key | Description | Sample values |
---|---|---|
unit | The basic reporting unit of the organization | hotel, store, call agent |
customer | The industry term for the customer | customer, 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 |