CMFWKSPC

Holds workspace-specific information.

Column Descriptions:

NameTypeDescription
CMFWKSPC_IDBIGINT NOT NULLPrimary key.
IDENTIFIERVARCHAR (254)Unique, language-independent name for the workspace.
STATUSINTEGER NOT NULL DEFAULT 1Indicates the status of a workspace:
  • 1=active
  • 2=complete
  • 3=canceled
  • 4=cancel in progress
MEMBER_IDBIGINT NOT NULLForeign key to the MEMBER table. Identifies the Workspace Manager.
PERSISTENTYPEINTEGER NOT NULL DEFAULT 0Indicates whether or not this is a persistent workspace. 1=persistent, 0=not persistent
LOCKINGPOLICYINTEGER NOT NULL DEFAULT 0Reserved for HCL internal use.
PROMOTIONPOLICYINTEGER NOT NULL DEFAULT 0Reserved for HCL internal use.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>CMFWKSPC_IDPrimary Key
I0000880IDENTIFIERUnique Index
I0000881STATUSNon-Unique Index
I0000889MEMBER_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1123MEMBER_IDMEMBERMEMBER_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_1127CMFWKSPC_IDCMFWSTGRELCMFWKSPC_IDCascade
F_1128CMFWKSPC_IDCMFWKSPCDSCCMFWKSPC_IDCascade