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) UNSIGNEDINT NO
as_db_site(FK) CHAR(16) NO
as_db_id(FK) UNSIGNEDINT NO
as_type_code(FK) UNSIGNEDINT NO
user_tag_ident VARCHAR(254) YES
name VARCHAR(254) YES
long_description VARCHAR(4000) YES
mf_db_site(FK) CHAR(16) YES
mf_db_id(FK) UNSIGNEDINT YES
manuf_code(FK) UNSIGNEDINT YES
model_db_site(FK) CHAR(16) YES
model_db_id(FK) UNSIGNEDINT YES
model_id(FK) UNSIGNEDINT YES
serial_number VARCHAR(254) YES
asr_db_site(FK) CHAR(16) YES
asr_db_id(FK) UNSIGNEDINT YES
asr_type_code(FK) UNSIGNEDINT YES
segment_site(FK) CHAR(16) YES
segment_id(FK) UNSIGNEDINT YES
last_upd_db_site(FK) CHAR(16) YES
last_upd_db_id(FK) UNSIGNEDINT YES
gmt_last_updated DATETIME(19:29) YES
rstat_type_code(FK) SHORT YES

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

asset Relationships
Parent Entity Child Entity Type Foreign Keys
asset_type asset Non-Identifying as_db_site,as_db_id,as_type_code
segment asset Non-Identifying segment_site,segment_id
manufacturer asset Non-Identifying mf_db_site,mf_db_id,manuf_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
site_database asset Non-Identifying last_upd_db_site,last_upd_db_id
site asset Identifying asset_org_site
row_status_type asset Non-Identifying rstat_type_code
asset as_completed_work Identifying asset_org_site,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 as_proposed_event Non-Identifying asset_org_site,asset_id
asset as_recommendation Identifying asset_org_site,asset_id
asset as_remaining_life Identifying asset_org_site,asset_id
asset as_req_for_work Non-Identifying asset_org_site,asset_id
asset as_sol_pack 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_geo_position 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 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 transducer Identifying tr_asset_site,tr_asset_id