pears.BanknameSortcode

• SortCode

• No outgoing foreign keys found.

• No incoming foreign keys found.

• No indexes found.

• No triggers found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."BanknameSortcode"
-- Table comment: 
-- Statement count: 2
 
CREATE TABLE "pears"."BanknameSortcode" (
    "SortCode"                       CHAR(8) NOT NULL
   ,"BankName"                       CHAR(30) NULL
   ,"ValidatedAgainst"               tinyint NULL
   ,PRIMARY KEY ("SortCode" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."BanknameSortcode"."ValidatedAgainst" IS 
	' 0 = Original list, 1=bacs, 2=bankscan.dll, 3=user'
GO