WebSphere Commerce database table: COLLABWS

This table stores collaborative workspace information.


Column Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031215520 COLLABWS_ID Primary Key
I0000538 ACCOUNT_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_968 ACCOUNT_ID ACCOUNT ACCOUNT_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_969 COLLABWS_ID CWMEMBER COLLABWS_ID Cascade

Feedback