pears.WPKCustomGridColumn

Woodpecker Custom Column Definitions

• DivisionID, WPKFormID, WPKViewID, WPKCustomGridColumnID

• No outgoing foreign keys found.

• No incoming foreign keys found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."WPKCustomGridColumn"
-- Table comment: Woodpecker Custom Column Definitions
-- Statement count: 18
 
CREATE TABLE "pears"."WPKCustomGridColumn" (
    "DivisionID"                     CHAR(20) NOT NULL DEFAULT 'DEFAULT'
   ,"WPKFormID"                      CHAR(50) NOT NULL
   ,"WPKViewID"                      CHAR(50) NOT NULL
   ,"WPKCustomGridColumnID"          CHAR(50) NOT NULL
   ,"Name"                           CHAR(50) NULL
   ,"Position"                       SMALLINT NULL DEFAULT 0
   ,"ItemType"                       CHAR(20) NULL
   ,"DataType"                       CHAR(1) NULL
   ,"DataLength"                     SMALLINT NULL
   ,"DisplayFormat"                  CHAR(50) NULL
   ,"Descriptor"                     long VARCHAR NULL
   ,"PickList"                       long VARCHAR NULL
   ,"CheckValues"                    CHAR(20) NULL
   ,"Sortable"                       tinyint NULL DEFAULT 0
   ,"SortExpression"                 CHAR(100) NULL
   ,"DisplaySize"                    SMALLINT NULL DEFAULT 10
   ,"SortOrder"                      SMALLINT NULL
   ,"Mask"                           CHAR(50) NULL
   ,"Notes"                          long VARCHAR NULL
   ,PRIMARY KEY ("DivisionID" ASC,"WPKFormID" ASC,"WPKViewID" ASC,"WPKCustomGridColumnID" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."WPKCustomGridColumn"."DivisionID" IS 
	'Not necessarily DivisionID at all so no foreign key'
GO
 
 
COMMENT ON COLUMN "pears"."WPKCustomGridColumn"."WPKCustomGridColumnID" IS 
	'May refer to a WPKViewItemID to over-ride position or visibility, or may be custom'
GO
 
 
COMMENT ON COLUMN "pears"."WPKCustomGridColumn"."Position" IS 
	'Orders the items in a view. 1 for extreme left. 0 to hide the item.'
GO
 
 
COMMENT ON COLUMN "pears"."WPKCustomGridColumn"."ItemType" IS 
	'DataField,LookupCombo,CheckBox,Question,Phone,Concatenated'
GO
 
 
COMMENT ON COLUMN "pears"."WPKCustomGridColumn"."DataType" IS 
	'String, Date, Time, Integer, Number, timestamP, Memo'
GO
 
 
COMMENT ON COLUMN "pears"."WPKCustomGridColumn"."DataLength" IS 
	'For String fields'
GO
 
 
COMMENT ON COLUMN "pears"."WPKCustomGridColumn"."DisplayFormat" IS 
	'Literal string or switch - applies to numbers, dates, times etc but not strings'
GO
 
 
COMMENT ON COLUMN "pears"."WPKCustomGridColumn"."Descriptor" IS 
	'table.column, sql expression, concatenation expression, Questions- taglocation;tagid;id  {} substitutions apply'
GO
 
 
COMMENT ON COLUMN "pears"."WPKCustomGridColumn"."PickList" IS 
	'Literal string or switch. For Combo'
GO
 
 
COMMENT ON COLUMN "pears"."WPKCustomGridColumn"."CheckValues" IS 
	'For CheckBox. checked;unchecked   Default 1;0'
GO
 
 
COMMENT ON COLUMN "pears"."WPKCustomGridColumn"."Sortable" IS 
	'0 no, 1 yes, 2 default order (The first 2 is the starting order otherwise the first 1)'
GO
 
 
COMMENT ON COLUMN "pears"."WPKCustomGridColumn"."SortExpression" IS 
	'Default is the column itself'
GO
 
 
COMMENT ON COLUMN "pears"."WPKCustomGridColumn"."DisplaySize" IS 
	'Col width for Grids'
GO
 
 
COMMENT ON TABLE "pears"."WPKCustomGridColumn" IS 
	'Woodpecker Custom Column Definitions'
GO
 
 
CREATE INDEX "WPKCustGridCol" ON "pears"."WPKCustomGridColumn"
    ( "WPKFormID","WPKViewID" )
GO
 
 
CREATE TRIGGER "TrackCustomGridColumnChange" after INSERT,DELETE,UPDATE ORDER 1 ON
"pears"."WPKCustomGridColumn"
REFERENCING NEW AS "itm"
FOR each ROW
BEGIN
  CALL "WPKTrackChange"('F',"itm"."WPKFormID")
END
GO
 
 
COMMENT TO PRESERVE FORMAT ON TRIGGER "pears"."WPKCustomGridColumn"."TrackCustomGridColumnChange" IS 
{CREATE TRIGGER TrackCustomGridColumnChange 
 after INSERT,DELETE,UPDATE ORDER 1 ON
WPKCustomGridColumn
REFERENCING NEW AS itm
FOR each ROW
BEGIN
  CALL WPKTrackChange('F',itm.WPKFormID)
END
}
GO