app_job_assignment

0 rows


Description

Assignment of a job to a user

Columns

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
app_user.id 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
app_user.id Defined in XMLR
positionid int8 19 √ null
app_pos.id Defined in XMLR
positionassignmentdate int8 19 null
organisationid int8 19 √ null
app_org.id Defined in XMLR
managerjaid int8 19 √ null
app_job_assignment.id Defined in XMLR
managerjapath varchar 1024 ''::character varying
tempmanagerjaid int8 19 √ null
app_job_assignment.id Defined in XMLR
tempmanagerexpirydate int8 19 √ null
appraiserid int8 19 √ null
app_user.id Defined in XMLR
sortorder int8 19 null
totarasync int2 5 0
synctimemodified int8 19 0

Indexes

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

Relationships

Close relationships within degrees of separation