Reference > Database > WebSphere Commerce database tables > S
WebSphere Commerce database table: STORBLKRSN
Store level block reason code configuration. Used to configure whether a block reason code is turned on for a store and also configure whether this block reason code will generate ticklers.
Column Name Column Type Description STOREENT_ID INTEGER NOT NULL The store entity id, foreign key of STOREENT table. BLKRSNCODE_ID INTEGER NOT NULL The block reason code id. Foreign key to the BLKRSNCODE table. RESPECTED SMALLINT NOT NULL DEFAULT 1 Indicates whether the block reason code is active for the store.
0 = off - the code is not active for the store.
1 = on (default) - the code is active for the store.
TKLRGENERATION SMALLINT NOT NULL DEFAULT 1 Indicates whether the block reason code generates ticklers for the store.
0 = off - the block reason code does not generate ticklers for the store.
1 = on (default) - the block reason code generates ticklers for the store.
FIELD1 INTEGER Customizable field1. FIELD2 VARCHAR(254) Customizable field2. OPTCOUNTER SMALLINT Reserved for IBM Internal Use
Indexes Index Name Indexed Column Names Index Type SQL100520030432620 STOREENT_ID+BLKRSNCODE_ID Primary Key
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type R_3449 BLKRSNCODE_ID BLKRSNCODE BLKRSNCODE_ID Cascade R_3448 STOREENT_ID STOREENT STOREENT_ID Cascade _vcc_freeselect_bottom_