The relationship between an installment rule and a
catalog entry.
Column Descriptions:
| Name | 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 | 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> | INSRULECATENT_ID | Primary Key |
| I0001330 | INSRULE_ID+CATENTRY_ID | Non-Unique Index |
| I0001331 | CATENTRY_ID | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_3621 | INSRULE_ID | INSRULE | INSRULE_ID | Cascade |
| F_3622 | CATENTRY_ID | CATENTRY | CATENTRY_ID | Cascade |