model
EntityType Independent
Logical Entity Name model
Default Table Name model
Definition
Note

model Attributes
Attribute/Logical Rolename Domain Datatype NULL Definition
model_db_site(PK) CHAR(16) NO
model_db_id(PK) UNSIGNEDINT NO
model_id(PK) UNSIGNEDINT NO
as_db_site(FK) CHAR(16) NO
as_db_id(FK) UNSIGNEDINT NO
as_type_code(FK) UNSIGNEDINT NO
mf_db_site(FK) CHAR(16) YES
mf_db_id(FK) UNSIGNEDINT YES
manuf_code(FK) UNSIGNEDINT YES
segment_site(FK) CHAR(16) YES
segment_id(FK) UNSIGNEDINT YES
user_tag_ident VARCHAR(254) YES
name VARCHAR(254) YES
gmt_last_updated DATETIME(19:29) YES
last_upd_db_site(FK) CHAR(16) YES
last_upd_db_id(FK) UNSIGNEDINT YES
rstat_type_code(FK) SHORT 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
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
segment model Non-Identifying segment_site,segment_id
site_database model Non-Identifying last_upd_db_site,last_upd_db_id
row_status_type model Non-Identifying rstat_type_code
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