pears.PersonKeyWords

• PersonID

• 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"."PersonKeyWords"
-- Table comment: 
-- Statement count: 5
 
CREATE TABLE "pears"."PersonKeyWords" (
    "PersonID"                       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 ("PersonID" ASC) 
)
GO
 
 
CREATE INDEX "PersonKeyWords_Refresh" ON "pears"."PersonKeyWords"
    ( "RefreshRequired" )
GO
 
 
CREATE INDEX "PersonKeyWords_TagRefresh" ON "pears"."PersonKeyWords"
    ( "TagRefreshRequired" )
GO
 
 
CREATE INDEX "PersonKeyWords_CustomRefresh" ON "pears"."PersonKeyWords"
    ( "CustomRefreshRequired" )
GO
 
 
CREATE TEXT INDEX "PersonKeyWords_Text" ON "pears"."PersonKeyWords"
    ( "StandardKeyWords","TagKeyWords","CustomKeyWords" ) CONFIGURATION "SYS"."default_char" IMMEDIATE REFRESH
GO