View SIEM.public.asset_rpt_v
Associates an asset with all of the detailed information about that asset, which is located in other tables.

Generated by
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
Column Type Size Nulls Auto Default Children Parents Comments
asset_id uuid 2147483647  √  null
asset.asset_id Implied Constraint R
Asset identifier
cust_id int8 19  √  null
cust.cust_id Implied Constraint R
Customer identifier
asset_name varchar 255  √  null Asset name
physical_asset_id uuid 2147483647  √  null
physical_asset.physical_asset_id Implied Constraint R
Physical asset identifier
product_id int8 19  √  null Product identifier
asset_category_id int8 19  √  null Asset category identifier
environment_identity_cd int8 19  √  null Environment identify code
physical_asset_ind bool 1  √  null Physical asset indicator
asset_value_code int8 19  √  null Asset value code
criticality_id int8 19  √  null Asset criticality code
sensitivity_id int8 19  √  null
sensitivity_lkup.sensitivity_id Implied Constraint R
Asset sensitivity code
date_created timestamptz 35,6  √  null Date the entry was created
date_modified timestamptz 35,6  √  null Date the entry was modified
created_by int4 10  √  null User who created object
modified_by int4 10  √  null User who last modified object

Analyzed at Mon Mar 26 23:24 EDT 2012

Close relationships: