Goal User Info Data Table Schema (goal_user_info_data)


Description

Stores personal custom field data related to goals

goal_user_info_data table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
goal_user_info_data_param.dataid goaluserinfodatapara_dat2_fk R
data LONGTEXT 2147483647 √ null
fieldid BIGINT 19 null
goal_user_info_field.id goaluserinfodata_fie2_fk R
goal_userid BIGINT 19 null
goal_personal.id goaluserinfodata_goa2_fk R

Table contained -1 rows

goal_user_info_data table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
goaluserinfodata_fie_ix Performance Asc fieldid
goaluserinfodata_fiegoa_uix Must be unique Asc/Asc fieldid + goal_userid
goaluserinfodata_goa_ix Performance Asc goal_userid

goal_user_info_data table relationships

Close relationships within degrees of separation