Table ESEC.ESECDBA.USR_IDENTITY 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_ACCOUNT.IDENTITY_GUID FK_USRIDTY_USRACCT
USR_ACCOUNT_RPT_V.IDENTITY_GUID Implied Constraint
USR_IDENTITY_EXT_ATTR.IDENTITY_GUID FK_USRIDTY_EXTATTR
USR_IDENTITY_EXT_ATTR_RPT_V.IDENTITY_GUID Implied Constraint
USR_IDENTITY_RPT_V.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

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

Indexes:
Column(s) Type Sort Constraint Name
IDENTITY_GUID Primary key Asc USR_IDENTITY_PK
DN + VAULT_NAME + CUST_ID Must be unique Asc/Asc/Asc USR_IDENTITY_IX1

Close relationships: