WebSphere Commerce database table: EDPRELHIST

This table keeps the history for all operations on releases in Payment Rules.

Column Descriptions

Column Name	Column Type	Description
EDPPAYHIST_ID	BIGINT NOT NULL	Payment Activity Record unique identifier (generated)
ORDER_ID	BIGINT NOT NULL	the order identifier
RELEASE_ID	BIGINT NOT NULL	Release unique identifier
STORE_ID	INTEGER NOT NULL	the store identifier
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	Reserved for IBM internal use.
FIELD1	INTEGER	customizable
FIELD2	VARCHAR(254)	customizable
FIELD3	VARCHAR(254)	customizable

Indexes

Index Name	Indexed Column Names	Index Type
SQL060903235153760	EDPPAYHIST_ID+ORDER_ID+RELEASE_ID+STORE_ID	Primary Key
I0000852	ORDER_ID+RELEASE_ID+STORE_ID	Non-Unique Index

Constraints

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_1101	EDPPAYHIST_ID	EDPPAYHIST	EDPPAYHIST_ID	Cascade