View ESEC.ESECDBA.EVT_ASSET_RPT_V3 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
ASSET_CRITICALITY varchar2 150  √  null
ASSET_CLASS varchar2 300  √  null
ASSET_FUNCTION varchar2 765  √  null
ASSET_DEPARTMENT varchar2 300  √  null
DATE_CREATED date 7  √  null
DATE_MODIFIED date 7  √  null
CREATED_BY number 22  √  null
MODIFIED_BY number 22  √  null
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
NETWORK_IDENTITY_NAME varchar2 765  √  null
ASSET_VALUE_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

Analyzed at Tue May 04 17:09 EDT 2010

View SQL:
SELECT
CRIT_NAME as Asset_Criticality,
ASSET_CTGRY_NAME as Asset_Class,
ENV_IDENTITY_NAME as Asset_Function,
ORGANIZATION_NAME_4 as Asset_Department,
DATE_CREATED,
DATE_MODIFIED,
CREATED_BY,
MODIFIED_BY,
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,
NETWORK_IDENTITY_NAME as Network_Identity_Name,
ASSET_VAL_NAME as Asset_value_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
FROM EVT_ASSET

Close relationships: