Reference > Database > WebSphere Commerce database tables > I
WebSphere Commerce database table: INSRULECATGRP
Each row in this table represents a relationship between an installment rule and a catalog group.
Column Name Column Type Description INSRULECATGRP_ID BIGINT NOT NULL The relationship id. INSRULE_ID BIGINT NOT NULL The related installment rule id of this relationship. CATGROUP_ID BIGINT The related catalog group id of this relasionship. ASSOCTYPE SMALLINT NOT NULL DEFAULT 0 The association type between a catalog group and an installment rule.
0 = Inclusion
1 = ExclusionOPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030711430 INSRULECATGRP_ID Primary Key I0001327 INSRULECATGRP_ID+INSRULE_ID Non-Unique Index I0001328 INSRULE_ID Non-Unique Index I0001329 CATGROUP_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_3620 CATGROUP_ID CATGROUP CATGROUP_ID Cascade F_3619 INSRULE_ID INSRULE INSRULE_ID Cascade _vcc_freeselect_bottom_