This table holds the definition of a product set. The actual representation of the product set is held in the PRSETCEREL table.
Column Descriptions
| Column Name
| Column Type
| Description
|
| NAME
| VARCHAR(32)
| The name given to this product set.
|
| PRODUCTSET_ID
| INTEGER NOT NULL
| The internal reference number.
|
| MEMBER_ID
| BIGINT NOT NULL
| The owner of this product set.
|
| XMLDEFINITION
| CLOB
| Holds the XML definition of this product set according to the B2BProductSet.dtd.
|
| PUBLISHTIME
| TIMESTAMP
| The time when this product set was published to the PRSETCEREL table.
|
| MARKFORDELETE
| INTEGER NOT NULL DEFAULT 0
| Indicates if this product set has been marked for deletion:
0 = No.
1 = Marked for deletion.
|
| STATIC
| CHAR(1)
| Indicates whether this product set can be changed. If this column is set to 1, then this poduct set will never be re-published or synchronized.
|
| OPTCOUNTER
| SMALLINT
| Reserved for IBM internal use.
|