app_facetoface_notification_hist

0 rows


Description

Notifications history (stores ical event information)

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_facetoface_notification_hist_id_seq'::regclass)
notificationid int8 19 null
app_facetoface_notification.id Defined in XMLR
sessionid int8 19 null
app_facetoface_sessions.id Defined in XMLR
userid int8 19 null
app_user.id Defined in XMLR
sessiondateid int8 19 null
app_facetoface_sessions_dates.id Defined in XMLR
ical_uid varchar 255 √ null
ical_method varchar 32 √ null
timecreated int8 19 null

Indexes

Constraint Name Type Sort Column(s)
app_facenotihist_id_pk Primary key Asc id
app_facenotihist_not_ix Performance Asc notificationid
app_facenotihist_ses2_ix Performance Asc sessiondateid
app_facenotihist_ses_ix Performance Asc sessionid
app_facenotihist_use_ix Performance Asc userid

Relationships

Close relationships within degrees of separation