Goal User Info Field Table Schema (goal_user_info_field)


Description

Stores the personal custom fields for each goal type

goal_user_info_field table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
goal_user_info_data.fieldid goaluserinfodata_fie2_fk R
shortname VARCHAR 100 null
typeid BIGINT 19 null
goal_user_type.id goaluserinfofiel_typ2_fk R
datatype VARCHAR 255 null
description LONGTEXT 2147483647 null
sortorder BIGINT 19 null
hidden TINYINT 3 null
locked TINYINT 3 null
required TINYINT 3 null
forceunique TINYINT 3 null
defaultdata LONGTEXT 2147483647 null
param1 LONGTEXT 2147483647 null
param2 LONGTEXT 2147483647 null
param3 LONGTEXT 2147483647 null
param4 LONGTEXT 2147483647 null
param5 LONGTEXT 2147483647 null
fullname VARCHAR 1024 null

Table contained -1 rows

goal_user_info_field table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
goaluserinfofiel_typ_ix Performance Asc typeid

goal_user_info_field table relationships