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
SchemaSpy
Legend:
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: