Synopsis
Table structure
|
Field |
Type |
Null |
Default |
Comments |
|
USER_ID_NUM |
int(11) |
No |
0 |
|
|
USER_ID |
varchar(14) |
Yes |
NULL |
|
|
PASSWORD |
varchar(50) |
Yes |
NULL |
|
|
ORGANIZATION |
varchar(100) |
Yes |
NULL |
|
|
ORG_UNIT |
varchar(100) |
Yes |
NULL |
|
|
FIRST_NAME |
varchar(100) |
Yes |
NULL |
|
|
MIDDLE_NAME |
varchar(20) |
Yes |
NULL |
|
|
LAST_NAME |
varchar(100) |
Yes |
NULL |
|
|
JOB_TITLE |
varchar(100) |
Yes |
NULL |
|
|
ADDRESS1 |
varchar(100) |
Yes |
NULL |
|
|
ADDRESS2 |
varchar(100) |
Yes |
NULL |
|
|
CITY |
varchar(30) |
Yes |
NULL |
|
|
STATE |
varchar(15) |
Yes |
NULL |
|
|
ZIP |
varchar(10) |
Yes |
NULL |
|
|
COUNTRY |
varchar(30) |
Yes |
NULL |
|
|
PHONE_INTEGER |
varchar(30) |
Yes |
NULL |
|
|
FAX_INTEGER |
varchar(30) |
Yes |
NULL |
|
|
EMAIL_ADDR |
varchar(75) |
Yes |
NULL |
|
|
LOGGED_FLG |
char(1) |
Yes |
N |
|
|
ACTIVE |
int(11) |
Yes |
1 |
|
|
ES_USER |
int(11) |
Yes |
NULL |
|
|
PARENT |
int(11) |
Yes |
NULL |
|
|
SUBMITTER_UPDATE |
int(11) |
Yes |
NULL |
|
|
TRIGGER_UPD_DATE |
date |
Yes |
NULL |
|