====== pears.WPKForm ======
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
===== Description =====
Woodpecker Form definitions.
===== Columns =====
^ Column ^ Type ^ Null ^ Default ^ Comment ^
| **WPKFormID** | char(50) | NOT NULL | | |
| Name | char(50) | NOT NULL | | |
| FormType | char(20) | NOT NULL | | Single or Multiple. Defines whether there is a single master record for the form |
| VideoRecordType | char(50) | NULL | | Literal string or switch. The identity used by the video buttons when requesting a video movement from the parent form |
| Notes | long varchar | NULL | | |
| FormClass | char(50) | NULL | | Identifies a defined form in the application. Blank for the default form |
| FormSwitches | long varchar | NULL | | List (1 per line) of the names of the positional form switches. Un-named ones can be referenced by number |
| MasterView | char(50) | NULL | | Literal string or switch. Points to the primary view for editing and entering records on single record forms. Useful for caption, edit rights, colour etc |
| Caption | char(100) | NULL | | Literal string or switch. May use e.g. Q_Caption to reference control query, or New {G_CoTitle} |
| Colour | char(100) | NULL | | Literal integer or switch |
| DefaultLayout | char(50) | NULL | | Literal string or switch |
| DefaultDetailView | char(50) | NULL | | Literal string or switch. Will be shown in bottom panel IF can be viewed and can be selected from current layout |
| CanEdit | char(100) | NULL | | Literal boolean or switch - often a R_ role switch |
| FormWidth | char(50) | NULL | | Literal integer or switch. Default taken from form |
| FormHeight | char(50) | NULL | | Literal integer or switch. Default taken from form |
| FormTop | char(50) | NULL | | Literal integer or switch. Default taken from form |
| FormLeft | char(50) | NULL | | Literal integer or switch. Default taken from form |
| UpdateCallerFlag | tinyint | NULL | 0 | 0 Never 1 Always 2 New records only |
| TestSwitches | long varchar | NULL | | Passed into form when testing. One switch per line |
===== Primary Key =====
* WPKFormID
===== Foreign Keys =====
* No outgoing foreign keys found.
===== Referenced By =====
^ Table ^ Constraint ^ Columns ^ Referenced columns ^
| [[database:tables:pears_wpklayout|pears.WPKLayout]] | WPKForm | WPKFormID | WPKFormID |
| [[database:tables:pears_wpkview|pears.WPKView]] | WPKForm | WPKFormID | WPKFormID |
===== Indexes =====
* No indexes found.
===== Triggers =====
^ Name ^ Timing ^ Event ^
| WPKTrackFormChange | after | insert,delete,update order 1 |
===== Original SQL =====
-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."WPKForm"
-- Table comment: Woodpecker Form definitions.
-- Statement count: 20
CREATE TABLE "pears"."WPKForm" (
"WPKFormID" char(50) NOT NULL INLINE 50 PREFIX 8
,"Name" char(50) NOT NULL
,"FormType" char(20) NOT NULL
,"VideoRecordType" char(50) NULL
,"Notes" long varchar NULL
,"FormClass" char(50) NULL
,"FormSwitches" long varchar NULL
,"MasterView" char(50) NULL
,"Caption" char(100) NULL
,"Colour" char(100) NULL INLINE 100 PREFIX 8
,"DefaultLayout" char(50) NULL
,"DefaultDetailView" char(50) NULL
,"CanEdit" char(100) NULL INLINE 100 PREFIX 8
,"FormWidth" char(50) NULL
,"FormHeight" char(50) NULL
,"FormTop" char(50) NULL
,"FormLeft" char(50) NULL
,"UpdateCallerFlag" tinyint NULL DEFAULT 0
,"TestSwitches" long varchar NULL
,PRIMARY KEY ("WPKFormID" ASC)
)
go
COMMENT ON COLUMN "pears"."WPKForm"."FormType" IS
'Single or Multiple. Defines whether there is a single master record for the form'
go
COMMENT ON COLUMN "pears"."WPKForm"."VideoRecordType" IS
'Literal string or switch. The identity used by the video buttons when requesting a video movement from the parent form'
go
COMMENT ON COLUMN "pears"."WPKForm"."FormClass" IS
'Identifies a defined form in the application. Blank for the default form'
go
COMMENT ON COLUMN "pears"."WPKForm"."FormSwitches" IS
'List (1 per line) of the names of the positional form switches. Un-named ones can be referenced by number'
go
COMMENT ON COLUMN "pears"."WPKForm"."MasterView" IS
'Literal string or switch. Points to the primary view for editing and entering records on single record forms. Useful for caption, edit rights, colour etc'
go
COMMENT ON COLUMN "pears"."WPKForm"."Caption" IS
'Literal string or switch. May use e.g. Q_Caption to reference control query, or New {G_CoTitle}'
go
COMMENT ON COLUMN "pears"."WPKForm"."Colour" IS
'Literal integer or switch'
go
COMMENT ON COLUMN "pears"."WPKForm"."DefaultLayout" IS
'Literal string or switch'
go
COMMENT ON COLUMN "pears"."WPKForm"."DefaultDetailView" IS
'Literal string or switch. Will be shown in bottom panel IF can be viewed and can be selected from current layout'
go
COMMENT ON COLUMN "pears"."WPKForm"."CanEdit" IS
'Literal boolean or switch - often a R_ role switch'
go
COMMENT ON COLUMN "pears"."WPKForm"."FormWidth" IS
'Literal integer or switch. Default taken from form'
go
COMMENT ON COLUMN "pears"."WPKForm"."FormHeight" IS
'Literal integer or switch. Default taken from form'
go
COMMENT ON COLUMN "pears"."WPKForm"."FormTop" IS
'Literal integer or switch. Default taken from form'
go
COMMENT ON COLUMN "pears"."WPKForm"."FormLeft" IS
'Literal integer or switch. Default taken from form'
go
COMMENT ON COLUMN "pears"."WPKForm"."UpdateCallerFlag" IS
'0 Never 1 Always 2 New records only'
go
COMMENT ON COLUMN "pears"."WPKForm"."TestSwitches" IS
'Passed into form when testing. One switch per line'
go
COMMENT ON TABLE "pears"."WPKForm" IS
'Woodpecker Form definitions.'
go
create trigger "WPKTrackFormChange" after insert,delete,update order 1 on
"pears"."WPKForm"
referencing new as "frm"
for each row
begin
call "WPKTrackChange"('F',"frm"."WPKFormID")
end
go
COMMENT TO PRESERVE FORMAT ON TRIGGER "pears"."WPKForm"."WPKTrackFormChange" IS
{create trigger WPKTrackFormChange
after insert,delete,update order 1 on
WPKForm
referencing new as frm
for each row
begin
call WPKTrackChange('F',frm.WPKFormID)
end
}
go