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