pears.VacancyKeyWords

• VacancyID

• 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"."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