View ESEC.ESECDBA.USR_IDENTITY_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
IDENTITY_GUID varchar2 108
USR_IDENTITY.IDENTITY_GUID Implied Constraint
DN varchar2 765
CUST_ID number 22  √  null
CUST.CUST_ID Implied Constraint
SRC_IDENTITY_ID varchar2 300  √  null
WFID varchar2 300  √  null
FIRST_NAME varchar2 765  √  null
LAST_NAME varchar2 765  √  null
FULL_NAME varchar2 765  √  null
JOB_TITLE varchar2 765  √  null
DEPARTMENT_NAME varchar2 300  √  null
OFFICE_LOC_CD varchar2 300  √  null
PRIMARY_EMAIL varchar2 765  √  null
PRIMARY_PHONE varchar2 300  √  null
VAULT_NAME varchar2 300  √  null
MGR_GUID varchar2 108  √  null
PHOTO clob 86  √  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 "IDENTITY_GUID","DN","CUST_ID","SRC_IDENTITY_ID","WFID","FIRST_NAME","LAST_NAME","FULL_NAME","JOB_TITLE","DEPARTMENT_NAME","OFFICE_LOC_CD","PRIMARY_EMAIL","PRIMARY_PHONE","VAULT_NAME","MGR_GUID","PHOTO","DATE_CREATED","DATE_MODIFIED","CREATED_BY","MODIFIED_BY" from USR_IDENTITY

Close relationships: