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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416034910680 | COLLABWS_ID | Primary Key |
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 |