View ESEC.ESECDBA.USR_ACCOUNT_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
ACCOUNT_ID number 22
USR_ACCOUNT.ACCOUNT_ID Implied Constraint
USER_NAME varchar2 765
USER_DOMAIN varchar2 765
CUST_ID number 22  √  null
CUST.CUST_ID Implied Constraint
BEGIN_EFFECTIVE_DATE date 7  √  null
END_EFFECTIVE_DATE date 7  √  null
CURRENT_F number 1  √  null
USER_STATUS varchar2 150  √  null
IDENTITY_GUID varchar2 108  √  null
USR_IDENTITY.IDENTITY_GUID Implied Constraint
SOURCE_USER_ID 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 ACCOUNT_ID ,
USR_NAME as USER_NAME,
AUTHORITY as USER_DOMAIN,
CUST_ID,
BEGIN_EFFECTIVE_DATE,
END_EFFECTIVE_DATE,
CURRENT_F,
USR_STS as USER_STATUS,
IDENTITY_GUID,
SRC_USR_ID as SOURCE_USER_ID,
DATE_CREATED,
DATE_MODIFIED,
CREATED_BY,
MODIFIED_BY
from USR_ACCOUNT

Close relationships: