Facetoface Notification Hist Table Schema (facetoface_notification_hist)


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