Table of Contents



pears.TempInbox

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

Columns

Column Type Null Default Comment
messageID char(200) NULL
FromName char(100) NULL
ContactName char(60) NULL
Subject char(100) NULL
Received timestamp NULL
AttachmentCount smallint NULL
ContactID char(21) NULL
Attachments long varchar NULL
FromAddress char(500) NULL
LookupCount smallint NULL
TempInboxID bigint NOT NULL autoincrement

Primary Key

Foreign Keys

Referenced By

Indexes

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."TempInbox"
-- Table comment: 
-- Statement count: 1
 
CREATE GLOBAL TEMPORARY TABLE "pears"."TempInbox" (
    "messageID"                      CHAR(200) NULL
   ,"FromName"                       CHAR(100) NULL
   ,"ContactName"                    CHAR(60) NULL
   ,"Subject"                        CHAR(100) NULL
   ,"Received"                       TIMESTAMP NULL
   ,"AttachmentCount"                SMALLINT NULL
   ,"ContactID"                      CHAR(21) NULL
   ,"Attachments"                    long VARCHAR NULL
   ,"FromAddress"                    CHAR(500) NULL
   ,"LookupCount"                    SMALLINT NULL
   ,"TempInboxID"                    BIGINT NOT NULL DEFAULT autoincrement
   ,PRIMARY KEY ("TempInboxID" ASC) 
) ON COMMIT PRESERVE ROWS
GO