pears.PayrollCalendar

• PayrollCalendarID

• 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"."PayrollCalendar"
-- Table comment: 
-- Statement count: 5
 
CREATE TABLE "pears"."PayrollCalendar" (
    "PayrollCalendarID"              INTEGER NOT NULL DEFAULT autoincrement
   ,"TheDate"                        DATE NOT NULL
   ,"Period"                         INTEGER NULL
   ,"Year"                           INTEGER NULL
   ,"Week"                           INTEGER NULL
   ,"WeekBeginning"                  DATE NULL
   ,"WeekEnding"                     DATE NULL
   ,PRIMARY KEY ("PayrollCalendarID" ASC) 
)
GO
 
 
CREATE INDEX "payrollcalendar_thedateperiod" ON "pears"."PayrollCalendar"
    ( "TheDate","Period" )
GO
 
 
CREATE INDEX "payrollcalendar_thedateweekbeginning" ON "pears"."PayrollCalendar"
    ( "TheDate","WeekBeginning" )
GO
 
 
CREATE INDEX "payrollcalendar_thedateweekending" ON "pears"."PayrollCalendar"
    ( "TheDate","WeekEnding" )
GO
 
 
CREATE INDEX "payrollcalendar_thedateyearweek" ON "pears"."PayrollCalendar"
    ( "TheDate","Year","Week" )
GO