transducer
EntityType Dependent
Logical Entity Name transducer
Default Table 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) NUMERIC(10, 0) NO
tr_db_site(FK) CHAR(16) NO
tr_db_id(FK) NUMERIC(10, 0) NO
tr_type_code(FK) NUMERIC(10, 0) NO
out_eu_db_site(FK) CHAR(16) YES
out_eu_db_id(FK) NUMERIC(10, 0) YES
out_eu_type_code(FK) NUMERIC(10, 0) YES
out_amplitude FLOAT YES
per_eu_db_site(FK) CHAR(16) YES
per_eu_db_id(FK) NUMERIC(10, 0) YES
per_eu_type_code(FK) NUMERIC(10, 0) YES
gmt_last_calib TIMESTAMP/DATE YES
self_powered_yn CHAR(1) YES
user_tag_ident NVARCHAR(254) YES
name NVARCHAR(254) YES
gmt_last_updated TIMESTAMP/DATE YES
last_upd_db_site(FK) CHAR(16) YES
last_upd_db_id(FK) NUMERIC(10, 0) YES
rstat_type_code(FK) NUMERIC(5, 0) YES

transducer Keys
Key Name Key Type Keys
PK49 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 test Non-Identifying tr_asset_site,tr_asset_id
transducer meas_event Non-Identifying tr_asset_site,tr_asset_id

transducer Attachments
Name Datatype Value Override Default Value Description