app_goal

0 rows


Description

Totara goals

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_goal_id_seq'::regclass)
app_goal.parentid Defined in XML R
app_goal_grp_cohort.goalid Defined in XML R
app_goal_grp_org.goalid Defined in XML R
app_goal_grp_pos.goalid Defined in XML R
app_goal_perform_status.goal_id Defined in XML R
app_goal_record.goalid Defined in XML R
app_goal_type_info_data.goalid Defined in XML R
app_goal_user_assignment.goalid Defined in XML R
app_goal_user_type_cohort.goalid Defined in XML R
shortname varchar 100 √ null
description text 2147483647 √ null
idnumber varchar 100 √ null
frameworkid int8 19 null
app_goal_framework.id Defined in XML R
path varchar 255 √ null
parentid int8 19 null
app_goal.id Defined in XML R
visible int2 5 null
targetdate int8 19 0
proficiencyexpected int8 19 null
timecreated int8 19 null
timemodified int8 19 null
usermodified int8 19 null
fullname varchar 1024 √ null
depthlevel int8 19 √ null
typeid int8 19 0
app_goal_type.id Defined in XML R
sortthread varchar 255 √ null

Indexes

Constraint Name Type Sort Column(s)
app_goal_id_pk Primary key Asc id
app_goal_fra_ix Performance Asc frameworkid
app_goal_par_ix Performance Asc parentid
app_goal_typ_ix Performance Asc typeid

Relationships

Close relationships within degrees of separation