The SLXWEBGROUPUSERINFO table stores user option information for the Web Client. This table contains information including, but not limited to, the user ID, user preferences, and the last date the user logged in.
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
USERID (PK) |
STANDARDID(12) |
NULLS |
SLXWEBUSERINFO_USERID_PK (CA) |
(One) to (Many) |
|
|
(One) to (One)
|
|
||||
|
CREATEDATE |
datetime(8) |
NULLS
|
|
|
|
|
CREATEUSER (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
LASTWEBDATE |
datetime(8) |
NULLS |
|
|
|
|
EXPIRES |
datetime(8) |
NULLS |
|
|
|
|
REGION |
varchar(64) |
NULLS |
|
|
|
|
USERGROUP |
varchar(64) |
NULLS |
|
|
|
|
DEFSECCODE |
STANDARDID(12) |
NULLS |
|
(Many) to (One) |
|
|
USERPREFERENCES |
TEXTBLOB(16) |
NULLS |
|
|
|
|
LASTLOGINDATE |
datetime(8) |
NULLS |
|
|
|