Table of Contents



pears.CompanyKeyWords

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
CompanyID 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
CompanyKeyWords_Refresh Index RefreshRequired
CompanyKeyWords_TagRefresh Index TagRefreshRequired
CompanyKeyWords_CustomRefresh Index CustomRefreshRequired
CompanyKeyWords_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"."CompanyKeyWords"
-- Table comment: 
-- Statement count: 5
 
CREATE TABLE "pears"."CompanyKeyWords" (
    "CompanyID"                      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 ("CompanyID" ASC) 
)
GO
 
 
CREATE INDEX "CompanyKeyWords_Refresh" ON "pears"."CompanyKeyWords"
    ( "RefreshRequired" )
GO
 
 
CREATE INDEX "CompanyKeyWords_TagRefresh" ON "pears"."CompanyKeyWords"
    ( "TagRefreshRequired" )
GO
 
 
CREATE INDEX "CompanyKeyWords_CustomRefresh" ON "pears"."CompanyKeyWords"
    ( "CustomRefreshRequired" )
GO
 
 
CREATE TEXT INDEX "CompanyKeyWords_Text" ON "pears"."CompanyKeyWords"
    ( "StandardKeyWords","TagKeyWords","CustomKeyWords" ) CONFIGURATION "SYS"."default_char" IMMEDIATE REFRESH
GO