Parent Entity |
Child Entity |
Type |
Foreign Keys |
row_status_type |
work_order |
Non-Identifying |
rstat_type_code |
site_database |
work_order |
Identifying |
work_order_db_site,work_order_db_id |
work_manage_type |
work_order |
Non-Identifying |
wm_type_db_site,wm_type_db_id,wm_type_code |
agent |
work_order |
Non-Identifying |
by_agent_site,by_agent_id |
eng_unit_type |
work_order |
Non-Identifying |
int_eu_db_site,int_eu_db_id,int_eu_type_code |
agent |
work_order |
Non-Identifying |
from_sy_agent_site,from_sy_agent_id |
agent |
work_order |
Non-Identifying |
to_agent_site,to_agent_id |
site_database |
work_order |
Non-Identifying |
last_upd_db_site,last_upd_db_id |
priority_level_type |
work_order |
Non-Identifying |
priority_lev_db_site,priority_lev_db_id,priority_lev_type_code |
eng_study_entry |
work_order |
Non-Identifying |
eng_study_entry_db_site,eng_study_entry_db_id,eng_study_entry_id |
solution_package |
work_order |
Non-Identifying |
sol_pack_db_site,sol_pack_db_id,sol_pack_id |
work_task_type |
work_order |
Non-Identifying |
task_db_site,task_db_id,task_type_code |
work_order |
work_order_audit |
Identifying |
work_order_db_site,work_order_db_id,work_order_id |
work_order |
work_order_child |
Identifying |
work_order_db_site,work_order_db_id,work_order_id |
work_order |
work_order_child |
Identifying |
child_wo_db_site,child_wo_db_id,child_wo_id |
work_order |
work_order_chr_data |
Identifying |
work_order_db_site,work_order_db_id,work_order_id |
work_order |
work_order_num_data |
Identifying |
work_order_db_site,work_order_db_id,work_order_id |
work_order |
work_order_step |
Identifying |
work_order_db_site,work_order_db_id,work_order_id |
work_order |
as_completed_work |
Non-Identifying |
work_order_db_site,work_order_db_id,work_order_id |
work_order |
as_req_for_work |
Non-Identifying |
work_order_db_site,work_order_db_id,work_order_id |
work_order |
ol_completed_work |
Non-Identifying |
work_order_db_site,work_order_db_id,work_order_id |
work_order |
ol_req_for_work |
Non-Identifying |
work_order_db_site,work_order_db_id,work_order_id |
work_order |
sg_completed_work |
Non-Identifying |
work_order_db_site,work_order_db_id,work_order_id |
work_order |
sg_req_for_work |
Non-Identifying |
work_order_db_site,work_order_db_id,work_order_id |
work_order |
work_request |
Non-Identifying |
work_order_id,work_order_db_id,work_order_db_site |
work_order |
work_order_blob_data |
Identifying |
work_order_db_site,work_order_db_id,work_order_id |
work_order |
work_step |
Non-Identifying |
work_order_db_site,work_order_db_id,work_order_id |
work_order |
work_order_for_sg_prop_event |
Identifying |
work_order_db_site,work_order_db_id,work_order_id |
work_order |
work_order_for_as_prop_event |
Identifying |
work_order_db_site,work_order_db_id,work_order_id |
work_order |
work_order_for_sg_event |
Identifying |
work_order_db_site,work_order_db_id,work_order_id |
work_order |
work_order_for_as_event |
Identifying |
work_order_db_site,work_order_db_id,work_order_id |