Tool Monitor History Table Schema (tool_monitor_history)


Table to store history of message notifications sent

tool_monitor_history table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
sid BIGINT 19 null toolmonihist_sid2_fk R

Subscription id

userid BIGINT 19 null Implied Constraint R

User to whom this notification was sent

timesent BIGINT 19 null

Timestamp of when the message was sent.

Table contained -1 rows

tool_monitor_history table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
toolmonihist_sid_ix Performance Asc sid
toolmonihist_sidusetim_uix Must be unique Asc/Asc/Asc sid + userid + timesent

tool_monitor_history table relationships