routetracker=# select * from r_waypoint;
 waypoint_id | tour_id |        time
-------------+---------+---------------------
           1 |       1 | 2005-04-05 23:23:56
           2 |       1 | 2005-04-05 23:24:01


routetracker=# select * from t_simple_sensors;
 sensor_id |       label        |              description
-----------+--------------------+---------------------------------------
         1 | Temperature sensor | This sensor gets actually temperature
         2 | Brightness sensor  | This sensor gets actually brightness
         3 | Humidity sensor    | This sensor gets actually humidity


routetracker=# select * from t_simple_sensor_values;
 value_id | value | sensor_id | waypoint_id
----------+-------+-----------+-------------
        1 |  23.5 |         1 |           1
        2 |   900 |         2 |           1
        3 |    34 |         3 |           1
        4 |  25.7 |         1 |           2
        5 |   958 |         2 |           2
        6 |    38 |         3 |           2


routetracker=# select * from t_locations;
 location_id | city | area | building | level | room | comment |     lon     |     lat     |  elev   | waypoint_id
-------------+------+------+----------+-------+------+---------+-------------+-------------+---------+-------------
           1 | HB   | Uni  | MZH      | 5     | 5380 | nix     | 45.70000000 | 95.30000000 | 21.5000 |           1
           2 | HB   | Uni  | MZH      | 5     | 5380 | gar nix | 45.20000000 | 95.50000000 | 21.3000 |           2


routetracker=# select * from t_tour;
 tour_id |              description
---------+---------------------------------------
       1 | About a walk through our project room


routetracker=# select * from t_person;
 person_id |  name  | first_name | login
-----------+--------+------------+--------
         1 | Warden | Tobias     | warden
         2 | Xing   | Xin        | xin
         3 | Pesina | Roman      | romanp


routetracker=# select * from t_keyword;
 keyword_id |                    label
------------+----------------------------------------------
          1 | Sommer2000, chinesische Suppe, Kaffee, Music


routetracker=# select * from r_tour_person;
 tour_id | person_id
---------+-----------
       1 |         1
       1 |         2
       1 |         3


routetracker=# select * from r_tour_keyword;
 tour_id | keyword_id
---------+------------
       1 |          1


routetracker=# select * from r_annotations;
 annotation_id | keyword_id | waypoint_id | image_id | sound_id |  comment
---------------+------------+-------------+----------+----------+------------
             1 |          1 |           1 |          |          | no comment