Table of Contents



pears.DuplicateCheck

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

Columns

Column Type Null Default Comment
DuplicateCheckID char(20) NOT NULL
PersonID char(20) NULL
CompanyID char(20) NULL
EmploymentID char(20) NULL
Postcode char(10) NULL
Email char(200) NULL
Forenames char(30) NULL
Surname char(30) NULL
dupetext char(60) NULL
Companyname char(60) NULL
WhenEntered date NULL
WhoEntered char(20) NULL
DateOfBirth date NULL
ni char(10) NULL

Primary Key

Foreign Keys

Referenced By

Table Constraint Columns Referenced columns
pears.DuplicateCheckResult DuplicateCheckResult1 DuplicateCheckID DuplicateCheckID

Indexes

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."DuplicateCheck"
-- Table comment: 
-- Statement count: 1
 
CREATE TABLE "pears"."DuplicateCheck" (
    "DuplicateCheckID"               CHAR(20) NOT NULL
   ,"PersonID"                       CHAR(20) NULL
   ,"CompanyID"                      CHAR(20) NULL
   ,"EmploymentID"                   CHAR(20) NULL
   ,"Postcode"                       CHAR(10) NULL
   ,"Email"                          CHAR(200) NULL
   ,"Forenames"                      CHAR(30) NULL
   ,"Surname"                        CHAR(30) NULL
   ,"dupetext"                       CHAR(60) NULL
   ,"Companyname"                    CHAR(60) NULL
   ,"WhenEntered"                    DATE NULL
   ,"WhoEntered"                     CHAR(20) NULL
   ,"DateOfBirth"                    DATE NULL
   ,"ni"                             CHAR(10) NULL
   ,PRIMARY KEY ("DuplicateCheckID" ASC) 
)
GO