19.5.15. The occurrences table

Note

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

ColumnTypeDescription
end_time integer The time when the token (keyword) disappears in the audit trail.
id integer The unique ID number of the entry.
result_id integer An ID identifying the occurrence of the token. This value is a reference to the id column of the results table.
screenshot text A hash of the screenshot used in the report. The actual screenshot is not stored in the database.
start_time integer The time when the token (keyword) appears in the audit trail.

Table 19.14. Columns of the occurrences table