Table of Contents



pears.WPKImage

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

Description

Images (eg icons) Used by Woodpecker Forms.

Columns

Column Type Null Default Comment
WPKImageID char(20) NOT NULL
Name char(50) NOT NULL
Image long binary NULL
Notes long varchar NULL

Primary Key

Foreign Keys

Referenced By

Indexes

Triggers

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

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."WPKImage"
-- Table comment: Images (eg icons) Used by Woodpecker Forms.
-- Statement count: 4
 
CREATE TABLE "pears"."WPKImage" (
    "WPKImageID"                     CHAR(20) NOT NULL
   ,"Name"                           CHAR(50) NOT NULL
   ,"Image"                          long BINARY NULL
   ,"Notes"                          long VARCHAR NULL
   ,PRIMARY KEY ("WPKImageID" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."WPKImage" IS 
	'Images (eg icons) Used by Woodpecker Forms.'
GO
 
 
CREATE TRIGGER "WPKTrackImageChange" after INSERT,DELETE,UPDATE ORDER 1 ON
"pears"."WPKImage"
FOR each statement
BEGIN
  CALL "WPKTrackChange"('I','*')
END
GO
 
 
COMMENT TO PRESERVE FORMAT ON TRIGGER "pears"."WPKImage"."WPKTrackImageChange" IS 
{CREATE TRIGGER WPKTrackImageChange 
 after INSERT,DELETE,UPDATE ORDER 1 ON
WPKImage
FOR each statement
BEGIN
  CALL WPKTrackChange('I','*')
END
}
GO