Table of Contents



pears.VacancyKeyWords

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
VacancyID char(20) NOT NULL
RefreshRequired tinyint NOT NULL 0
StandardKeyWords long varchar NULL
TagKeyWords long varchar NULL
CustomKeyWords long varchar NULL
TagRefreshRequired tinyint NOT NULL 0
CustomRefreshRequired tinyint NOT NULL 0

Primary Key

Foreign Keys

Referenced By

Indexes

Name Type Columns Detail
VacancyKeyWords_Refresh Index RefreshRequired
VacancyKeyWords_TagRefresh Index TagRefreshRequired
VacancyKeyWords_CustomRefresh Index CustomRefreshRequired
VacancyKeyWords_Text Text index StandardKeyWords, TagKeyWords, CustomKeyWords CONFIGURATION “SYS”.“default_char” IMMEDIATE REFRESH

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."VacancyKeyWords"
-- Table comment: 
-- Statement count: 5
 
CREATE TABLE "pears"."VacancyKeyWords" (
    "VacancyID"                      CHAR(20) NOT NULL
   ,"RefreshRequired"                tinyint NOT NULL DEFAULT 0
   ,"StandardKeyWords"               long VARCHAR NULL
   ,"TagKeyWords"                    long VARCHAR NULL
   ,"CustomKeyWords"                 long VARCHAR NULL
   ,"TagRefreshRequired"             tinyint NOT NULL DEFAULT 0
   ,"CustomRefreshRequired"          tinyint NOT NULL DEFAULT 0
   ,PRIMARY KEY ("VacancyID" ASC) 
)
GO
 
 
CREATE INDEX "VacancyKeyWords_Refresh" ON "pears"."VacancyKeyWords"
    ( "RefreshRequired" )
GO
 
 
CREATE INDEX "VacancyKeyWords_TagRefresh" ON "pears"."VacancyKeyWords"
    ( "TagRefreshRequired" )
GO
 
 
CREATE INDEX "VacancyKeyWords_CustomRefresh" ON "pears"."VacancyKeyWords"
    ( "CustomRefreshRequired" )
GO
 
 
CREATE TEXT INDEX "VacancyKeyWords_Text" ON "pears"."VacancyKeyWords"
    ( "StandardKeyWords","TagKeyWords","CustomKeyWords" ) CONFIGURATION "SYS"."default_char" IMMEDIATE REFRESH
GO