Differences

This shows you the differences between two versions of the page.

--- contrib:bz10m_sensors_tables [2008/01/16 19:35] – created vrepsys
+++ contrib:bz10m_sensors_tables [2008/01/17 10:54] – vrepsys
@@ Line 3: / Line 3: @@
 == Import ==
-  imp user/pass file=/home/students/vrepsys/sensors-16-01-2007.dmp full=y
+  imp user/pass file=/data/temporal/bz10m_sensors-16-01-2007.dmp full=y
 Two tables will be imported: SENSORS and SENSORS_DATA
@@ Line 14: / Line 14: @@
 **SENSORS:**
-|SENSOR_ID|NUMBER(16)|
+|SENSOR_ID|NUMBER(16)| |
-|NAME|VARCHAR2(16) - name of the sensor|
+|NAME|VARCHAR2(16)|Name of the sensor|
 **SENSORS_DATA:**
-|SENSORS_DATA_ID|NUMBER(16)|
+|SENSORS_DATA_ID|NUMBER(16)| |
-|SENSOR_ID|NUMBER(16) - foreign key, references SENSORS table|
+|SENSOR_ID|NUMBER(16)|Foreign key, references SENSORS table|
-|LANE|NUMBER(16) - the number of the lane|
+|LANE|NUMBER(16)|The number of the lane|
-|TIME|TIMESTAMP - time of the flow (the data is colleted every half an hour)|
+|TIME|TIMESTAMP|Time of the flow (the data is colleted every half an hour)|
-|VEHICLE_TYPE|NUMBER(1) - 0 for light vehicle, 1 for heavy vehicle |
+|VEHICLE_TYPE|NUMBER(1)|0 for light vehicle, 1 for heavy vehicle |
-|DIRECTION|NUMBER(1) - 0 for "out of the city", 1 for "into the city", 3 for unknown direction. NOTE: no directions known yet |
+|DIRECTION|NUMBER(1)|0 for "out of the city", 1 for "into the city", 3 for unknown direction. NOTE: no directions known yet |
-|FLOW|NUMBER(16) - number of cars passed in half an hour starting with TIME|
+|FLOW|NUMBER(16)|Number of cars that have passed the sensor in half an hour starting with TIME|