Facetoface Signups Table Schema (facetoface_signups)


Description

User signups for events

facetoface_signups table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
facetoface_cancellation_info_data.facetofacecancellationid facecancinfodata_fac2_fk R
facetoface_signup_info_data.facetofacesignupid facesigninfodata_fac2_fk R
facetoface_signups_status.signupid facesignstat_sig2_fk R
sessionid BIGINT 19 null
facetoface_sessions.id facesign_ses2_fk R
userid BIGINT 19 null
user.id facesign_use2_fk R
discountcode LONGTEXT 2147483647 √ null
notificationtype BIGINT 19 null
archived BIT 1 0

Has this sign up been archived by the archive completion feature.
bookedby BIGINT 19 √ 0

The manager who reserved / booked this space
managerid BIGINT 19 √ null
user.id facesign_man2_fk R

Manager can be selected by user (if allowed), which will override other managers settings
jobassignmentid BIGINT 19 √ null
job_assignment.id facesign_job2_fk R

If required, the job the user is doing the training for

Table contained -1 rows

facetoface_signups table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
facesign_job_ix Performance Asc jobassignmentid
facesign_man_ix Performance Asc managerid
facesign_ses_ix Performance Asc sessionid
facesign_use_ix Performance Asc userid

facetoface_signups table relationships

Close relationships within degrees of separation