Table lawprod.MSCM.LAWSON_USER Generated by
SchemaSpy
Legend:
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
ID varchar2 20
WEB_USER varchar2 80
WEBUSER_COMPANY number 4  √  null
NAME_FIRST_MX_VALUE varchar2 55  √  null
NAME_LAST_MX_VALUE varchar2 55  √  null
WEBUSER_EMAIL varchar2 100  √  null
WEBUSER_STATUS number 1  √  null
WEBUSER_REQUESTER varchar2 10  √  null
WEBUSER_EMPLOYEE varchar2 191  √  null
CREATION_DT date 7
LAST_MODIFIED_DT date 7  √  null
SSOP varchar2 20  √  null

Analyzed at Wed May 18 12:10 CDT 2011

Indexes:
Column(s) Type Sort Constraint Name
ID + WEB_USER Primary key Asc/Asc SYS_IOT_TOP_270422