Table of Contents



pears.IXSStatus

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.

Description

Status of current searches.

Columns

Column Type Null Default Comment
IXSQueryID char(20) NOT NULL
IXSQueryGroup char(20) NULL For group deletions
Catalog char(100) NULL
Scope char(250) NULL
Query char(250) NULL
QueryTime timestamp NULL current timestamp
Status smallint NULL 0 0=newly added, Positive=successfully completed, Negative=completed with error

Primary Key

Foreign Keys

Referenced By

Table Constraint Columns Referenced columns
pears.IXSResult IXSStatus IXSQueryID IXSQueryID

Indexes

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."IXSStatus"
-- Table comment: Status of current searches.
-- Statement count: 4
 
CREATE TABLE "pears"."IXSStatus" (
    "IXSQueryID"                     CHAR(20) NOT NULL
   ,"IXSQueryGroup"                  CHAR(20) NULL
   ,"Catalog"                        CHAR(100) NULL
   ,"Scope"                          CHAR(250) NULL
   ,"Query"                          CHAR(250) NULL
   ,"QueryTime"                      TIMESTAMP NULL DEFAULT CURRENT TIMESTAMP
   ,"Status"                         SMALLINT NULL DEFAULT 0
   ,PRIMARY KEY ("IXSQueryID" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."IXSStatus"."IXSQueryGroup" IS 
	'For group deletions'
GO
 
 
COMMENT ON COLUMN "pears"."IXSStatus"."Status" IS 
	'0=newly added, Positive=successfully completed, Negative=completed with error'
GO
 
 
COMMENT ON TABLE "pears"."IXSStatus" IS 
	'Status of current searches.'
GO