Tables

< prefix >_collected_filter_rows

Contains the used patterns, sequences, tickets, and Event combinations, within the evaluation period.

Is used for the structure of "Selection filter".

(For historical reasons (SKR2) a separate column exists for data type)

<prefix>_tab_metadata

For storing meta data (key value)

e.g. the src schema (skr or skr_archive)

< prefix >_tab_collected_machine_data

Contains a state table over the evaluation period

(state machine)

< prefix >_tab_collected_chg_counts

Contains additional information as for example the number and duration of individual states in <…>_tab_collected_machine_data, to be able to decide if a state "was sectioned" by a filter or if it is completely displayed in the result after applying filters.