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.

Published

17/08/2020 - 09:48

Last updated

01/03/2022 - 13:35
3
2