Table of Contents



pears.BankModulus

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

Description

Contains list of valid sortcode ranges and which modulus check applies.

Columns

Column Type Null Default Comment
BankModulusID char(20) NOT NULL
sortcode1 integer NULL
sortcode2 integer NULL
ExceptionType char(10) NULL
ExtraMod integer NULL
Mod1 integer NULL
Mod2 integer NULL
Mod3 integer NULL
Mod4 integer NULL
Mod5 integer NULL
Mod6 integer NULL
Mod7 integer NULL
Mod8 integer NULL
Mod9 integer NULL
Mod10 integer NULL
Mod11 integer NULL
Mod12 integer NULL
Mod13 integer NULL
Mod14 integer NULL
sortorder integer NULL

Primary Key

Foreign Keys

Referenced By

Indexes

Name Type Columns Detail
BankModulusSortCode Index sortcode1

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."BankModulus"
-- Table comment: Contains list of valid sortcode ranges and which modulus check applies.
-- Statement count: 3
 
CREATE TABLE "pears"."BankModulus" (
    "BankModulusID"                  CHAR(20) NOT NULL
   ,"sortcode1"                      INTEGER NULL
   ,"sortcode2"                      INTEGER NULL
   ,"ExceptionType"                  CHAR(10) NULL
   ,"ExtraMod"                       INTEGER NULL
   ,"Mod1"                           INTEGER NULL
   ,"Mod2"                           INTEGER NULL
   ,"Mod3"                           INTEGER NULL
   ,"Mod4"                           INTEGER NULL
   ,"Mod5"                           INTEGER NULL
   ,"Mod6"                           INTEGER NULL
   ,"Mod7"                           INTEGER NULL
   ,"Mod8"                           INTEGER NULL
   ,"Mod9"                           INTEGER NULL
   ,"Mod10"                          INTEGER NULL
   ,"Mod11"                          INTEGER NULL
   ,"Mod12"                          INTEGER NULL
   ,"Mod13"                          INTEGER NULL
   ,"Mod14"                          INTEGER NULL
   ,"sortorder"                      INTEGER NULL
   ,PRIMARY KEY ("BankModulusID" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."BankModulus" IS 
	'Contains list of valid sortcode ranges and which modulus check applies.'
GO
 
 
CREATE INDEX "BankModulusSortCode" ON "pears"."BankModulus"
    ( "sortcode1" )
GO