OUTPUT

In SignalSQL, the OUTPUT table serves as a centralized repository, consolidating all the output signals supported by the loaded modules. This table provides a unified view of the various output signals, making it convenient for users to access and manage the results generated by different modules within the SignalSQL environment.

CREATE TABLE OUTPUT (
    ID INT AUTO_INCREMENT PRIMARY KEY,  -- The id of this OUTPUT.
    Name VARCHAR(255),                  -- Symbolic name of this output signal
    Type CHAR(1),                       -- 'A' or 'D' for an analog or digital output
    Value double                        -- Desired value of this output
)

The ID column is generated dynamically and will vary between different restarts of SignalSQL. This can be used for queries but should no be stored by the application.

The Name column is generated by the module and will keep it’s value over time.

SignalSQL support two types of signals, analog and digital. An analog signal can contain any value that can be represented by a double floating point value. A digital signal can only have the values zero or non-zero.