Table ESEC.ESECDBA.CUST 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
CUST_ID number 22
ASSET
ASSET_HOSTNAME
ASSET_HOSTNAME_RPT_V
ASSET_IP
ASSET_IP_RPT_V
ASSET_LOC
ASSET_LOCATION_RPT_V
ASSET_RPT_V
CUST_RPT_V
EVENTS
EVENTS_RPT_V2
EVENTS_RPT_V3
EVENTS_SUB
EVT_AGENT
EVT_AGENT_RPT_V
EVT_AGENT_RPT_V3
EVT_ASSET
EVT_ASSET_RPT_V
EVT_ASSET_RPT_V3
EVT_DEST_EVT_NAME_SMRY_1
EVT_DEST_EVT_NAME_SMRY_1_RPT_V
EVT_DEST_SMRY_1
EVT_DEST_SMRY_1_RPT_V
EVT_DEST_TXNMY_SMRY_1
EVT_DEST_TXNMY_SMRY_1_RPT_V
EVT_PORT_SMRY_1
EVT_PORT_SMRY_1_RPT_V
EVT_RSRC
EVT_RSRC_RPT_V
EVT_SEV_SMRY_1
EVT_SEV_SMRY_1_RPT_V
EVT_SRC_SMRY_1
EVT_SRC_SMRY_1_RPT_V
EVT_USR
EVT_USR_RPT_V
ORGANIZATION
ORGANIZATION_RPT_V
PERSON
PERSON_RPT_V
PHYSICAL_ASSET
PHYSICAL_ASSET_RPT_V
USR_ACCOUNT
USR_ACCOUNT_RPT_V
USR_IDENTITY
USR_IDENTITY_RPT_V
CUST_NAME varchar2 765  √  null
DATE_CREATED date 7  √  null
DATE_MODIFIED date 7  √  null
CREATED_BY number 22  √  null
MODIFIED_BY number 22  √  null

Table contained 13 rows at Tue May 04 17:09 EDT 2010

Indexes:
Column(s) Type Sort Anomalies
CUST_ID Primary key Asc  
CUST_NAME Must be unique Asc This unique column is also nullable

Close relationships: