app_tool_monitor_subscriptions

0 rows


Description

Table to store user subscriptions to various rules

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_tool_monitor_subscriptions_id_seq'::regclass)
app_tool_monitor_history.sid Defined in XMLR
courseid int8 19 null
ruleid int8 19 null
app_tool_monitor_rules.id Defined in XMLR
cmid int8 19 null
userid int8 19 null
timecreated int8 19 null
lastnotificationsent int8 19 0
inactivedate int8 19 0

Indexes

Constraint Name Type Sort Column(s)
app_toolmonisubs_id_pk Primary key Asc id
app_toolmonisubs_couuse_ix Performance Asc/Asc courseid + userid
app_toolmonisubs_rul_ix Performance Asc ruleid

Relationships

Close relationships within degrees of separation