Parent Entity |
Child Entity |
Type |
Foreign Keys |
segment_type |
segment |
Non-Identifying |
sg_db_site,sg_db_id,sg_type_code |
site_database |
segment |
Non-Identifying |
last_upd_db_site,last_upd_db_id |
row_status_type |
segment |
Non-Identifying |
rstat_type_code |
site |
segment |
Identifying |
segment_site |
segment |
asset |
Non-Identifying |
segment_site,segment_id |
segment |
asset_on_segment |
Identifying |
segment_site,segment_id |
segment |
meas_location |
Non-Identifying |
segment_site,segment_id |
segment |
model |
Non-Identifying |
segment_site,segment_id |
segment |
segment_blob_data |
Identifying |
segment_site,segment_id |
segment |
segment_child |
Identifying |
segment_site,segment_id |
segment |
segment_child |
Identifying |
child_sg_site,child_sg_id |
segment |
segment_chr_data |
Identifying |
segment_site,segment_id |
segment |
segment_event |
Identifying |
segment_site,segment_id |
segment |
segment_function |
Identifying |
segment_site,segment_id |
segment |
segment_geo_position |
Identifying |
segment_site,segment_id |
segment |
segment_health |
Identifying |
segment_site,segment_id |
segment |
segment_num_data |
Identifying |
segment_site,segment_id |
segment |
sg_completed_work |
Identifying |
segment_site,segment_id |
segment |
sg_hyp_ev_amb_set |
Non-Identifying |
segment_site,segment_id |
segment |
sg_hyp_event |
Non-Identifying |
segment_site,segment_id |
segment |
sg_network_connect |
Identifying |
segment_site,segment_id |
segment |
sg_network_connect |
Identifying |
output_sg_site,output_sg_id |
segment |
sg_prop_ev_amb_set |
Non-Identifying |
segment_site,segment_id |
segment |
sg_proposed_event |
Non-Identifying |
segment_site,segment_id |
segment |
sg_recommendation |
Identifying |
segment_site,segment_id |
segment |
sg_remaining_life |
Identifying |
segment_site,segment_id |
segment |
sg_req_for_work |
Non-Identifying |
segment_site,segment_id |
segment |
sg_sol_pack |
Identifying |
segment_site,segment_id |