Table 3.
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”).