app_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 bigserial 19 nextval('app_tool_monitor_history_id_seq'::regclass)
sid int8 19 null
app_tool_monitor_subscriptions.id Defined in XML R
userid int8 19 null
timesent int8 19 null

Indexes

Constraint Name Type Sort Column(s)
app_toolmonihist_id_pk Primary key Asc id
app_toolmonihist_sid_ix Performance Asc sid
app_toolmonihist_sidusetim_uix Must be unique Asc/Asc/Asc sid + userid + timesent

Relationships