pears.VacancySearchTemp

• PK

• 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"."VacancySearchTemp"
-- Table comment: 
-- Statement count: 3
 
CREATE GLOBAL TEMPORARY TABLE "pears"."VacancySearchTemp" (
    "PK"                             INTEGER NOT NULL DEFAULT autoincrement
   ,"SearchInstanceID"               CHAR(20) NULL
   ,"Personid"                       CHAR(20) NULL
   ,"UseThisOne"                     SMALLINT NULL DEFAULT 0
   ,PRIMARY KEY ("PK" ASC) 
) NOT TRANSACTIONAL
GO
 
 
CREATE INDEX "VacancySearchTemp_Person" ON "pears"."VacancySearchTemp"
    ( "Personid" )
GO
 
 
CREATE INDEX "VacancySearchTemp_PersonInstance" ON "pears"."VacancySearchTemp"
    ( "Personid","SearchInstanceID" )
GO