====== pears.DocPackPerson ======
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
===== Description =====
Temp Table - used in asembling document packs. Linking a person to a pack.
===== Columns =====
^ Column ^ Type ^ Null ^ Default ^ Comment ^
| InstanceID | char(20) | NULL | | |
| PersonID | char(20) | NULL | | |
===== Primary Key =====
* No primary key found in generated SQL.
===== Foreign Keys =====
* No outgoing foreign keys found.
===== Referenced By =====
* No incoming foreign keys found.
===== Indexes =====
^ Name ^ Type ^ Columns ^ Detail ^
| byInstanceID | Index | InstanceID | |
===== Triggers =====
* No triggers found.
===== Original SQL =====
-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."DocPackPerson"
-- Table comment: Temp Table - used in asembling document packs. Linking a person to a pack.
-- Statement count: 3
CREATE GLOBAL TEMPORARY TABLE "pears"."DocPackPerson" (
"InstanceID" char(20) NULL
,"PersonID" char(20) NULL
) NOT TRANSACTIONAL
go
COMMENT ON TABLE "pears"."DocPackPerson" IS
'Temp Table - used in asembling document packs. Linking a person to a pack.'
go
CREATE INDEX "byInstanceID" ON "pears"."DocPackPerson"
( "InstanceID" )
go