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

Close relationships within degrees of separation