eng_unit_type
EntityType Dependent
Logical Entity Name eng_unit_type
Default Table Name eng_unit_type
Definition
Note

eng_unit_type Attributes
Attribute/Logical Rolename Domain Datatype NULL Definition
eu_db_site(PK)(FK) CHAR(16) NO
eu_db_id(PK)(FK) NUMERIC(10, 0) NO
eu_type_code(PK) NUMERIC(10, 0) NO
ru_type_code(FK) NUMERIC(10, 0) NO
mult_fact_to_ref FLOAT NO
refer_off_to_ref FLOAT NO
user_tag_ident NVARCHAR(254) YES
name NVARCHAR(254) NO
gmt_last_updated TIMESTAMP/DATE YES
last_upd_db_site(FK) CHAR(16) YES
last_upd_db_id(FK) NUMERIC(10, 0) YES
rstat_type_code(FK) NUMERIC(5, 0) YES

eng_unit_type Keys
Key Name Key Type Keys
PK17 PrimaryKey eu_db_site,eu_db_id,eu_type_code

eng_unit_type Relationships
Parent Entity Child Entity Type Foreign Keys
row_status_type eng_unit_type Non-Identifying rstat_type_code
ref_unit_type eng_unit_type Non-Identifying ru_type_code
site_database eng_unit_type Identifying eu_db_site,eu_db_id
site_database eng_unit_type Non-Identifying last_upd_db_site,last_upd_db_id
eng_unit_type sp_time_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type spa_alarm_reg Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type test_chr_results Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type test_histogram Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type test_num_results Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type transducer Non-Identifying out_eu_db_site,out_eu_db_id,out_eu_type_code
eng_unit_type transducer Non-Identifying per_eu_db_site,per_eu_db_id,per_eu_type_code
eng_unit_type wo_step_chr_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type wo_step_num_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type work_order Non-Identifying int_eu_db_site,int_eu_db_id,int_eu_type_code
eng_unit_type work_order_chr_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type work_order_num_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type as_prop_ev_ndat Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type work_request Non-Identifying int_eu_db_site,int_eu_db_id,int_eu_type_code
eng_unit_type work_req_chr_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type work_req_num_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type num_al_reg_num_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type num_al_reg_chr_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type meas_loc_num_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type meas_loc_chr_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type segment_geo_position Non-Identifying dur_eu_db_site,dur_eu_db_id,dur_eu_type_code
eng_unit_type asset_geo_position Non-Identifying dur_eu_db_site,dur_eu_db_id,dur_eu_type_code
eng_unit_type as_event_chr_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type resource_chr_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type sg_event_chr_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type ord_list_resource Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type ord_list_resource_num_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type ord_list_resource_chr_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type sg_completed_work_num_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type sg_completed_work_chr_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type ord_list_num_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type ord_list_chr_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type mloc_test_comp_alarm_rg Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type test_component Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type test_comp_alarm_rg Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type as_remaining_life Non-Identifying erl_eu_db_site,erl_eu_db_id,erl_eu_type_code
eng_unit_type as_remaining_life Non-Identifying err_eu_db_site,err_eu_db_id,err_eu_type_code
eng_unit_type valid_mat_item_on_sg_num_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type valid_mat_item_on_sg_chr_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type sg_prop_event_chr_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type as_prop_event_chr_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type as_req_for_work Non-Identifying int_eu_db_site,int_eu_db_id,int_eu_type_code
eng_unit_type binary_num_data Non-Identifying offsets_eu_db_site,offsets_eu_db_id,offsets_eu_type_code
eng_unit_type binary_num_data Non-Identifying values_eu_db_site,values_eu_db_id,values_eu_type_code
eng_unit_type solution_package_num_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type solution_package_chr_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type solution_package_step_num_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type solution_package_step_chr_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type work_step_num_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type work_step_chr_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type as_completed_work_num_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type as_completed_work_chr_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type ol_completed_work_num_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type ol_completed_work_chr_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type as_typ_hyp_ev_num_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type request_num_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type request_chr_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type network_num_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type network_chr_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type resource_num_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type meas_location Non-Identifying ml_eu_db_site,ml_eu_db_id,ml_eu_type_code
eng_unit_type asset_chr_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type asset_num_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type blob_grid_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type eng_unit_enum Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type meas_event Non-Identifying dur_eu_db_site,dur_eu_db_id,dur_eu_type_code
eng_unit_type meas_location Non-Identifying int_eu_db_site,int_eu_db_id,int_eu_type_code
eng_unit_type meas_location Non-Identifying dur_eu_db_site,dur_eu_db_id,dur_eu_type_code
eng_unit_type mevent_chr_data Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type mevent_num_data Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type mloc_test_alrm_rg Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type mloc_unit_list Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type model_chr_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type as_event_num_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type model_hyp_ev_num_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type model_num_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type num_alarm_reg Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type ol_req_for_work Non-Identifying int_eu_db_site,int_eu_db_id,int_eu_type_code
eng_unit_type sample_chr_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type sample_num_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type segment_chr_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type segment_num_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type as_hyp_ev_num_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type sg_event_num_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type sg_hyp_ev_num_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type sg_prop_ev_ndat Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type sg_remaining_life Non-Identifying erl_eu_db_site,erl_eu_db_id,erl_eu_type_code
eng_unit_type sg_remaining_life Non-Identifying err_eu_db_site,err_eu_db_id,err_eu_type_code
eng_unit_type sg_req_for_work Non-Identifying int_eu_db_site,int_eu_db_id,int_eu_type_code
eng_unit_type sg_typ_hyp_ev_num_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type sp_ampl_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type sp_blk_num_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type sp_cpb_data Non-Identifying eu_db_site,eu_db_id,eu_type_code
eng_unit_type sp_fft_data Non-Identifying eu_db_site,eu_db_id,eu_type_code

eng_unit_type Attachments
Name Datatype Value Override Default Value Description