Table 4.
Database table that stores execution statuses of sensor and sensor platform data collection orders.
| ORDER_NUMBER [PK] Integer | EXECUTE Text | TIME Datetime |
|---|---|---|
| 1 | e1 | dt1 |
| 2 | e2 | dt2 |
| 3 | e3 | dt3 |
| … | … | … |
| n | en | dtn |
i (i = 1, 2, 3, …, n) is the number of an order which is continuous and increases by 1 automatically each time a new record is inserted. ei ε {‘Y’, ‘N’} (i = 1, 2, 3, …, n) represents whether the ith order has been successfully executed, where “Y” represents “YES” and “N” represents “NO.” dti (i = 1, 2, 3, …, n) is the date and time when the execution status of ith order was changed, in the format “YYYY-MM-DD HH-MM-SS” (e.g., “2013-02-13 13:53:18”).