menues
Table name: menues
Contains/Role: This is a kind of “support table” for the event tables. Holds a more descriptive text for the menue_keys used in table call_events. If joined from the event tables, both service_num and menue_key should be used as join criteria, since databases holding data for more than one customer might have duplicates for the key alone. Outer join is recommended since all keys in use not necessary has a description defined in this table
| Column Name | Datatype | Description |
|---|---|---|
| service_num | Varchar(100) | |
| menue_key | nvarchar(100) | The key used in the call_event table. |
| descript | nvarchar(255) | Describes the key. |
| dte_updated | Datetime | When this record was added or last time updated * |
| dte_updated_utc | Datetime | When this record was added or last time updated, in UTC * |
| rec_id | INT | Primary key * |
* New columns added in v2.4.3.0