INPUT

In SignalSQL, the INPUT table serves as a centralized repository, consolidating all the input signals supported by the loaded modules. This table provides a unified view of the various input signals.

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

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 one.