maplog action action name : varchar(100) action_id : integer campaign campaign name : text description : text from_time : timestamp with time zone to_time : timestamp with time zone id : integer driver driver name : varchar(100) driver_id : integer driver_to_action driver_to_action driver_id : integer action_id : integer unit_id : bigint from_time : timestamp with time zone to_time : timestamp with time zone id : integer driver_to_action->action action_id driver_to_action->driver driver_id unit unit imei : varchar(20) description : text is_mobile : boolean unit_type_id : varchar(2) name : varchar(100) unit_id : bigint driver_to_action->unit unit_id obs_telemetry obs_telemetry time_stamp : timestamp with time zone unit_id : bigint observed_values : jsonb time_received : timestamp with time zone the_geom : geometry speed : integer id : bigint obs_telemetry->unit unit_id phenomenon phenomenon name : text uom : varchar(30) uom_link : text id : integer sensor sensor name : varchar(100) type : text io_id : integer phenomenon_id : integer description : text sensor_id : bigint sensor->phenomenon phenomenon_id:id system_user system_user name : text user_id : integer unit_type unit_type name : varchar(20) description : text unit_type_id : varchar(2) unit->unit_type unit_type_id unit_to_campaign unit_to_campaign campaign_id : integer unit_id : bigint from_time : timestamp with time zone to_time : timestamp with time zone id : integer unit_to_campaign->campaign campaign_id:id unit_to_campaign->unit unit_id unit_to_sensor unit_to_sensor sensor_id : bigint unit_id : bigint unit_to_sensor->sensor sensor_id unit_to_sensor->unit unit_id user_to_campaign user_to_campaign user_id : integer campaign_id : integer user_to_campaign->campaign campaign_id:id user_to_campaign->system_user user_id