Job Assignment Table Schema (job_assignment)


Description

Assignment of a job to a user

job_assignment table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
appraisal_user_assignment.jobassignmentid appruserassi_job2_fk R
auth_approved_request.managerjaid authapprrequ_man2_fk R
facetoface_signups.jobassignmentid facesign_job2_fk R
job_assignment.managerjaid jobassi_man2_fk R
job_assignment.tempmanagerjaid jobassi_tem2_fk R
userid BIGINT 19 null
user.id jobassi_use3_fk R

The ID of the user this job assignment belongs to
fullname LONGTEXT 2147483647 √ null

Null is allowed and will be displayed using a default string (which includes idnumber).
shortname VARCHAR 100 √ null
idnumber VARCHAR 100

Unique within each user's set of job assignments, required for all job assignments.
description LONGTEXT 2147483647 √ null
startdate BIGINT 19 √ null
enddate BIGINT 19 √ null
timecreated BIGINT 19 null
timemodified BIGINT 19 null
usermodified BIGINT 19 null
user.id jobassi_use4_fk R

The ID of the user who last modified this job assignment
positionid BIGINT 19 √ null
pos.id jobassi_pos2_fk R

The ID of the position the user holds as part of this job assignment
positionassignmentdate BIGINT 19 null
organisationid BIGINT 19 √ null
org.id jobassi_org2_fk R

The ID of the organisation the user belongs to as part of this job assignment
managerjaid BIGINT 19 √ null
job_assignment.id jobassi_man2_fk R

The job assignment ID belonging to the user who will act as manager for this job assignment
managerjapath VARCHAR 1024

The job assignment path up the tree until we find the top user
tempmanagerjaid BIGINT 19 √ null
job_assignment.id jobassi_tem2_fk R

The job assignment ID belonging to the user who will act as a temp manager
tempmanagerexpirydate BIGINT 19 √ null
appraiserid BIGINT 19 √ null
user.id jobassi_app2_fk R

The ID of the user who acts as appraiser for the user in this job assignment
sortorder BIGINT 19 null
totarasync BIT 1 0

Determines whether record can be updated via tool_totara_sync
synctimemodified BIGINT 19 0

Table contained -1 rows

job_assignment table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
jobassi_app_ix Performance Asc appraiserid
jobassi_man_ix Performance Asc managerjaid
jobassi_org_ix Performance Asc organisationid
jobassi_pos_ix Performance Asc positionid
jobassi_tem_ix Performance Asc tempmanagerjaid
jobassi_use2_ix Performance Asc usermodified
jobassi_use_ix Performance Asc userid
jobassi_useidn_uix Must be unique Asc/Asc userid + idnumber
jobassi_usesor_uix Must be unique Asc/Asc userid + sortorder

job_assignment table relationships

Close relationships within degrees of separation