====== pears.MRShiftID2s ====== Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace. ===== Description ===== Temp Table - Used by Master Roster Process ===== Columns ===== ^ Column ^ Type ^ Null ^ Default ^ Comment ^ | InstID | char(20) | NULL | | | | SIDs | char(20) | NULL | | | | SDates | date | NULL | | | ===== Primary Key ===== * No primary key found in generated SQL. ===== Foreign Keys ===== * No outgoing foreign keys found. ===== Referenced By ===== * No incoming foreign keys found. ===== Indexes ===== * No indexes found. ===== Triggers ===== * No triggers found. ===== Original SQL ===== -- IQX database structure split by table -- Source: IQXDatabaseStructure - with comments.sql -- Table: "pears"."MRShiftID2s" -- Table comment: Temp Table - Used by Master Roster Process -- Statement count: 2 CREATE GLOBAL TEMPORARY TABLE "pears"."MRShiftID2s" ( "InstID" char(20) NULL ,"SIDs" char(20) NULL ,"SDates" date NULL ) ON COMMIT PRESERVE ROWS go COMMENT ON TABLE "pears"."MRShiftID2s" IS 'Temp Table - Used by Master Roster Process' go