Tool Monitor History Table Schema (tool_monitor_history)


Description

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
tool_monitor_subscriptions.id toolmonihist_sid2_fk R

Subscription id
userid BIGINT 19 null
user.id 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

Close relationships within degrees of separation