Reference > Database > WebSphere Commerce database tables > O
WebSphere Commerce database table: ORDERHIST
This table is used to save order snapshots in XML format.
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 SQL100520030401040 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 _vcc_freeselect_bottom_