Table of Contents



pears.storedselection

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

Description

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

Columns

Column Type Null Default Comment
storedselectionid char(20) NOT NULL
type char(1) NULL
description char(50) NULL
staffid char(20) NULL

Primary Key

Foreign Keys

Constraint Columns References Delete/update action
staff staffid pears.staff (staffid) ON DELETE CASCADE

Referenced By

Table Constraint Columns Referenced columns
pears.CascadeRule StoredSelection AgencyStoredSelectionID storedselectionid
pears.StoredQuickLookup StoredSelection StoredSelectionID storedselectionid
pears.storedselectionmember storedselection storedselectionid storedselectionid
pears.storedselectionstaff storedselection storedselectionid storedselectionid

Indexes

Triggers

Original SQL

-- 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