CreateUser and ModifyUser are foreign keys referencing UserID in the USERINFO table.
The SITEOPTIONS table stores Network and Remote user, Remote Office, and synchronization server site codes.
|
|
CreateUser and ModifyUser are foreign keys referencing UserID in the USERINFO table. |
| Field | Datatype (Length) | Allow Nulls | Indexes |
|---|---|---|---|
|
SITECODE (PK) |
STANDARDID(12) |
NOT NULL |
SITEOPTIONS_SITECODE)_PK (CA) |
|
LASTRNFILE |
int |
NULLS |
|
|
HOSTSERVER |
STANDARDID(12) |
NULLS |
|
|
DATA |
DATABLOB(16) |
NULLS |
|
|
KEYPREFIX |
varchar(6) |
NULLS |
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|