Goal User Type Table Schema (goal_user_type)


Description

Table to store goal types for personal goals.

goal_user_type table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
goal_personal.typeid goalpers_typ2_fk R
goal_user_info_field.typeid goaluserinfofiel_typ2_fk R
shortname VARCHAR 100 √ null
description LONGTEXT 2147483647 √ null
timecreated BIGINT 19 null
timemodified BIGINT 19 null
usermodified BIGINT 19 null
fullname VARCHAR 1024 √ null
idnumber VARCHAR 100 √ null
audience TINYINT 3 null

Table contained -1 rows

goal_user_type table indexes

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

goal_user_type table relationships

Close relationships within degrees of separation