WebSphere Commerce database table: CWMEMBER

This table stores collaborative workspace member information.

Column Descriptions
Column Name Column Type Description
COLLABWS_ID CHAR(32) NOT NULL The unique ID for the collaborative workspace.
LOGONID VARCHAR(254) NOT NULL The logon ID of the user that has been assigned to the workspace.
ROLE VARCHAR(32) NOT NULL The access role of the user in the workspace.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235150040 COLLABWS_ID+LOGONID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_969 COLLABWS_ID COLLABWS COLLABWS_ID Cascade
Related reference