CreateUser and ModifyUser are foreign keys referencing UserID in the USERINFO table.
The SLXWEBGROUPITEM and SLXWEBGROUP tables work together to store groups or collections of items for the Web Client. This table contains information including, but not limited to, the group item ID, group ID, and item name.
table relationships
The SLXWEBGROUPITEM table has a (Many) to (Zero or One) relationship with the SLXWEBGROUP table.
|
|
CreateUser and ModifyUser are foreign keys referencing UserID in the USERINFO table. |
| Field | Datatype (Length) | Allow Nulls | Indexes |
|---|---|---|---|
|
SLXWEBGROUPITEMID |
char(12) |
NULLS |
SLXWEBGROUPITEM_ID (IE) |
|
char(12) |
NULLS |
SLXWEBGROUPITEM_SLXWEBGROUPID (IE) |
|
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
ITEMNAME |
varchar(64) |
NULLS |
|