Reference > Database > WebSphere Commerce database tables > I
WebSphere Commerce database table: INSRULE
Each row in this table represents an installment rule.
Column Name Column Type Description INSRULE_ID BIGINT NOT NULL The installment rule id. STOREENT_ID INTEGER NOT NULL The related store id. NAME VARCHAR(64) NOT NULL The name of the installment rule. DESCRIPTION VARCHAR(254) The description of the installment rule. PRIORITY DOUBLE NOT NULL DEFAULT 0 The priority of the installment rule. STARTDATE TIMESTAMP The start date of the installment rule. ENDDATE TIMESTAMP The end date of the installment rule. STATUS SMALLINT NOT NULL DEFAULT 0 The status of this installment rule.
0 = inactive
1 = activeLASTUPDATE TIMESTAMP The date that this installment rule was last updated. FIELD1 INTEGER Customizable. FIELD2 DECIMAL (20,5) Customizable. FIELD3 VARCHAR(254) Customizable. OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0001326 STOREENT_ID+NAME Unique Index SQL100520030710850 INSRULE_ID Primary Key
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_3618 STOREENT_ID STOREENT STOREENT_ID Cascade
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_3621 INSRULE_ID INSRULECATENT INSRULE_ID Cascade F_3619 INSRULE_ID INSRULECATGRP INSRULE_ID Cascade F_3624 INSRULE_ID INSRULECOND INSRULE_ID Cascade F_3625 INSRULE_ID INSRULEINSOPT INSRULE_ID Cascade F_3623 INSRULE_ID INSRULEPAYMTHD INSRULE_ID Cascade _vcc_freeselect_bottom_