Database Table: COLLABWS

This table stores collaborative workspace information.

Column Name Column Type Column Description
ACCOUNT_ID BIGINT
NULL
The ID of the account the workspace is associated with.
COLLABWS_ID CHARACTER (32)
NOT NULL
The unique ID for the collaborative workspace.
CREATORLOGONID VARCHAR (254)
NOT NULL
The logon ID of the creator.
DESCRIPTION VARCHAR (1000)
NULL
The description of the workspace.
NAME VARCHAR (254)
NULL
The name of the workspace.
PROCID VARCHAR (64)
NULL
The ID of the process the workspace is created for.
PROCTYPE VARCHAR (64)
NULL
Reserved for IBM internal use.
TEMPLATE VARCHAR (64)
NULL
The template used to create the workspace.
TIMECREATED TIMESTAMP
NULL
The date and time that the workspace is created.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034910680 COLLABWS_ID Primary Key
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