app_goal_personal

0 rows


Description

Totara goals

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_goal_personal_id_seq'::regclass)
app_goal_perform_status.goal_personal_id Defined in XML R
app_goal_user_info_data.goal_userid Defined in XML R
userid int8 19 null
app_user.id Defined in XML R
name varchar 1024 √ null
description text 2147483647 √ null
targetdate int8 19 0
scaleid int8 19 √ null
app_goal_scale.id Defined in XML R
scalevalueid int8 19 √ null
app_goal_scale_values.id Defined in XML R
assigntype int2 5 null
timecreated int8 19 null
usercreated int8 19 null
timemodified int8 19 null
usermodified int8 19 null
deleted int2 5 0
typeid int8 19 √ 0
app_goal_user_type.id Defined in XML R
visible int2 5 1

Indexes

Constraint Name Type Sort Column(s)
app_goalpers_id_pk Primary key Asc id
app_goalpers_sca2_ix Performance Asc scalevalueid
app_goalpers_sca_ix Performance Asc scaleid
app_goalpers_typ_ix Performance Asc typeid
app_goalpers_use_ix Performance Asc userid

Relationships

Close relationships within degrees of separation