Facetoface Signup Info Data Table Schema (facetoface_signup_info_data)


Description

Stores custom field data related to user signups for events, this data is attached to signup table, not status

facetoface_signup_info_data table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
facetoface_signup_info_data_param.dataid facesigninfodatapara_dat2_fk R
data LONGTEXT 2147483647 √ null
fieldid BIGINT 19 null
facetoface_signup_info_field.id facesigninfodata_fie2_fk R
facetofacesignupid BIGINT 19 null
facetoface_signups.id facesigninfodata_fac2_fk R

WARNING - this points to signup id

Table contained -1 rows

facetoface_signup_info_data table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
facesigninfodata_fac_ix Performance Asc facetofacesignupid
facesigninfodata_fie_ix Performance Asc fieldid
facesigninfodata_fiefac_uix Must be unique Asc/Asc fieldid + facetofacesignupid

facetoface_signup_info_data table relationships

Close relationships within degrees of separation