Table of Contents



pears.NotificationBatch

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
ID bigint NOT NULL 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

Foreign Keys

Referenced By

Indexes

Name Type Columns Detail
NotificationBatchID Index BatchID, ID

Triggers

Original SQL

-- 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