WebSphere Commerce database table: COLLABWS

This table stores collaborative workspace information.

Column Descriptions

Column Name	Column Type	Description
COLLABWS_ID	CHAR(32) NOT NULL	The unique ID for the collaborative workspace.
PROCTYPE	VARCHAR(64)	Reserved for IBM internal use.
PROCID	VARCHAR(64)	The ID of the process for which the workspace is created.
CREATORLOGONID	VARCHAR(254) NOT NULL	The logon ID of the creator.
NAME	VARCHAR(254)	The name of the workspace.
DESCRIPTION	VARCHAR(1000)	The description of the workspace.
TEMPLATE	VARCHAR(64)	The template used to create the workspace.
TIMECREATED	TIMESTAMP	The date and time that the workspace was created.
ACCOUNT_ID	BIGINT	The ID of the account with which the workspace is associated.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.

Indexes

Index Name	Indexed Column Names	Index Type
SQL060903235144780	COLLABWS_ID	Primary Key
I0000538	ACCOUNT_ID	Non-Unique Index

Constraints

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_968	ACCOUNT_ID	ACCOUNT	ACCOUNT_ID	Cascade

Constraint Name	Referenced Column Name	Foreign Table Name	Foreign Column Names	Constraint Type
F_969	COLLABWS_ID	CWMEMBER	COLLABWS_ID	Cascade

Related reference

• Collaborative workspace data model