Reference > Database > WebSphere Commerce database tables > O
WebSphere Commerce database table: ORDERBLK
Stores blocked Orders with reason code
Column Name Column Type Description ORDERBLK_ID BIGINT NOT NULL Unique primary key ORDERS_ID BIGINT NOT NULL Order whose block is being recorded here BLKRSNCODE_ID INTEGER NOT NULL The reason code Id associated with this block. It identifies the reason for the block. TIMEBLOCKED TIMESTAMP NOT NULL The time the block was placed or last updated. RESOLVED SMALLINT NOT NULL DEFAULT 0 Indicates if this block has been resolved, i.e if it is no longer blocking the Order.
A '0' indicates it is not resolved, and a '1' indicates it is resolved.BLKCOMMENT VARCHAR(254) Comment field to record any comments pertaining to this block.
The field can be updated as needed.FIELD1 INTEGER Field for customization FIELD2 VARCHAR(254) Field for customization OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030400790 ORDERBLK_ID Primary Key I0000956 ORDERS_ID Non-Unique Index I0000957 BLKRSNCODE_ID+RESOLVED Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_1220 BLKRSNCODE_ID BLKRSNCODE BLKRSNCODE_ID Cascade F_1219 ORDERS_ID ORDERS ORDERS_ID Cascade _vcc_freeselect_bottom_