WebSphere Commerce database table: ARTTOPRODREL

WebSphere Commerce database table: ARTTOPRODREL

Each row in this table represents the mapping between IBM Workplace Web Content Management content and WebSphere Commerce catalog entries, workspaces, and task groups.

Table 1. Column Descriptions
Column Name Column Type Description

CONTENT_ID VARCHAR(254) NOT NULL The unique identifier of the content in IBM Workplace Web Content Management.
CATENTRY_ID BIGINT NOT NULL The unique identifier of the product created in WebSphere Commerce corresponding to the content in Web Content Management
WRKSPC_ID BIGINT NOT NULL The unique identifier of the workspace the content is created under. A value of "0" (zero) indicates that the content is created in the production ready data.
TASKGRP_ID BIGINT The unique identifier of the task group the content is created under.
TASK_ID BIGINT The unique identifier of the task that created the content.
STATUS CHAR(1) NOT NULL Indicates the status of the Web Content Management content.
Valid status values are:

B

Indicates that the content is to be cancelled.

C

Indicates that the content is cancelled.

D

Indicates draft content.

U

Indicates that the content is pending publication. The task group has been approved.

P

Indicates the content is published.

E

Indicates the content is expired.

R

Indicates the content is to be rejected.

M

Indicates the content was previously approved and is now in Edit mode to make changes.

Related Concepts

Workspaces

Column Name	Column Type	Description
CONTENT_ID	VARCHAR(254) NOT NULL	The unique identifier of the content in IBM Workplace Web Content Management.
CATENTRY_ID	BIGINT NOT NULL	The unique identifier of the product created in WebSphere Commerce corresponding to the content in Web Content Management
WRKSPC_ID	BIGINT NOT NULL	The unique identifier of the workspace the content is created under. A value of "0" (zero) indicates that the content is created in the production ready data.
TASKGRP_ID	BIGINT	The unique identifier of the task group the content is created under.
TASK_ID	BIGINT	The unique identifier of the task that created the content.
STATUS	CHAR(1) NOT NULL	Indicates the status of the Web Content Management content. Valid status values are: B Indicates that the content is to be cancelled. C Indicates that the content is cancelled. D Indicates draft content. U Indicates that the content is pending publication. The task group has been approved. P Indicates the content is published. E Indicates the content is expired. R Indicates the content is to be rejected. M Indicates the content was previously approved and is now in Edit mode to make changes.