pears.MasterRoster

Header records for each Master Roster

• MasterRosterID

• No indexes found.

• No triggers found.

-- 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