====== pears.PayrollCalendarWeek ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

===== Columns =====
^ Column ^ Type ^ Null ^ Default ^ Comment ^
| **PayrollCalendarWeekID** | integer | NOT NULL | autoincrement |  |
| Period | integer | NOT NULL |  |  |
| Year | integer | NOT NULL |  |  |
| Week | integer | NOT NULL |  |  |
| WeekBeginning | date | NOT NULL |  |  |
| WeekEnding | date | NOT NULL |  |  |

===== Primary Key =====
  * PayrollCalendarWeekID

===== Foreign Keys =====
  * No outgoing foreign keys found.

===== Referenced By =====
  * No incoming foreign keys found.

===== Indexes =====
^ Name ^ Type ^ Columns ^ Detail ^
| payrollcalendarweek_idperiod | Index | PayrollCalendarWeekID, Period |  |
| payrollcalendarweek_idyearweek | Index | PayrollCalendarWeekID, Year, Week |  |
| payrollcalendarweek_periodweekbeginning | Index | Period, WeekBeginning |  |
| payrollcalendarweek_periodweekending | Index | Period, WeekEnding |  |
| payrollcalendarweek_yearweekbeginning | Index | Year, Week, WeekBeginning |  |
| payrollcalendarweek_yearweekending | Index | Year, Week, WeekEnding |  |

===== Triggers =====
  * No triggers found.

===== Original SQL =====
<code sql>
-- 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
</code>