tool_monitor_history

0 rows


Description

Table to store history of message notifications sent

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
sid BIGINT 19 null
tool_monitor_subscriptions.id toolmonihist_sid2_fkR

Subscription id

userid BIGINT 19 null
user.id Implied ConstraintR

User to whom this notification was sent

timesent BIGINT 19 null

Timestamp of when the message was sent.

Indexes

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

Relationships