Table SIEM.public.asset
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
asset_rpt_v.asset_id Implied Constraint R
asset_x_entity_x_role.asset_id asset_x_entity_x_role_fk1 R
asset_x_entity_x_role_rpt_v.asset_id Implied Constraint R
incidents_assets.asset_id Implied Constraint R
incidents_assets_rpt_v.asset_id Implied Constraint R
Asset identifier
cust_id int8 19
cust.cust_id Implied Constraint R
Customer identifier
asset_name varchar 255  √  null Description of the asset
physical_asset_id uuid 2147483647
physical_asset.physical_asset_id asset_fk1 R
Physical asset identifier
prdt_id int8 19
prdt.prdt_id asset_fk6 R
Product identifier
asset_ctgry_id int8 19
asset_ctgry.asset_ctgry_id asset_fk2 R
Asset category identifier
env_identity_id int8 19
env_identity_lkup.env_identity_id asset_fk7 R
Environment identify code
physical_asset_ind bool 1  √  null Physical asset indicator
asset_val_id int8 19
asset_val_lkup.asset_val_id asset_fk3 R
Asset value code
crit_id int8 19
crit_lkup.crit_id asset_fk4 R
Asset criticality code
sensitivity_id int8 19
sensitivity_lkup.sensitivity_id asset_fk5 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

Table contained 0 rows at Mon Mar 26 23:24 EDT 2012

Column(s) Type Sort Constraint Name
asset_id Primary key Asc asset_pk
asset_name + physical_asset_id + cust_id Must be unique Asc/Asc/Asc asset_ak1

Close relationships  within of separation: