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