While this table does not have a field defined as a primary key, the SLXWEBGROUPID field should be unique and considered a primary key.
The SLXWEBGROUP and SLXWEBGROUPITEM 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 ID and group name.
|
|
While this table does not have a field defined as a primary key, the SLXWEBGROUPID field should be unique and considered a primary key. |
| Field | Datatype (Length) | Allow Nulls | Indexes | Relationship | Related Table and Field |
|---|---|---|---|---|---|
|
SLXWEBGROUPID (FK) |
char(12) |
NULLS |
SLXWEBGROUP_SLXWEBGROUPID (IE) |
(One) to (Many) |
|
|
USERID (FK) |
char(12) |
NULLS |
SLXWEBGROUP_USERID (IE) |
(Many) to (One) |
|
|
(Many) to (One) |
|||||
|
CREATEUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
CREATEDATE |
datetime(8) |
NULLS |
|
|
|
|
MODIFYUSER (FK) |
char(12) |
NULLS |
|
(Many) to (One) |
|
|
MODIFYDATE |
datetime(8) |
NULLS |
|
|
|
|
GROUPNAME |
varchar(64) |
NULLS |
|
|
|