Skip to main content
. 2015 Jan 23;15(2):2565–2592. doi: 10.3390/s150202565

Table 3.

Database table that stores sensor and sensor platform data collection orders.

ORDER_NUMBER [PK] Integer SENSOR_ID Text ORDER Integer SAMPLING Double Precision LOOP Integer ORDER_RECEIVE_DATE Datetime
1 sensor_id_1 o1 s1 l1 dt1
2 sensor_id_2 o2 s2 l2 dt2
3 sensor_id_3 o3 s3 l3 dt3
..
n sensor_id_n on sn ln 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 order is inserted. sensor_id_i (i =1, 2, 3, …, n) represents the sensor ID of ith order. (oi, si, li) ϵ {(0, 0, 0), (1, 12, 6), (1, 22, 3)} (i = 1, 2, 3, …, n). dti (i = 1, 2, 3, …, n) is the date time of reception of ith order in the format “YYYY-MM-DD HH-MM-SS” (e.g., “2014-02-13 13:53:18”).