====== pears.WPKMultiSelection ======
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
===== Description =====
Temp Table - used to list records selected on a Woodpecker grid.
===== Columns =====
^ Column ^ Type ^ Null ^ Default ^ Comment ^
| **GroupID** | char(20) | NOT NULL | | |
| **RecordID** | char(20) | NOT NULL | | |
===== Primary Key =====
* GroupID, RecordID
===== Foreign Keys =====
* No outgoing foreign keys found.
===== Referenced By =====
* No incoming foreign keys found.
===== Indexes =====
* No indexes found.
===== Triggers =====
* No triggers found.
===== Original SQL =====
-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."WPKMultiSelection"
-- Table comment: Temp Table - used to list records selected on a Woodpecker grid.
-- Statement count: 2
CREATE GLOBAL TEMPORARY TABLE "pears"."WPKMultiSelection" (
"GroupID" char(20) NOT NULL
,"RecordID" char(20) NOT NULL
,PRIMARY KEY ("GroupID" ASC,"RecordID" ASC)
) ON COMMIT PRESERVE ROWS
go
COMMENT ON TABLE "pears"."WPKMultiSelection" IS
'Temp Table - used to list records selected on a Woodpecker grid.'
go