Table of Contents



pears.VacancySearchTemp

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

Columns

Column Type Null Default Comment
PK integer NOT NULL autoincrement
SearchInstanceID char(20) NULL
Personid char(20) NULL
UseThisOne smallint NULL 0

Primary Key

Foreign Keys

Referenced By

Indexes

Name Type Columns Detail
VacancySearchTemp_Person Index Personid
VacancySearchTemp_PersonInstance Index Personid, SearchInstanceID

Triggers

Original SQL

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