The results tables
The results tables contain historical data about sensors that are run by the Scheduler.
Most sensors create a new table to store their results. The name of the table is listed in the tk_result_table column in the ph_task table. The structure of the table is defined by the CREATE TABLE statement in the tk_create column of the ph_task table.
The built-in sensors automatically create results tables when they run that start with the prefix mon_.
Column | Type | Description |
---|---|---|
ID | integer | The iteration sequence number of the sensor. Must
be set to $DATA_SEQ_ID. Referenced from the run_task_seq column of the ph_run table. |
user columns | any | You can specify any types of columns to hold the information returned by a sensor. |