app_pos

0 rows


Description

Totara positions

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_pos_id_seq'::regclass)
app_appraisal_grp_pos.posid Defined in XML R
app_auth_approved_request.positionid Defined in XML R
app_comp_record.positionid Defined in XML R
app_dp_plan_competency_value.positionid Defined in XML R
app_feedback360_grp_pos.posid Defined in XML R
app_gap_aspirational.positionid Defined in XML R
app_goal_grp_pos.posid Defined in XML R
app_job_assignment.positionid Defined in XML R
app_perform_subject_static_instance.position_id Defined in XML R
app_pos.parentid Defined in XML R
app_pos_competencies.positionid Defined in XML R
app_pos_type_info_data.positionid Defined in XML R
app_reportbuilder_grp_pos_record.posid Defined in XML R
app_reportbuilder_grp_pos_user.posid Defined in XML R
shortname varchar 100 √ null
idnumber varchar 100 √ null
description text 2147483647 √ null
frameworkid int8 19 null
app_pos_framework.id Defined in XML R
path varchar 255 √ null
visible int2 5 null
timevalidfrom int8 19 √ null
timevalidto int8 19 √ null
timecreated int8 19 null
timemodified int8 19 null
usermodified int8 19 null
fullname varchar 1024 √ null
parentid int8 19 null
app_pos.id Defined in XML R
depthlevel int8 19 √ null
typeid int8 19 0
app_pos_type.id Defined in XML R
sortthread varchar 255 √ null
totarasync int2 5 0

Indexes

Constraint Name Type Sort Column(s)
app_pos_id_pk Primary key Asc id
app_pos_fra_ix Performance Asc frameworkid
app_pos_par_ix Performance Asc parentid
app_pos_tot_ix Performance Asc totarasync
app_pos_typ_ix Performance Asc typeid

Relationships

Close relationships within degrees of separation