OperationalData
This table will have to be created but it will be empty to start with and will be updated with data from microcontrollers. All data, valid or invalid will be stored here as an audit log but will not be used for any processing. Only valid data will be passed on to the Smart Contract where the processing happens.
Sample Data JSON
⚠️
While the data below is presented as an array of items, each item must be added individually to the table.
{
"orderID": 3,
"Microcontroller_data": [
{
"microcontroller_id": 1,
"sensor_data": [
{
"parameters": [
{
"name": "anpr",
"value": "MH02AB1111"
}
],
"sensor_id": 11
}
],
"timestamp": 1722260635273
},
{
"microcontroller_id": 1,
"sensor_data": [
{
"parameters": [
{
"name": "time",
"value": 1722260737
}
],
"sensor_id": 12
}
],
"timestamp": 1722260742
},
{
"microcontroller_id": 2,
"sensor_data": [
{
"parameters": [
{
"name": "weight",
"value": 270
}
],
"sensor_id": 21
}
],
"timestamp": 298
},
{
"microcontroller_id": 2,
"sensor_data": [
{
"parameters": [
{
"name": "temperature",
"value": 9
},
{
"name": "humidity",
"value": 48
}
],
"sensor_id": 22
}
],
"timestamp": 1722261123
},
{
"microcontroller_id": 2,
"sensor_data": [
{
"parameters": [
{
"name": "temperature",
"value": 10
},
{
"name": "humidity",
"value": 56
}
],
"sensor_id": 22
}
],
"timestamp": 1722261138
},
{
"microcontroller_id": 2,
"sensor_data": [
{
"parameters": [
{
"name": "temperature",
"value": 9
},
{
"name": "humidity",
"value": 46
}
],
"sensor_id": 22
}
],
"timestamp": 1722261153
},
{
"microcontroller_id": 3,
"sensor_data": [
{
"parameters": [
{
"name": "time",
"value": 1722261556
}
],
"sensor_id": 32
}
],
"timestamp": 1722261557
},
{
"microcontroller_id": 3,
"sensor_data": [
{
"parameters": [
{
"name": "anpr",
"value": "MH02AB1111"
}
],
"sensor_id": 31
}
],
"timestamp": 1722261589966
},
{
"microcontroller_id": 3,
"sensor_data": [
{
"parameters": [
{
"name": "weight",
"value": 260
}
],
"sensor_id": 33
}
],
"timestamp": 1722261637
}
]
}