19.5.9. The connection_occurrences view

The view is defined as follows:

select
  channels._connection_channel_id as id,
  results.token,
  occurrences.start_time,
  occurrences.end_time,
  occurrences.screenshot
from channels,
     results,
     occurrences
where channels.id = results.channel_id
and results.id = occurrences.result_id;
Note

The structure of these database tables may change in future PSM versions.

ColumnTypeDescription
end_time integer

End time: Date when the channel was closed.

id text The unique id of the entry.
screenshot text The filename of the PNG screenshot (as stored on PSM) about the occurrence of the search token.
start_time integer

Start time: Date when the channel was started.

token text The search token visible on the screenshot.

Table 19.8. Columns of the connection_occurrences table