WebSphere Commerce database table: ORDERHIST

This table is used to save order snapshots in XML format.

Column Descriptions

Column Name	Column Type	Description
ORDERS_ID	BIGINT NOT NULL	The Order ID.
ORDERVERSION	SMALLINT NOT NULL	The Order history version.
LASTUPDATE	TIMESTAMP	The time this history is created.
ORDXML	CLOB	The XML snapshot for the order information.
FIELD1	INTEGER	Customizable field
FIELD2	VARCHAR(254)	Customizable field
FIELD3	TIMESTAMP	Customizable field
OPTCOUNTER	SMALLINT	Reserved IBM Internal Use

Indexes

Index Name	Indexed Column Names	Index Type
SQL060903235219550	ORDERS_ID+ORDERVERSION	Primary Key

Constraints

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
R_3458	ORDERS_ID	ORDERS	ORDERS_ID	Cascade