View ESEC.ESECDBA.EVT_ASSET_RPT_V Generated by
SchemaSpy
Legend: SourceForge.net
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
EVENT_ASSET_ID number 22
CUST_ID number 22  √  null
CUST.CUST_ID Implied Constraint
ASSET_NAME varchar2 765  √  null
PHYSICAL_ASSET_NAME varchar2 765  √  null
REFERENCE_ASSET_ID varchar2 300  √  null
MAC_ADDRESS varchar2 300  √  null
RACK_NUMBER varchar2 150  √  null
ROOM_NAME varchar2 300  √  null
BUILDING_NAME varchar2 765  √  null
CITY varchar2 300  √  null
STATE varchar2 300  √  null
COUNTRY varchar2 300  √  null
ZIP_CODE varchar2 150  √  null
ASSET_CATEGORY_NAME varchar2 300  √  null
NETWORK_IDENTITY_NAME varchar2 765  √  null
ENVIRONMENT_IDENTITY_NAME varchar2 765  √  null
ASSET_VALUE_NAME varchar2 150  √  null
CRITICALITY_NAME varchar2 150  √  null
SENSITIVITY_NAME varchar2 150  √  null
CONTACT_NAME_1 varchar2 765  √  null
CONTACT_NAME_2 varchar2 765  √  null
ORGANIZATION_NAME_1 varchar2 300  √  null
ORGANIZATION_NAME_2 varchar2 300  √  null
ORGANIZATION_NAME_3 varchar2 300  √  null
ORGANIZATION_NAME_4 varchar2 300  √  null
DATE_CREATED date 7  √  null
DATE_MODIFIED date 7  √  null
CREATED_BY number 22  √  null
MODIFIED_BY number 22  √  null

Analyzed at Tue May 04 17:09 EDT 2010

View SQL:
SELECT
EVT_ASSET_ID as Event_Asset_ID,
CUST_ID,
ASSET_NAME as Asset_Name,
PHYSICAL_ASSET_NAME as Physical_Asset_Name,
REF_ASSET_ID as Reference_Asset_ID,
MAC_ADDR as Mac_Address,
RACK_NUM as Rack_Number,
ROOM_NAME as Room_Name,
BUILDING_NAME as Building_Name,
CITY as City,
STATE as State,
CNTRY as Country,
ZIP_CD as Zip_Code,
ASSET_CTGRY_NAME as Asset_Category_Name,
NETWORK_IDENTITY_NAME as Network_Identity_Name,
ENV_IDENTITY_NAME as Environment_Identity_Name,
ASSET_VAL_NAME as Asset_value_Name,
CRIT_NAME as Criticality_Name,
SENSITIVITY_NAME as Sensitivity_Name,
CONTACT_NAME_1 as Contact_Name_1,
CONTACT_NAME_2 as Contact_Name_2,
ORGANIZATION_NAME_1 as Organization_Name_1,
ORGANIZATION_NAME_2 as Organization_Name_2,
ORGANIZATION_NAME_3 as Organization_Name_3,
ORGANIZATION_NAME_4 as Organization_Name_4,
DATE_CREATED,
DATE_MODIFIED,
CREATED_BY,
MODIFIED_BY
FROM EVT_ASSET

Close relationships: