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

===== Description =====
Header records for each Master Roster

===== Columns =====
^ Column ^ Type ^ Null ^ Default ^ Comment ^
| **MasterRosterID** | char(20) | NOT NULL |  |  |
| VacancyID | char(20) | NOT NULL |  |  |
| Description | char(100) | NULL |  |  |
| Notes | long varchar | NULL |  |  |
| DaysInCycle | smallint | NOT NULL | 7 |  |
| ReviewDate | date | NULL |  |  |
| StartDate | date | NULL |  |  |
| Status | char(1) | NOT NULL | 1 | 1=Planning L=Live P=Paused T=Terminated |
| UseOnlyPreferred | tinyint | NOT NULL | 0 |  |

===== Primary Key =====
  * MasterRosterID

===== Foreign Keys =====
^ Constraint ^ Columns ^ References ^ Delete/update action ^
| Vacancy | VacancyID | [[database:tables:pears_vacancy|pears.vacancy (vacancyid)]] | NOT NULL; ON DELETE CASCADE |

===== Referenced By =====
^ Table ^ Constraint ^ Columns ^ Referenced columns ^
| [[database:tables:pears_masterrosterchangelog|pears.MasterRosterChangeLog]] | MasterRoster | MasterRosterID | MasterRosterID |
| [[database:tables:pears_masterrosterpreferredperson|pears.MasterRosterPreferredPerson]] | MasterRoster | MasterRosterID | MasterRosterID |
| [[database:tables:pears_masterrostershift|pears.MasterRosterShift]] | MasterRoster | MasterRosterID | MasterRosterID |

===== Indexes =====
  * No indexes found.

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

===== Original SQL =====
<code sql>
-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."MasterRoster"
-- Table comment: Header records for each Master Roster
-- Statement count: 4

CREATE TABLE "pears"."MasterRoster" (
    "MasterRosterID"                 char(20) NOT NULL
   ,"VacancyID"                      char(20) NOT NULL
   ,"Description"                    char(100) NULL
   ,"Notes"                          long varchar NULL
   ,"DaysInCycle"                    smallint NOT NULL DEFAULT 7
   ,"ReviewDate"                     date NULL
   ,"StartDate"                      date NULL
   ,"Status"                         char(1) NOT NULL DEFAULT 1
   ,"UseOnlyPreferred"               tinyint NOT NULL DEFAULT 0
   ,PRIMARY KEY ("MasterRosterID" ASC) 
)
go


COMMENT ON COLUMN "pears"."MasterRoster"."Status" IS 
	'1=Planning L=Live P=Paused T=Terminated'
go


COMMENT ON TABLE "pears"."MasterRoster" IS 
	'Header records for each Master Roster'
go


ALTER TABLE "pears"."MasterRoster"
    ADD NOT NULL FOREIGN KEY "Vacancy" ("VacancyID" ASC)
    REFERENCES "pears"."vacancy" ("vacancyid")
    ON DELETE CASCADE
go
</code>