Table of Contents



pears.PersonKeyWords

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
PersonID 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
PersonKeyWords_Refresh Index RefreshRequired
PersonKeyWords_TagRefresh Index TagRefreshRequired
PersonKeyWords_CustomRefresh Index CustomRefreshRequired
PersonKeyWords_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"."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