Facetoface Sessioncancel Info Data Table Schema (facetoface_sessioncancel_info_data)


Description

Stores custom field data related to cancellation of the whole event

facetoface_sessioncancel_info_data table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
facetoface_sessioncancel_info_data_param.dataid facesessinfodatapara_dat4_fk R
data LONGTEXT 2147483647 √ null
fieldid BIGINT 19 null
facetoface_sessioncancel_info_field.id facesessinfodata_fie4_fk R
facetofacesessioncancelid BIGINT 19 null
facetoface_sessions.id facesessinfodata_fac4_fk R

WARNING - this points to session id

Table contained -1 rows

facetoface_sessioncancel_info_data table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
facesessinfodata_fac2_ix Performance Asc facetofacesessioncancelid
facesessinfodata_fie2_ix Performance Asc fieldid
facesessinfodata_fiefac2_uix Must be unique Asc/Asc fieldid + facetofacesessioncancelid

facetoface_sessioncancel_info_data table relationships

Close relationships within degrees of separation