Pos Table Schema (pos)


Description

Totara positions

pos table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
appraisal_grp_pos.posid apprgrppos_pos2_fk R
auth_approved_request.positionid authapprrequ_pos2_fk R
auth_approved_request_snapshots.positionid Implied Constraint R
comp_record.positionid compreco_pos2_fk R
course_completions.positionid Implied Constraint R
feedback360_grp_pos.posid feedgrppos_pos2_fk R
gap_aspirational.positionid gapaspi_pos2_fk R
goal_grp_pos.posid goalgrppos_pos2_fk R
job_assignment.positionid jobassi_pos2_fk R
pos.parentid pos_par2_fk R
pos_competencies.positionid poscomp_pos2_fk R
pos_type_info_data.positionid postypeinfodata_pos2_fk R
prog_completion.positionid Implied Constraint R
prog_completion_history.positionid Implied Constraint R
reportbuilder_grp_pos_record.posid repogrpposreco_pos2_fk R
reportbuilder_grp_pos_user.posid repogrpposuser_pos2_fk R
shortname VARCHAR 100 √ null
idnumber VARCHAR 100 √ null
description LONGTEXT 2147483647 √ null
frameworkid BIGINT 19 null
pos_framework.id pos_fra2_fk R
path VARCHAR 255 √ null
visible TINYINT 3 null
timevalidfrom BIGINT 19 √ null
timevalidto BIGINT 19 √ null
timecreated BIGINT 19 null
timemodified BIGINT 19 null
usermodified BIGINT 19 null
fullname VARCHAR 1024 √ null
parentid BIGINT 19 null
pos.id pos_par2_fk R
depthlevel BIGINT 19 √ null
typeid BIGINT 19 0
pos_type.id pos_typ2_fk R
sortthread VARCHAR 255 √ null
totarasync BIT 1 0

Totara sync flag from totara_sync

Table contained -1 rows

pos table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
pos_fra_ix Performance Asc frameworkid
pos_par_ix Performance Asc parentid
pos_tot_ix Performance Asc totarasync
pos_typ_ix Performance Asc typeid

pos table relationships

Close relationships within degrees of separation