Facetoface Table Schema (facetoface)


Each seminar activity has an entry here

facetoface table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
facetoface_notification.facetofaceid facenoti_fac2_fk R
facetoface_sessions.facetoface facesess_fac2_fk R
course BIGINT 19 0
course.id face_cou2_fk R
name VARCHAR 255 null
intro LONGTEXT 2147483647 null


introformat TINYINT 3 0


thirdparty VARCHAR 255 null

email address of a third party involved in this activity

thirdpartywaitlist BIT 0 0

Set to 1 if the third party wants to receive signups/cancellations about wait-listed sessions, 0 otherwise.

display BIGINT 19 0
timecreated BIGINT 19 0
timemodified BIGINT 19 0
shortname VARCHAR 32 null
showoncalendar BIT 0 1
usercalentry BIT 0 1
multiplesessions BIT 0 0
completionstatusrequired VARCHAR 255 null
managerreserve SMALLINT 5 0

Can managers make reservations/bookings on behalf of their team

maxmanagerreserves INT 10 1

How many reservations can each manager make

reservecanceldays INT 10 1

Number days before the session when all unconfirmed reservations are deleted

reservedays INT 10 2

Number days before the session when reservations are closed

declareinterest BIT 0 0

Allow users to declare interest in the facetoface

interestonlyiffull BIT 0 0

Only allow users to declare interest if all sessions are full

allowcancellationsdefault BIT 0 1
cancellationscutoffdefault BIGINT 19 86400
selectjobassignmentonsignup BIT 0 0

Users with multiple job assignments will select one on signup

forceselectjobassignment BIT 0 0

Error if no suitable job assignment is available when signing up

approvaltype BIGINT 19 0
approvalrole BIGINT 19 null
approvalterms LONGTEXT 2147483647 null
approvaladmins VARCHAR 255 null

Table contained -1 rows

facetoface table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
face_cou_ix Performance Asc course

facetoface table relationships