Facetoface Notification Hist Table Schema (facetoface_notification_hist)


Description

Notifications history (stores ical event information)

facetoface_notification_hist table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
notificationid BIGINT 19 null
facetoface_notification.id facenotihist_not2_fk R

FK of notification
sessionid BIGINT 19 null
facetoface_sessions.id facenotihist_ses3_fk R

FK of facetoface_sessions
userid BIGINT 19 null
user.id facenotihist_use2_fk R

FK of user
sessiondateid BIGINT 19 null
facetoface_sessions_dates.id facenotihist_ses4_fk R

FK of facetoface_sessions_dates
ical_uid VARCHAR 255 √ null

globally unique id of ical event
ical_method VARCHAR 32 √ null

ICAL method e.g. update, cancel etc.
timecreated BIGINT 19 null

timestamp of record creation

Table contained -1 rows

facetoface_notification_hist table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
facenotihist_not_ix Performance Asc notificationid
facenotihist_ses2_ix Performance Asc sessiondateid
facenotihist_ses_ix Performance Asc sessionid
facenotihist_use_ix Performance Asc userid

facetoface_notification_hist table relationships

Close relationships within degrees of separation