Parent Entity |
Child Entity |
Type |
Foreign Keys |
manufacturer |
asset |
Non-Identifying |
mf_db_site,mf_db_id,manuf_code |
segment |
asset |
Non-Identifying |
segment_site,segment_id |
criticality_scale_type |
asset |
Non-Identifying |
cs_type_db_site,cs_type_db_id,cs_type_code |
asset_type |
asset |
Non-Identifying |
as_db_site,as_db_id,as_type_code |
model |
asset |
Non-Identifying |
model_db_site,model_db_id,model_id |
as_readiness_type |
asset |
Non-Identifying |
asr_db_site,asr_db_id,asr_type_code |
row_status_type |
asset |
Non-Identifying |
rstat_type_code |
site_database |
asset |
Non-Identifying |
last_upd_db_site,last_upd_db_id |
site |
asset |
Identifying |
asset_org_site |
asset |
transducer |
Identifying |
tr_asset_site,tr_asset_id |
asset |
as_sol_pack |
Identifying |
asset_org_site,asset_id |
asset |
as_proposed_event |
Non-Identifying |
asset_org_site,asset_id |
asset |
asset_geo_position |
Identifying |
asset_org_site,asset_id |
asset |
materiel_item |
Non-Identifying |
asset_org_site,asset_id |
asset |
as_recommendation |
Identifying |
asset_org_site,asset_id |
asset |
agent |
Non-Identifying |
asset_org_site,asset_id |
asset |
as_remaining_life |
Identifying |
asset_org_site,asset_id |
asset |
valid_asset_eng_study_entry |
Identifying |
asset_org_site,asset_id |
asset |
asset_model_history |
Identifying |
asset_org_site,asset_id |
asset |
asset_config_network_history |
Identifying |
asset_org_site,asset_id |
asset |
as_req_for_work |
Non-Identifying |
asset_org_site,asset_id |
asset |
as_config_ord_list_history |
Identifying |
asset_org_site,asset_id |
asset |
asset_blob_data |
Identifying |
asset_org_site,asset_id |
asset |
asset_child |
Identifying |
asset_org_site,asset_id |
asset |
asset_child |
Identifying |
child_as_site,child_as_id |
asset |
asset_chr_data |
Identifying |
asset_org_site,asset_id |
asset |
asset_event |
Identifying |
asset_org_site,asset_id |
asset |
asset_function |
Identifying |
asset_org_site,asset_id |
asset |
asset_health |
Identifying |
asset_org_site,asset_id |
asset |
asset_num_data |
Identifying |
asset_org_site,asset_id |
asset |
asset_on_segment |
Identifying |
asset_org_site,asset_id |
asset |
asset_owner |
Identifying |
asset_org_site,asset_id |
asset |
as_completed_work |
Identifying |
asset_org_site,asset_id |
asset |
meas_event |
Non-Identifying |
asset_org_site,asset_id |
asset |
meas_location |
Non-Identifying |
asset_org_site,asset_id |
asset |
meas_sample_test |
Non-Identifying |
test_asset_site,test_asset_id |
asset |
as_hyp_event |
Non-Identifying |
asset_org_site,asset_id |
asset |
as_network_connect |
Identifying |
asset_org_site,asset_id |
asset |
as_network_connect |
Identifying |
output_as_site,output_as_id |