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:
| Name | Type | Description |
| CMEXTDATA_ID | BIGINT NOT NULL | The primary key for this table. |
| CMPRMYOBJ_ID | BIGINT NOT NULL | The primary key of the corresponding CMPRMYOBJ
record that information in this table extends. |
| ATTRIBUTENAME | VARCHAR (128) NOT NULL | The name of the extended data that this record
represents. |
| ATTRIBUTEVALUE | VARCHAR (1024) NOT NULL | The value of the extended data that this record
represents. |
| OPTCOUNTER | SMALLINT NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | CMEXTDATA_ID | Primary Key |
| I0001431 | CMPRMYOBJ_ID | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_3707 | CMPRMYOBJ_ID | CMPRMYOBJ | CMPRMYOBJ_ID | Cascade |