pears.WPKPickList

Woodpecker centrally defined (and therefore cached and re-suable) pick lists. Defined either by SQL or choices listed in WPKPickListChoice.

• WPKPickListID

• No outgoing foreign keys found.

• No indexes found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."WPKPickList"
-- Table comment: Woodpecker centrally defined (and therefore cached and re-suable) pick lists. Defined either by SQL or choices listed in WPKPickListChoice.
-- Statement count: 6
 
CREATE TABLE "pears"."WPKPickList" (
    "WPKPickListID"                  CHAR(20) NOT NULL
   ,"Name"                           CHAR(50) NOT NULL
   ,"SQLQuery"                       long VARCHAR NULL
   ,"Notes"                          long VARCHAR NULL
   ,"AltWPKTrackerID"                CHAR(100) NULL
   ,PRIMARY KEY ("WPKPickListID" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."WPKPickList"."SQLQuery" IS 
	'select description,value from ...  If blank uses the WPKPickListChoice items'
GO
 
 
COMMENT ON COLUMN "pears"."WPKPickList"."AltWPKTrackerID" IS 
	'Allows subset sql query lists to track changes to the table as a whole (or MULTIPLE tables - use comma sep list) for simplicity of maintenance'
GO
 
 
COMMENT ON TABLE "pears"."WPKPickList" IS 
	'Woodpecker centrally defined (and therefore cached and re-suable) pick lists. Defined either by SQL or choices listed in WPKPickListChoice.'
GO
 
 
CREATE TRIGGER "WPKPickChange" after INSERT,DELETE,UPDATE ORDER 1 ON
"pears"."WPKPickList"
REFERENCING NEW AS "lst"
FOR each ROW
BEGIN
  CALL "WPKTrackChange"('P',"lst"."WPKPickListID");
  CALL "WPKTrackChange"('P','*')
END
GO
 
 
COMMENT TO PRESERVE FORMAT ON TRIGGER "pears"."WPKPickList"."WPKPickChange" IS 
{CREATE TRIGGER WPKPickChange 
 after INSERT,DELETE,UPDATE ORDER 1 ON
WPKPickList
REFERENCING NEW AS lst
FOR each ROW
BEGIN
  CALL WPKTrackChange('P',lst.WPKPickListID);
  CALL WPKTrackChange('P','*')
END
}
GO