t2release29
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
app_tool_monitor_subscriptions
0
rows
Description
Table to store user subscriptions to various rules
Columns
Related columns
Constraint
Comments
Search:
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 XML
R
courseid
int8
19
null
ruleid
int8
19
null
app_tool_monitor_rules
.id
Defined in XML
R
cmid
int8
19
null
userid
int8
19
null
timecreated
int8
19
null
lastnotificationsent
int8
19
0
inactivedate
int8
19
0
Showing 1 to 8 of 8 entries
Previous
1
Next
Indexes
Search:
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
Showing 1 to 3 of 3 entries
Previous
1
Next
Relationships
Close relationships within degrees of separation
One
