Reference > Database > WebSphere Commerce database tables > C
WebSphere Commerce database table: COLLABWS
The table is no longer used as collaborative workspaces feature is not supported. It is only retained here to prevent any data loss during migration.
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 SQL100520030318430 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
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_969 COLLABWS_ID CWMEMBER COLLABWS_ID Cascade _vcc_freeselect_bottom_