pears.IXSResult

Used for temporarily storing Index Server search results.

• IXSQueryID, RecordID

• No incoming foreign keys found.

• No triggers found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."IXSResult"
-- Table comment: Used for temporarily storing Index Server search results.
-- Statement count: 4
 
CREATE TABLE "pears"."IXSResult" (
    "IXSQueryID"                     CHAR(20) NOT NULL
   ,"RecordID"                       CHAR(20) NOT NULL
   ,"Score"                          INTEGER NULL
   ,"HitCount"                       INTEGER NULL
   ,"Rank"                           INTEGER NULL
   ,PRIMARY KEY ("IXSQueryID" ASC,"RecordID" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."IXSResult" IS 
	'Used for temporarily storing Index Server search results.'
GO
 
 
ALTER TABLE "pears"."IXSResult"
    ADD NOT NULL FOREIGN KEY "IXSStatus" ("IXSQueryID" ASC)
    REFERENCES "pears"."IXSStatus" ("IXSQueryID")
    ON DELETE CASCADE
GO
 
 
CREATE UNIQUE INDEX "IXSResultRecID" ON "pears"."IXSResult"
    ( "RecordID","IXSQueryID" )
GO