pears.TempHoliday

A way of recording branch holidays - not used

• TempHolidayID

• No incoming foreign keys found.

• No triggers found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."TempHoliday"
-- Table comment: A way of recording branch holidays - not used
-- Statement count: 5
 
CREATE TABLE "pears"."TempHoliday" (
    "TempHolidayID"                  CHAR(20) NOT NULL
   ,"HolidayDate"                    DATE NOT NULL
   ,"agencyid"                       CHAR(20) NULL
   ,"ClientCode"                     CHAR(12) NULL
   ,PRIMARY KEY ("TempHolidayID" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."TempHoliday"."ClientCode" IS 
	'Referred to by company.tempholidaycode for client specific holidays'
GO
 
 
COMMENT ON TABLE "pears"."TempHoliday" IS 
	'A way of recording branch holidays - not used'
GO
 
 
ALTER TABLE "pears"."TempHoliday"
    ADD FOREIGN KEY "agencydetails" ("agencyid" ASC)
    REFERENCES "pears"."agencydetails" ("agencyid")
    ON DELETE SET NULL
GO
 
 
CREATE INDEX "TempHolidayDate" ON "pears"."TempHoliday"
    ( "HolidayDate" )
GO