app_forum_discussion_subs

0 rows


Description

Users may choose to subscribe and unsubscribe from specific discussions.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_forum_discussion_subs_id_seq'::regclass)
forum int8 19 null
app_forum.id Defined in XMLR
userid int8 19 null
app_user.id Defined in XMLR
discussion int8 19 null
app_forum_discussions.id Defined in XMLR
preference int8 19 1

Indexes

Constraint Name Type Sort Column(s)
app_forudiscsubs_id_pk Primary key Asc id
app_forudiscsubs_dis_ix Performance Asc discussion
app_forudiscsubs_for_ix Performance Asc forum
app_forudiscsubs_use_ix Performance Asc userid
app_forudiscsubs_usedis_uix Must be unique Asc/Asc userid + discussion

Relationships