app_perform_goal_perform_status_change

0 rows


Description

Records changes to a performance activity’s goal

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_perform_goal_perform_status_change_id_seq'::regclass)
goal_id int8 19 null
app_perform_goal.id Defined in XML R
subject_user_id int8 19 √ null
app_user.id Defined in XML R
status varchar 255 '0'::character varying
current_value numeric 10,5 null
activity_id int8 19 null
app_perform.id Defined in XML R
subject_instance_id int8 19 null
app_perform_subject_instance.id Defined in XML R
status_changer_user_id int8 19 √ null
app_user.id Defined in XML R
status_changer_relationship_id int8 19 √ null
app_totara_core_relationship.id Defined in XML R
created_at int8 19 null

Indexes

Constraint Name Type Sort Column(s)
app_perfgoalperfstatchan_id_pk Primary key Asc id
app_perfgoalperfstatchan_ac_ix Performance Asc activity_id
app_perfgoalperfstatchan_go_ix Performance Asc goal_id
app_perfgoalperfstatchan_s2_ix Performance Asc subject_instance_id
app_perfgoalperfstatchan_s3_ix Performance Asc status_changer_relationship_id
app_perfgoalperfstatchan_st_ix Performance Asc status_changer_user_id
app_perfgoalperfstatchan_su_ix Performance Asc subject_user_id

Relationships

Close relationships within degrees of separation