Job Assignment Table Schema (job_assignment)


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 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 jobassi_use4_fk R

The ID of the user who last modified this job assignment

positionid BIGINT 19 null 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 jobassi_org2_fk R

The ID of the organisation the user belongs to as part of this job assignment

managerjaid BIGINT 19 null 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 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 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 0 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_id_uix Must be unique Asc id
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