Table of Contents



pears.WPKLayout

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

Description

Woodpecker Layout definitions.

Columns

Column Type Null Default Comment
WPKLayoutID char(20) NOT NULL
WPKFormID char(50) NOT NULL
Name char(50) NOT NULL
Notes long varchar NULL
SortOrder smallint NULL Orders the lists on the outlook bar
CanSelect char(100) NULL Literal boolean or switch controlling availability in outlook bar. If switched off can still be used explicitly or as form default
TopLeftView char(50) NULL Literal string or switch
TopRightView char(50) NULL Literal string or switch
MenuWidth char(50) NULL Literal integer or switch
TopSplitPercent char(50) NULL Literal integer or switch. Default 50%
MiddleSplitPercent char(50) NULL Literal integer or switch. Default 50%
Image char(50) NULL Literal string or switch pointing to the wpkimageid to be used for the group button on the outlook bar
Wizard tinyint NULL 0 The layout behaves as a wizard with the layout views as pages
WizardFinishScript long varchar NULL Invoked on clicking Finish in wizard. If not specified defaults to standard save and refresh
ShowMenuImages char(50) NULL Literal boolean or switch enabling images on the outlook bar

Primary Key

Foreign Keys

Constraint Columns References Delete/update action
WPKForm WPKFormID pears.WPKForm (WPKFormID) NOT NULL; ON DELETE CASCADE

Referenced By

Table Constraint Columns Referenced columns
pears.WPKLayoutView Layout WPKLayoutID, WPKFormID WPKLayoutID, WPKFormID
pears.WPKLayoutViewStaff Layout WPKLayoutID, WPKFormID WPKLayoutID, WPKFormID

Indexes

Triggers

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

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."WPKLayout"
-- Table comment: Woodpecker Layout definitions.
-- Statement count: 16
 
CREATE TABLE "pears"."WPKLayout" (
    "WPKLayoutID"                    CHAR(20) NOT NULL
   ,"WPKFormID"                      CHAR(50) NOT NULL INLINE 50 PREFIX 8
   ,"Name"                           CHAR(50) NOT NULL
   ,"Notes"                          long VARCHAR NULL
   ,"SortOrder"                      SMALLINT NULL
   ,"CanSelect"                      CHAR(100) NULL INLINE 100 PREFIX 8
   ,"TopLeftView"                    CHAR(50) NULL
   ,"TopRightView"                   CHAR(50) NULL
   ,"MenuWidth"                      CHAR(50) NULL
   ,"TopSplitPercent"                CHAR(50) NULL
   ,"MiddleSplitPercent"             CHAR(50) NULL
   ,"Image"                          CHAR(50) NULL
   ,"Wizard"                         tinyint NULL DEFAULT 0
   ,"WizardFinishScript"             long VARCHAR NULL
   ,"ShowMenuImages"                 CHAR(50) NULL
   ,PRIMARY KEY ("WPKLayoutID" ASC,"WPKFormID" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."WPKLayout"."SortOrder" IS 
	'Orders the lists on the outlook bar'
GO
 
 
COMMENT ON COLUMN "pears"."WPKLayout"."CanSelect" IS 
	'Literal boolean or switch controlling availability in outlook bar. If switched off can still be used explicitly or as form default'
GO
 
 
COMMENT ON COLUMN "pears"."WPKLayout"."TopLeftView" IS 
	'Literal string or switch'
GO
 
 
COMMENT ON COLUMN "pears"."WPKLayout"."TopRightView" IS 
	'Literal string or switch'
GO
 
 
COMMENT ON COLUMN "pears"."WPKLayout"."MenuWidth" IS 
	'Literal integer or switch'
GO
 
 
COMMENT ON COLUMN "pears"."WPKLayout"."TopSplitPercent" IS 
	'Literal integer or switch. Default 50%'
GO
 
 
COMMENT ON COLUMN "pears"."WPKLayout"."MiddleSplitPercent" IS 
	'Literal integer or switch. Default 50%'
GO
 
 
COMMENT ON COLUMN "pears"."WPKLayout"."Image" IS 
	'Literal string or switch pointing to the wpkimageid to be used for the group button on the outlook bar'
GO
 
 
COMMENT ON COLUMN "pears"."WPKLayout"."Wizard" IS 
	'The layout behaves as a wizard with the layout views as pages'
GO
 
 
COMMENT ON COLUMN "pears"."WPKLayout"."WizardFinishScript" IS 
	'Invoked on clicking Finish in wizard. If not specified defaults to standard save and refresh'
GO
 
 
COMMENT ON COLUMN "pears"."WPKLayout"."ShowMenuImages" IS 
	'Literal boolean or switch enabling images on the outlook bar'
GO
 
 
COMMENT ON TABLE "pears"."WPKLayout" IS 
	'Woodpecker Layout definitions.'
GO
 
 
ALTER TABLE "pears"."WPKLayout"
    ADD NOT NULL FOREIGN KEY "WPKForm" ("WPKFormID" ASC)
    REFERENCES "pears"."WPKForm" ("WPKFormID")
    ON DELETE CASCADE
GO
 
 
CREATE TRIGGER "TrackLayoutChange" after INSERT,DELETE,UPDATE ORDER 1 ON
"pears"."WPKLayout"
REFERENCING NEW AS "lay"
FOR each ROW
BEGIN
  CALL "WPKTrackChange"('F',"lay"."WPKFormID")
END
GO
 
 
COMMENT TO PRESERVE FORMAT ON TRIGGER "pears"."WPKLayout"."TrackLayoutChange" IS 
{CREATE TRIGGER TrackLayoutChange 
 after INSERT,DELETE,UPDATE ORDER 1 ON
WPKLayout
REFERENCING NEW AS lay
FOR each ROW
BEGIN
  CALL WPKTrackChange('F',lay.WPKFormID)
END
}
GO