SparkPlug Data

SparkPlug Data in the database

SparkPlug data is associated directly with the volunteer record.

In the schema, here are the key tables used to query against received data:

The data from these tables is used to populate the UI views in the volunteer section of ClinSpark.

Here you can see a UI showing current monitoring data alongside the SQL which displays the same results:

Here is the SQL shown in the above:

select ed.device, v.id as vol_id, edp.description as device_parm_description, vmd.id vmd_id,
       vmdp.value, vmd.monitoring_start, vmd.monitoring_stop, vmd.date_created from volunteer_monitoring_source vms
inner join volunteer_monitoring_data vmd on vms.id = vmd.volunteer_monitoring_source_id
inner join volunteer_monitoring_data_parameter vmdp on vmd.id = vmdp.volunteer_monitoring_data_id
inner join volunteer v on vms.volunteer_id = v.id
inner join edc_device ed on vms.edc_device_id = ed.id
inner join edc_device_parameter edp on vmdp.edc_device_parameter_id = edp.id
where v.id = 120 and ed.device = 'BioBeat'