CreateUser and ModifyUser are foreign keys referencing UserID in the USERINFO table.
Added in Version 6.2
The USEROPTIONS table stores individual options for each user.
|
|
CreateUser and ModifyUser are foreign keys referencing UserID in the USERINFO table. |
| Field | Datatype (Length) | Allow Nulls | Indexes |
|---|---|---|---|
|
OPTIONID (PK) |
varchar(32) |
NOT NULL |
USEROPTIONS_OPTIONID_PK (CA) |
|
NAME |
varchar(32) |
NOT NULL |
USEROPTIONS_COMPOSITE (IE) |
|
CATEGORY |
varchar(64) |
NOT NULL |
USEROPTIONS_COMPOSITE (IE) |
|
USERID |
CHAR(12) |
NOT NULL |
USEROPTIONS_USERID (IE) |
|
OPTIONVALUE |
TEXT(16) |
NULLS |
|
|
LOCKED |
char(1) |
NULLS |
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|