System Tables

CX Vizz system tables are used to configure the system and store logs.
The __EFMigrationsHistory table is not shown on this diagram. It is used to keep track of changes to the structure of the database when new versions of CX Vizz are released.
Each table is categorized by its purpose in the system. This will be one of the following:

• Logs: Tables that store logs of system activity (light blue).
• Configuration: Tables that store configuration settings for the system (light green).

Table Relationships

flowchart LR
    tbl_0["background_tasks"]
    tbl_1["command_action"]
    tbl_2["job_schedule"]
    tbl_3["job_schedule_action"]
    tbl_4["job_schedule_action_log"]
    tbl_5["job_schedule_log"]
    tbl_6["log"]
    tbl_7["savepoints"]
    tbl_8["stored_proc"]
    tbl_9["stored_proc_param"]
    tbl_3 -->|JobScheduleKey| tbl_2
    tbl_4 -->|JobScheduleActionKey| tbl_3
    tbl_4 -->|JobExecutionKey| tbl_5
    tbl_5 -->|JobScheduleKey| tbl_2
    tbl_9 -->|StoredProcName| tbl_8
    class tbl_0 configuration
    class tbl_1 configuration
    class tbl_2 configuration
    class tbl_3 configuration
    class tbl_4 log
    class tbl_5 log
    class tbl_6 log
    class tbl_7 configuration
    class tbl_8 configuration
    class tbl_9 configuration
    classDef metadata fill:#FFF3B0,stroke:#C9B35C,color:#000
    classDef historical fill:#F6C3B4,stroke:#C58A7A,color:#000
    classDef realtime fill:#BFE9F6,stroke:#7DBBD2,color:#000
    classDef recording fill:#1E2A5E,stroke:#10193A,color:#fff
    classDef aggregated fill:#F9D4A5,stroke:#C69A5F,color:#000
    classDef configuration fill:#CBECC7,stroke:#7FB57A,color:#000
    classDef log fill:#CDE6F5,stroke:#8AB6D6,color:#000
    classDef unknown fill:#EEEEEE,stroke:#B5B5B5,color:#000

Tables