pears.storedsearch

Stored search headers. Individual criteria that constitute the search are stored in Criteria - with the appropiate location.

• storedsearchid

• No indexes found.

• No triggers found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."storedsearch"
-- Table comment: Stored search headers. Individual criteria that constitute the search are stored in Criteria - with the appropiate location.
-- Statement count: 5
 
CREATE TABLE "pears"."storedsearch" (
    "storedsearchid"                 CHAR(20) NOT NULL
   ,"type"                           CHAR(1) NULL
   ,"description"                    CHAR(50) NULL
   ,"currentonly"                    SMALLINT NULL
   ,"permtempboth"                   SMALLINT NULL
   ,"departmentid"                   CHAR(2) NULL
   ,"staffid"                        CHAR(20) NULL
   ,PRIMARY KEY ("storedsearchid" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."storedsearch"."currentonly" IS 
	'0: All Except Deleted 1: Current Only 2: Include Deleted'
GO
 
 
COMMENT ON COLUMN "pears"."storedsearch"."permtempboth" IS 
	'perm:1 temp:2 both:3'
GO
 
 
COMMENT ON TABLE "pears"."storedsearch" IS 
	'Stored search headers. Individual criteria that constitute the search are stored in Criteria - with the appropiate location.'
GO
 
 
ALTER TABLE "pears"."storedsearch"
    ADD FOREIGN KEY "staff" ("staffid" ASC)
    REFERENCES "pears"."staff" ("staffid")
    ON DELETE CASCADE
GO