transducer
EntityType Dependent
Logical Entity Name transducer
Definition
Note

transducer Attributes
Attribute/Logical Rolename Domain Datatype NULL Definition
tr_asset_site(PK)(FK) CHAR(16) NO
tr_asset_id(PK)(FK) INTEGER NO
tr_db_site(FK) CHAR(16) NO
tr_db_id(FK) INTEGER NO
tr_type_code(FK) INTEGER NO
out_eu_db_site(FK) CHAR(16) YES
out_eu_db_id(FK) INTEGER YES
out_eu_type_code(FK) INTEGER YES
out_amplitude FLOAT YES
per_eu_db_site(FK) CHAR(16) YES
per_eu_db_id(FK) INTEGER YES
per_eu_type_code(FK) INTEGER YES
gmt_last_calib DATETIME YES
self_powered_yn CHAR(1) YES
name VARCHAR(254) YES
user_tag_ident VARCHAR(254) 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

transducer Keys
Key Name Key Type Keys
PK__transducer__5CD6CB2B PrimaryKey tr_asset_site,tr_asset_id

transducer Relationships
Parent Entity Child Entity Type Foreign Keys
row_status_type transducer Non-Identifying rstat_type_code
asset transducer Identifying tr_asset_site,tr_asset_id
trans_type transducer Non-Identifying tr_db_site,tr_db_id,tr_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
site_database transducer Non-Identifying last_upd_db_site,last_upd_db_id
transducer meas_event Non-Identifying tr_asset_site,tr_asset_id