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

data_source Attributes
Attribute/Logical Rolename Domain Datatype NULL Definition
ds_asset_site(PK) CHAR(16) NO
ds_asset_id(PK) NUMERIC(10, 0) NO
ds_db_site(FK) CHAR(16) NO
ds_db_id(FK) NUMERIC(10, 0) NO
ds_type_code(FK) NUMERIC(10, 0) NO
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

data_source Keys
Key Name Key Type Keys
PK48 PrimaryKey ds_asset_site,ds_asset_id

data_source Relationships
Parent Entity Child Entity Type Foreign Keys
row_status_type data_source Non-Identifying rstat_type_code
data_source_type data_source Non-Identifying ds_db_site,ds_db_id,ds_type_code
site_database data_source Non-Identifying last_upd_db_site,last_upd_db_id
data_source test Non-Identifying ds_asset_site,ds_asset_id
data_source meas_event Non-Identifying ds_asset_site,ds_asset_id

data_source Attachments
Name Datatype Value Override Default Value Description