CMEXTDATA

This table contains extended data required to maintain the last modification action on a primary business object. This is an extension of information contained in the CMPRMYOBJ table. This is used for the Change History capabilities for tasks or task groups in Workspaces.

Column Descriptions:

NameTypeDescription
CMEXTDATA_IDBIGINT NOT NULLThe primary key for this table.
CMPRMYOBJ_IDBIGINT NOT NULLThe primary key of the corresponding CMPRMYOBJ record that information in this table extends.
ATTRIBUTENAMEVARCHAR (128) NOT NULLThe name of the extended data that this record represents.
ATTRIBUTEVALUEVARCHAR (1024) NOT NULLThe value of the extended data that this record represents.
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>CMEXTDATA_IDPrimary Key
I0001431CMPRMYOBJ_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3707CMPRMYOBJ_IDCMPRMYOBJCMPRMYOBJ_IDCascade