pears.NotificationRates

• 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"."NotificationRates"
-- Table comment: 
-- Statement count: 2
 
CREATE GLOBAL TEMPORARY TABLE "pears"."NotificationRates" (
    "ID"                             BIGINT NOT NULL DEFAULT autoincrement
   ,"LineNumber"                     INTEGER NULL
   ,"TempShiftID"                    CHAR(20) NULL
   ,"TempPayBandID"                  CHAR(20) NULL
   ,"payrate"                        DOUBLE NULL
   ,"chargerate"                     DOUBLE NULL
   ,"grade"                          CHAR(4) NULL
   ,"filter1"                        CHAR(4) NULL
   ,"filter2"                        CHAR(4) NULL
   ,"description"                    CHAR(50) NULL
   ,PRIMARY KEY ("ID" ASC) 
) ON COMMIT PRESERVE ROWS
GO
 
 
CREATE INDEX "NotificationTempShiftID" ON "pears"."NotificationRates"
    ( "TempShiftID" )
GO