pears.storedselection

Stored selection headers. Individual records that constitute the selection are in StoredSelectionMember.

• storedselectionid

• No indexes found.

• No triggers found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."storedselection"
-- Table comment: Stored selection headers. Individual records that constitute the selection are in StoredSelectionMember.
-- Statement count: 3
 
CREATE TABLE "pears"."storedselection" (
    "storedselectionid"              CHAR(20) NOT NULL
   ,"type"                           CHAR(1) NULL
   ,"description"                    CHAR(50) NULL
   ,"staffid"                        CHAR(20) NULL
   ,PRIMARY KEY ("storedselectionid" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."storedselection" IS 
	'Stored selection headers. Individual records that constitute the selection are in StoredSelectionMember.'
GO
 
 
ALTER TABLE "pears"."storedselection"
    ADD FOREIGN KEY "staff" ("staffid" ASC)
    REFERENCES "pears"."staff" ("staffid")
    ON DELETE CASCADE
GO