pears.WPKCustomGridColumnNamedSelection

Woodpecker Custom Column Definitions

• Name, DivisionID, WPKFormID, WPKViewID, WPKCustomGridColumnID

• No outgoing foreign keys found.

• No incoming foreign keys found.

• No indexes found.

• No triggers found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."WPKCustomGridColumnNamedSelection"
-- Table comment: Woodpecker Custom Column Definitions
-- Statement count: 4
 
CREATE TABLE "pears"."WPKCustomGridColumnNamedSelection" (
    "Name"                           CHAR(50) NOT NULL DEFAULT 'DEFAULT'
   ,"DivisionID"                     CHAR(20) NOT NULL DEFAULT 'DEFAULT'
   ,"WPKFormID"                      CHAR(50) NOT NULL
   ,"WPKViewID"                      CHAR(50) NOT NULL
   ,"WPKCustomGridColumnID"          CHAR(50) NOT NULL
   ,"Position"                       SMALLINT NULL DEFAULT 0
   ,PRIMARY KEY ("Name" ASC,"DivisionID" ASC,"WPKFormID" ASC,"WPKViewID" ASC,"WPKCustomGridColumnID" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."WPKCustomGridColumnNamedSelection"."WPKCustomGridColumnID" IS 
	'May refer to a WPKViewItemID to over-ride position or visibility, or may be custom'
GO
 
 
COMMENT ON COLUMN "pears"."WPKCustomGridColumnNamedSelection"."Position" IS 
	'Orders the items in a view. 1 for extreme left. 0 to hide the item.'
GO
 
 
COMMENT ON TABLE "pears"."WPKCustomGridColumnNamedSelection" IS 
	'Woodpecker Custom Column Definitions'
GO