WebSphere Commerce database table: PAYMTHDSUP

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 Descriptions
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
SQL060903235226700 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

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.

Index Name	Indexed Column Names	Index Type
SQL060903235226700	PAYMTHD_ID+STOREENT_ID	Primary Key
I0000684	STOREENT_ID	Non-Unique Index

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