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 Comments
CUST_ID number 22
ASSET.CUST_ID Implied Constraint
ASSET_HOSTNAME.CUST_ID Implied Constraint
ASSET_HOSTNAME_RPT_V.CUST_ID Implied Constraint
ASSET_IP.CUST_ID Implied Constraint
ASSET_IP_RPT_V.CUST_ID Implied Constraint
ASSET_LOC.CUST_ID Implied Constraint
ASSET_LOCATION_RPT_V.CUST_ID Implied Constraint
ASSET_RPT_V.CUST_ID Implied Constraint
CUST_RPT_V.CUST_ID Implied Constraint
EVENTS.CUST_ID Implied Constraint
EVENTS_RPT_V2.CUST_ID Implied Constraint
EVENTS_RPT_V3.CUST_ID Implied Constraint
EVENTS_SUB.CUST_ID Implied Constraint
EVT_AGENT.CUST_ID Implied Constraint
EVT_AGENT_RPT_V.CUST_ID Implied Constraint
EVT_AGENT_RPT_V3.CUST_ID Implied Constraint
EVT_ASSET.CUST_ID Implied Constraint
EVT_ASSET_RPT_V.CUST_ID Implied Constraint
EVT_ASSET_RPT_V3.CUST_ID Implied Constraint
EVT_DEST_EVT_NAME_SMRY_1.CUST_ID Implied Constraint
EVT_DEST_EVT_NAME_SMRY_1_RPT_V.CUST_ID Implied Constraint
EVT_DEST_SMRY_1.CUST_ID Implied Constraint
EVT_DEST_SMRY_1_RPT_V.CUST_ID Implied Constraint
EVT_DEST_TXNMY_SMRY_1.CUST_ID Implied Constraint
EVT_DEST_TXNMY_SMRY_1_RPT_V.CUST_ID Implied Constraint
EVT_PORT_SMRY_1.CUST_ID Implied Constraint
EVT_PORT_SMRY_1_RPT_V.CUST_ID Implied Constraint
EVT_RSRC.CUST_ID Implied Constraint
EVT_RSRC_RPT_V.CUST_ID Implied Constraint
EVT_SEV_SMRY_1.CUST_ID Implied Constraint
EVT_SEV_SMRY_1_RPT_V.CUST_ID Implied Constraint
EVT_SRC_SMRY_1.CUST_ID Implied Constraint
EVT_SRC_SMRY_1_RPT_V.CUST_ID Implied Constraint
EVT_USR.CUST_ID Implied Constraint
EVT_USR_RPT_V.CUST_ID Implied Constraint
ORGANIZATION.CUST_ID Implied Constraint
ORGANIZATION_RPT_V.CUST_ID Implied Constraint
PERSON.CUST_ID Implied Constraint
PERSON_RPT_V.CUST_ID Implied Constraint
PHYSICAL_ASSET.CUST_ID Implied Constraint
PHYSICAL_ASSET_RPT_V.CUST_ID Implied Constraint
USR_ACCOUNT.CUST_ID Implied Constraint
USR_ACCOUNT_RPT_V.CUST_ID Implied Constraint
USR_IDENTITY.CUST_ID Implied Constraint
USR_IDENTITY_RPT_V.CUST_ID Implied Constraint
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 Constraint Name Anomalies
CUST_ID Primary key Asc CUST_PK  
CUST_NAME Must be unique Asc CUST_AK1 This unique column is also nullable

Close relationships: