Table of Contents



pears.NotificationRates

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

Foreign Keys

Referenced By

Indexes

Name Type Columns Detail
NotificationTempShiftID Index TempShiftID

Triggers

Original SQL

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