Facetoface Sessions Table Schema (facetoface_sessions)


Description

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

Close relationships within degrees of separation