Reference > Database > WebSphere Commerce database tables > E
WebSphere Commerce database table: EDPRELHIST
This table keeps the history for all operations on releases in Payment Rules.
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 SQL100520030330770 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 _vcc_freeselect_bottom_