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 XMLR
app_goal_grp_cohort.goalid Defined in XMLR
app_goal_grp_org.goalid Defined in XMLR
app_goal_grp_pos.goalid Defined in XMLR
app_goal_record.goalid Defined in XMLR
app_goal_type_info_data.goalid Defined in XMLR
app_goal_user_assignment.goalid Defined in XMLR
app_goal_user_type_cohort.goalid Defined in XMLR
shortname varchar 100 null
description text 2147483647 null
idnumber varchar 100 null
frameworkid int8 19 null
app_goal_framework.id Defined in XMLR
path varchar 255 null
parentid int8 19 null
app_goal.id Defined in XMLR
visible int2 5 null
targetdate int8 19 null
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 XMLR
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_par2_ix Performance Asc parentid
app_goal_par_ix Performance Asc parentid
app_goal_typ_ix Performance Asc typeid

Relationships