====== 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