Facetoface Notification Table Schema (facetoface_notification)


Description

Seminar notifications

facetoface_notification table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
facetoface_notification_hist.notificationid facenotihist_not2_fk R
facetoface_notification_sent.notificationid facenotisent_not2_fk R
type BIT 1 null
conditiontype BIGINT 19 √ null
scheduleunit BIT 1 √ null
scheduleamount BIT 1 √ null
scheduletime BIGINT 19 √ null
ccmanager BIT 1 0
managerprefix LONGTEXT 2147483647 √ null
title LONGTEXT 2147483647 null
body LONGTEXT 2147483647 null
booked BIT 1 0
waitlisted BIT 1 0
cancelled BIT 1 0
requested BIT 1 0
courseid BIGINT 19 null
course.id facenoti_cou2_fk R
facetofaceid BIGINT 19 null
facetoface.id facenoti_fac2_fk R
templateid BIGINT 19 0
status BIT 1 0
issent BIT 1 0
timemodified BIGINT 19 √ null
usermodified BIGINT 19 √ null
user.id facenoti_use2_fk R

Table contained -1 rows

facetoface_notification table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
facenoti_cou_ix Performance Asc courseid
facenoti_fac_ix Performance Asc facetofaceid
facenoti_iss_ix Performance Asc issent
facenoti_sta_ix Performance Asc status
facenoti_typ_ix Performance Asc type
facenoti_use_ix Performance Asc usermodified

facetoface_notification table relationships

Close relationships within degrees of separation