Table of Contents



pears.UTRCheck

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
UTRcheckID char(20) NOT NULL
UTR char(20) NULL
personID char(20) NULL
CorrelationID char(50) NULL
Submission long varchar NULL
Body long varchar NULL
SubmissionResponse long varchar NULL
polling long varchar NULL
pollingResponse long varchar NULL
IRmark char(100) NULL
SubmissionTime timestamp NULL
LastPollTime timestamp NULL
PollingTimes integer NULL 0
PollCompleted tinyint NULL 0
DeleteRequest long varchar NULL
DeleteResponse long varchar NULL
DeleteTime timestamp NULL
ListRequest long varchar NULL
ListResponse long varchar NULL

Primary Key

Foreign Keys

Constraint Columns References Delete/update action
Person personID pears.Person (personid) ON DELETE CASCADE

Referenced By

Indexes

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."UTRCheck"
-- Table comment: 
-- Statement count: 2
 
CREATE TABLE "pears"."UTRCheck" (
    "UTRcheckID"                     CHAR(20) NOT NULL
   ,"UTR"                            CHAR(20) NULL
   ,"personID"                       CHAR(20) NULL
   ,"CorrelationID"                  CHAR(50) NULL
   ,"Submission"                     long VARCHAR NULL
   ,"Body"                           long VARCHAR NULL
   ,"SubmissionResponse"             long VARCHAR NULL
   ,"polling"                        long VARCHAR NULL
   ,"pollingResponse"                long VARCHAR NULL
   ,"IRmark"                         CHAR(100) NULL
   ,"SubmissionTime"                 TIMESTAMP NULL
   ,"LastPollTime"                   TIMESTAMP NULL
   ,"PollingTimes"                   INTEGER NULL DEFAULT 0
   ,"PollCompleted"                  tinyint NULL DEFAULT 0
   ,"DeleteRequest"                  long VARCHAR NULL
   ,"DeleteResponse"                 long VARCHAR NULL
   ,"DeleteTime"                     TIMESTAMP NULL
   ,"ListRequest"                    long VARCHAR NULL
   ,"ListResponse"                   long VARCHAR NULL
   ,PRIMARY KEY ("UTRcheckID" ASC) 
)
GO
 
 
ALTER TABLE "pears"."UTRCheck"
    ADD FOREIGN KEY "Person" ("personID" ASC)
    REFERENCES "pears"."Person" ("personid")
    ON DELETE CASCADE
GO