0 rows


Assignment of a job to a user


Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_job_assignment_id_seq'::regclass)
app_appraisal_user_assignment.jobassignmentid Defined in XMLR
app_auth_approved_request.managerjaid Defined in XMLR
app_facetoface_signups.jobassignmentid Defined in XMLR
app_job_assignment.managerjaid Defined in XMLR
app_job_assignment.tempmanagerjaid Defined in XMLR
app_perform_subject_static_instance.job_assignment_id Defined in XMLR
app_perform_subject_static_instance.manager_job_assignment_id Defined in XMLR
userid int8 19 null Defined in XMLR
fullname text 2147483647 null
shortname varchar 100 null
idnumber varchar 100 ''::character varying
description text 2147483647 null
startdate int8 19 null
enddate int8 19 null
timecreated int8 19 null
timemodified int8 19 null
usermodified int8 19 null Defined in XMLR
positionid int8 19 null Defined in XMLR
positionassignmentdate int8 19 null
organisationid int8 19 null Defined in XMLR
managerjaid int8 19 null Defined in XMLR
managerjapath varchar 1024 ''::character varying
tempmanagerjaid int8 19 null Defined in XMLR
tempmanagerexpirydate int8 19 null
appraiserid int8 19 null Defined in XMLR
sortorder int8 19 null
totarasync int2 5 0
synctimemodified int8 19 0


Constraint Name Type Sort Column(s)
app_jobassi_id_pk Primary key Asc id
app_jobassi_app_ix Performance Asc appraiserid
app_jobassi_man_ix Performance Asc managerjaid
app_jobassi_org_ix Performance Asc organisationid
app_jobassi_pos_ix Performance Asc positionid
app_jobassi_tem_ix Performance Asc tempmanagerjaid
app_jobassi_use2_ix Performance Asc usermodified
app_jobassi_use_ix Performance Asc userid
app_jobassi_useidn_uix Must be unique Asc/Asc userid + idnumber
app_jobassi_usesor_uix Must be unique Asc/Asc userid + sortorder