pears.PayrollCalendarWeek

• PayrollCalendarWeekID

• 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"."PayrollCalendarWeek"
-- Table comment: 
-- Statement count: 7
 
CREATE TABLE "pears"."PayrollCalendarWeek" (
    "PayrollCalendarWeekID"          INTEGER NOT NULL DEFAULT autoincrement
   ,"Period"                         INTEGER NOT NULL
   ,"Year"                           INTEGER NOT NULL
   ,"Week"                           INTEGER NOT NULL
   ,"WeekBeginning"                  DATE NOT NULL
   ,"WeekEnding"                     DATE NOT NULL
   ,PRIMARY KEY ("PayrollCalendarWeekID" ASC) 
)
GO
 
 
CREATE INDEX "payrollcalendarweek_idperiod" ON "pears"."PayrollCalendarWeek"
    ( "PayrollCalendarWeekID","Period" )
GO
 
 
CREATE INDEX "payrollcalendarweek_idyearweek" ON "pears"."PayrollCalendarWeek"
    ( "PayrollCalendarWeekID","Year","Week" )
GO
 
 
CREATE INDEX "payrollcalendarweek_periodweekbeginning" ON "pears"."PayrollCalendarWeek"
    ( "Period","WeekBeginning" )
GO
 
 
CREATE INDEX "payrollcalendarweek_periodweekending" ON "pears"."PayrollCalendarWeek"
    ( "Period","WeekEnding" )
GO
 
 
CREATE INDEX "payrollcalendarweek_yearweekbeginning" ON "pears"."PayrollCalendarWeek"
    ( "Year","Week","WeekBeginning" )
GO
 
 
CREATE INDEX "payrollcalendarweek_yearweekending" ON "pears"."PayrollCalendarWeek"
    ( "Year","Week","WeekEnding" )
GO