model
EntityType Independent
Logical Entity Name model
Definition
Note

model Attributes
Attribute/Logical Rolename Domain Datatype NULL Definition
model_db_site(PK) CHAR(16) NO
model_db_id(PK) INTEGER NO
model_id(PK) INTEGER NO
as_db_site(FK) CHAR(16) NO
as_db_id(FK) INTEGER NO
as_type_code(FK) INTEGER NO
mf_db_site(FK) CHAR(16) YES
mf_db_id(FK) INTEGER YES
manuf_code(FK) INTEGER YES
user_tag_ident VARCHAR(254) YES
name VARCHAR(254) YES
prod_family VARCHAR(254) YES
prod_family_member VARCHAR(254) YES
prod_family_member_rev VARCHAR(254) YES
part_number VARCHAR(254) YES
segment_site(FK) CHAR(16) YES
segment_id(FK) INTEGER YES
gmt_last_updated DATETIME YES
last_upd_db_site(FK) CHAR(16) YES
last_upd_db_id(FK) INTEGER YES
rstat_type_code(FK) SMALLINT YES

model Keys
Key Name Key Type Keys
PK__model__30F848ED PrimaryKey model_db_site,model_db_id,model_id

model Relationships
Parent Entity Child Entity Type Foreign Keys
segment model Non-Identifying segment_site,segment_id
manufacturer model Non-Identifying mf_db_site,mf_db_id,manuf_code
asset_type model Non-Identifying as_db_site,as_db_id,as_type_code
row_status_type model Non-Identifying rstat_type_code
site_database model Non-Identifying last_upd_db_site,last_upd_db_id
model materiel_item Non-Identifying model_db_site,model_db_id,model_id
model asset_model_history Identifying model_db_site,model_db_id,model_id
model model_config_network_history Identifying model_db_site,model_db_id,model_id
model asset Non-Identifying model_db_site,model_db_id,model_id
model model_blob_data Identifying model_db_site,model_db_id,model_id
model model_child Identifying model_db_site,model_db_id,model_id
model model_child Identifying child_model_db_site,child_model_db_id,child_model_id
model model_chr_data Identifying model_db_site,model_db_id,model_id
model model_function Identifying model_db_site,model_db_id,model_id
model model_hyp_event Non-Identifying model_db_site,model_db_id,model_id
model model_num_data Identifying model_db_site,model_db_id,model_id
model model_recomm Identifying model_db_site,model_db_id,model_id