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

asset Attributes
Attribute/Logical Rolename Domain Datatype NULL Definition
asset_org_site(PK)(FK) CHAR(16) NO
asset_id(PK) NUMERIC(10, 0) NO
as_db_site(FK) CHAR(16) NO
as_db_id(FK) NUMERIC(10, 0) NO
as_type_code(FK) NUMERIC(10, 0) NO
user_tag_ident NVARCHAR(254) YES
name NVARCHAR(254) YES
long_description VARCHAR(4000) YES
criticality NUMERIC(10, 0) YES
cs_type_db_site(FK) CHAR(16) YES
cs_type_db_id(FK) NUMERIC(10, 0) YES
cs_type_code(FK) NUMERIC(10, 0) YES
mf_db_site(FK) CHAR(16) YES
mf_db_id(FK) NUMERIC(10, 0) YES
manuf_code(FK) NUMERIC(10, 0) YES
model_db_site(FK) CHAR(16) YES
model_db_id(FK) NUMERIC(10, 0) YES
model_id(FK) NUMERIC(10, 0) YES
serial_number NVARCHAR(254) YES
asr_db_site(FK) CHAR(16) YES
asr_db_id(FK) NUMERIC(10, 0) YES
asr_type_code(FK) NUMERIC(10, 0) YES
segment_site(FK) CHAR(16) YES
segment_id(FK) NUMERIC(10, 0) YES
last_upd_db_site(FK) CHAR(16) YES
last_upd_db_id(FK) NUMERIC(10, 0) YES
gmt_last_updated TIMESTAMP/DATE YES
rstat_type_code(FK) NUMERIC(5, 0) YES

asset Keys
Key Name Key Type Keys
PK33 PrimaryKey asset_org_site,asset_id

asset Relationships
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

asset Attachments
Name Datatype Value Override Default Value Description