Facetoface Session Info Data Table Schema (facetoface_session_info_data)


Description

Stores custom field data related to event, these fields describe event details

facetoface_session_info_data table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
facetoface_session_info_data_param.dataid facesessinfodatapara_dat3_fk R
data LONGTEXT 2147483647 √ null
fieldid BIGINT 19 null
facetoface_session_info_field.id facesessinfodata_fie3_fk R
facetofacesessionid BIGINT 19 null
facetoface_sessions.id facesessinfodata_fac3_fk R

Table contained -1 rows

facetoface_session_info_data table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
facesessinfodata_fac_ix Performance Asc facetofacesessionid
facesessinfodata_fie_ix Performance Asc fieldid
facesessinfodata_fiefac_uix Must be unique Asc/Asc fieldid + facetofacesessionid

facetoface_session_info_data table relationships

Close relationships within degrees of separation