Reference > Database > WebSphere Commerce database tables > I

WebSphere Commerce database table: INSRULECATENT

The relationship between an installment rule and a catalog entry.

Column Name	Column Type	Description
INSRULECATENT_ID	BIGINT NOT NULL	The relationship id.
INSRULE_ID	BIGINT NOT NULL	The related installment rule id.
CATENTRY_ID	BIGINT	The related catalog entry id.
ASSOCTYPE	SMALLINT NOT NULL DEFAULT 0	The association type. 0 = Inclusion 1 = Exclusion
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	Reserved for IBM internal use.

Indexes

Index Name	Indexed Column Names	Index Type
SQL100520030711140	INSRULECATENT_ID	Primary Key
I0001330	INSRULE_ID+CATENTRY_ID	Non-Unique Index
I0001331	CATENTRY_ID	Non-Unique Index

Constraints

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_3622	CATENTRY_ID	CATENTRY	CATENTRY_ID	Cascade
F_3621	INSRULE_ID	INSRULE	INSRULE_ID	Cascade

_vcc_freeselect_bottom_

+

Search Tips   |   Advanced Search