Table of Contents



pears.WPKCustomGridColumn

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

Description

Woodpecker Custom Column Definitions

Columns

Column Type Null Default Comment
DivisionID char(20) NOT NULL 'DEFAULT' Not necessarily DivisionID at all so no foreign key
WPKFormID char(50) NOT NULL
WPKViewID char(50) NOT NULL
WPKCustomGridColumnID char(50) NOT NULL May refer to a WPKViewItemID to over-ride position or visibility, or may be custom
Name char(50) NULL
Position smallint NULL 0 Orders the items in a view. 1 for extreme left. 0 to hide the item.
ItemType char(20) NULL DataField,LookupCombo,CheckBox,Question,Phone,Concatenated
DataType char(1) NULL String, Date, Time, Integer, Number, timestamP, Memo
DataLength smallint NULL For String fields
DisplayFormat char(50) NULL Literal string or switch - applies to numbers, dates, times etc but not strings
Descriptor long varchar NULL table.column, sql expression, concatenation expression, Questions- taglocation;tagid;id {} substitutions apply
PickList long varchar NULL Literal string or switch. For Combo
CheckValues char(20) NULL For CheckBox. checked;unchecked Default 1;0
Sortable tinyint NULL 0 0 no, 1 yes, 2 default order (The first 2 is the starting order otherwise the first 1)
SortExpression char(100) NULL Default is the column itself
DisplaySize smallint NULL 10 Col width for Grids
SortOrder smallint NULL
Mask char(50) NULL
Notes long varchar NULL

Primary Key

Foreign Keys

Referenced By

Indexes

Name Type Columns Detail
WPKCustGridCol Index WPKFormID, WPKViewID

Triggers

Name Timing Event
TrackCustomGridColumnChange after insert,delete,update order 1

Original SQL

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