Database Table: PRODUCTSET

This table holds the definition of a ProductSet. The actual representation of the ProductSet is held in the PRSETCEREL table.

Column Name Column Type Column Description
MARKFORDELETE INTEGER
NOT NULL, DEFAULT 0
Indicates if this ProductSet has been marked for deletion:
0 = No.
1 = Marked for deletion.
MEMBER_ID BIGINT
NOT NULL
The owner of this ProductSet.
NAME VARCHAR (32)
NULL
The name given to this ProductSet.
PRODUCTSET_ID INTEGER
NOT NULL
The internal reference number.
PUBLISHTIME TIMESTAMP
NULL
The time when this ProductSet was published to the PRSETCEREL table.
STATIC CHARACTER (1)
NULL
Indicates whether this ProductSet can be changed. If this column is set to "1", then this PoductSet will never be re-published or synchronized.
XMLDEFINITION LONG VARCHAR
NULL
Holds the XML definition of this ProductSet according to the B2BProductSet.dtd.
Indexes:
Index Name Indexed Column Names Index Type
I0000191 NAME, MEMBER_ID Unique Index
SQL030416035040200 PRODUCTSET_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_622 MEMBER_ID MEMBER MEMBER_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_221 PRODUCTSET_ID CATGRPPS PRODUCTSET_ID Cascade
F_621 PRODUCTSET_ID PRODSETDSC PRODUCTSET_ID Cascade
F_628 PRODUCTSET_ID PRSETCEREL PRODUCTSET_ID Cascade
F_864 PRODUCTSET_ID TRADEPOSCN PRODUCTSET_ID Cascade
F_921 PRODUCTSET_ID PSETADJMNT PRODUCTSET_ID Cascade