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 0 null
conditiontype BIGINT 19 null
scheduleunit BIT 0 null
scheduleamount BIT 0 null
scheduletime BIGINT 19 null
ccmanager BIT 0 0
managerprefix LONGTEXT 2147483647 null
title VARCHAR 255
body LONGTEXT 2147483647 null
booked BIT 0 0
waitlisted BIT 0 0
cancelled BIT 0 0
requested BIT 0 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 0 0
issent BIT 0 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_tit_ix Performance Asc title
facenoti_typ_ix Performance Asc type
facenoti_use_ix Performance Asc usermodified

facetoface_notification table relationships