app_perform_subject_static_instance

0 rows


Description

Represents a single job assignment at the time of subject creation

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_perform_subject_static_instance_id_seq'::regclass)
subject_instance_id int8 19 null
app_perform_subject_instance.id Defined in XMLR
job_assignment_id int8 19 null
app_job_assignment.id Defined in XMLR
manager_job_assignment_id int8 19 √ null
app_job_assignment.id Defined in XMLR
position_id int8 19 √ null
app_pos.id Defined in XMLR
organisation_id int8 19 √ null
app_org.id Defined in XMLR
appraiser_id int8 19 √ null
app_user.id Defined in XMLR
created_at int8 19 null
updated_at int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
app_perfsubjstatinst_id_pk Primary key Asc id
app_perfsubjstatinst_app_ix Performance Asc appraiser_id
app_perfsubjstatinst_job_ix Performance Asc job_assignment_id
app_perfsubjstatinst_man_ix Performance Asc manager_job_assignment_id
app_perfsubjstatinst_org_ix Performance Asc organisation_id
app_perfsubjstatinst_pos_ix Performance Asc position_id
app_perfsubjstatinst_sub_ix Performance Asc subject_instance_id

Relationships

Close relationships within degrees of separation