pears.NotificationBatch

• ID

• No outgoing foreign keys found.

• No incoming foreign keys found.

• No triggers found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."NotificationBatch"
-- Table comment: 
-- Statement count: 2
 
CREATE GLOBAL TEMPORARY TABLE "pears"."NotificationBatch" (
    "ID"                             BIGINT NOT NULL DEFAULT autoincrement
   ,"BatchID"                        CHAR(20) NOT NULL
   ,"PersonID"                       CHAR(20) NULL
   ,"CompanyID"                      CHAR(20) NULL
   ,"EmploymentID"                   CHAR(20) NULL
   ,"VacancyID"                      CHAR(20) NULL
   ,"PlacementID"                    CHAR(20) NULL
   ,"ProgressID"                     CHAR(20) NULL
   ,"DivisionID"                     CHAR(20) NULL
   ,"StaffID"                        CHAR(20) NULL
   ,"AgencyEmploymentID"             CHAR(20) NULL
   ,"DiaryID"                        CHAR(20) NULL
   ,"TemplateHTML"                   long VARCHAR NULL
   ,"Subject"                        CHAR(200) NULL
   ,"Attachments"                    long VARCHAR NULL
   ,"SubjectIDsWithType"             long VARCHAR NULL
   ,"classcode"                      CHAR(2) NULL
   ,PRIMARY KEY ("ID" ASC) 
) ON COMMIT PRESERVE ROWS
GO
 
 
CREATE INDEX "NotificationBatchID" ON "pears"."NotificationBatch"
    ( "BatchID","ID" )
GO