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 XMLR
app_comp_record.positionid Defined in XMLR
app_feedback360_grp_pos.posid Defined in XMLR
app_goal_grp_pos.posid Defined in XMLR
app_pos.parentid Defined in XMLR
app_pos_assignment.positionid Defined in XMLR
app_pos_assignment_history.positionid Defined in XMLR
app_pos_competencies.positionid Defined in XMLR
app_pos_type_info_data.positionid Defined in XMLR
app_reportbuilder_grp_pos_record.posid Defined in XMLR
app_reportbuilder_grp_pos_user.posid Defined in XMLR
shortname varchar 100 √ null
idnumber varchar 100 √ null
description text 2147483647 √ null
frameworkid int8 19 null
app_pos_framework.id Defined in XMLR
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 XMLR
depthlevel int8 19 √ null
typeid int8 19 0
app_pos_type.id Defined in XMLR
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