Facetoface Sessions Table Schema (facetoface_sessions)


Describes seminar events

facetoface_sessions table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
facetoface_notification_hist.sessionid facenotihist_ses3_fk R
facetoface_notification_sent.sessionid facenotisent_ses2_fk R
facetoface_session_info_data.facetofacesessionid facesessinfodata_fac3_fk R
facetoface_session_roles.sessionid facesessrole_ses2_fk R
facetoface_sessioncancel_info_data.facetofacesessioncancelid facesessinfodata_fac4_fk R
facetoface_sessions_dates.sessionid facesessdate_ses2_fk R
facetoface_signups.sessionid facesign_ses2_fk R
facetoface BIGINT 19 0
facetoface.id facesess_fac2_fk R

ID of the facetoface activity this session is for

capacity BIGINT 19 0

Number of students who can enroll in this session. A value of 0 means unlimited.

allowoverbook BIT 1 0

Flag to turn on waitlisting of signups over capacity.

waitlisteveryone BIT 1 0

Will everyone be added to the waiting list

details LONGTEXT 2147483647 null

Extra information about this session

normalcost VARCHAR 255 0

The normal (non-discounted) cost of the session

discountcost VARCHAR 255 0

Discounted cost of the event

allowcancellations BIT 1 1
cancellationcutoff BIGINT 19 86400

The number of seconds before the session start when the user is allowed to cancel

timecreated BIGINT 19 0
timemodified BIGINT 19 0
usermodified BIGINT 19 null
user.id facesess_use2_fk R
selfapproval BIT 1 0

Allow self approval

mincapacity BIGINT 19 0

The minimum number of people for this session to take place.

cutoff BIGINT 19 86400

The number of seconds before the session start by which the minimum capacity should be reached

sendcapacityemail BIT 1 0

Notification flag for minimum bookings capactiy email.

registrationtimestart BIGINT 19 0
registrationtimefinish BIGINT 19 0
cancelledstatus BIT 1 0

Session cancelled status

Table contained -1 rows

facetoface_sessions table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
facesess_fac_ix Performance Asc facetoface
facesess_use_ix Performance Asc usermodified

facetoface_sessions table relationships