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 0 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