pears.AWRWeekFind

Temporary table. Used during calculation of AWR qualifying periods.

• No primary key found in generated SQL.

• No outgoing foreign keys found.

• No incoming foreign keys found.

• No triggers found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."AWRWeekFind"
-- Table comment: Temporary table. Used during calculation of AWR qualifying periods.
-- Statement count: 4
 
CREATE GLOBAL TEMPORARY TABLE "pears"."AWRWeekFind" (
    "AWRJobMasterID"                 CHAR(20) NOT NULL
   ,"DataGenerated"                  TIMESTAMP NOT NULL
   ,"ThisPeriod"                     INTEGER NOT NULL
   ,"Qual"                           SMALLINT NULL
) ON COMMIT PRESERVE ROWS
GO
 
 
COMMENT ON TABLE "pears"."AWRWeekFind" IS 
	'Temporary table. Used during calculation of AWR qualifying periods.'
GO
 
 
CREATE INDEX "AWRWeekFind_JobMasterGeneratedAllPer" ON "pears"."AWRWeekFind"
    ( "AWRJobMasterID","DataGenerated","ThisPeriod" )
GO
 
 
CREATE INDEX "AWRWeekFindbyDataGenerated" ON "pears"."AWRWeekFind"
    ( "DataGenerated" )
GO