Each row in this table represents a relationship
between an installment rule and a catalog group.
Column Descriptions:
| Name | 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 = Exclusion |
| OPTCOUNTER | SMALLINT NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | INSRULECATGRP_ID | Primary Key |
| I0001327 | INSRULECATGRP_ID+INSRULE_ID | Non-Unique Index |
| I0001328 | INSRULE_ID | Non-Unique Index |
| I0001329 | CATGROUP_ID | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_3619 | INSRULE_ID | INSRULE | INSRULE_ID | Cascade |
| F_3620 | CATGROUP_ID | CATGROUP | CATGROUP_ID | Cascade |