Reference > Database > WebSphere Commerce database tables > P
WebSphere Commerce database table: PAYMTHDSUP
This table lists all the profiles supported by the Store or StoreGroup. This table is deprecated and is provided for backward compatibility only.
Column Name Column Type Description PAYMTHD_ID INTEGER NOT NULL The unique integer ID of the Cashier profile. Foreign key that references the PAYMTHD_ID column of the PAYMTHD table. STOREENT_ID INTEGER NOT NULL The Store Entity ID of the Store or StoreGroup. Foreign key that references the STOREENT_ID column of the STOREENT table. FIELD1 VARCHAR(254) Customizable. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030408300 PAYMTHD_ID+STOREENT_ID Primary Key I0000684 STOREENT_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_576 PAYMTHD_ID PAYMTHD PAYMTHD_ID Cascade F_577 STOREENT_ID STOREENT STOREENT_ID Cascade _vcc_freeselect_bottom_