pears.OutlookEmail

• OutlookEmailID

• No outgoing foreign keys found.

• No incoming foreign keys found.

• No indexes found.

• No triggers found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."OutlookEmail"
-- Table comment: 
-- Statement count: 1
 
CREATE GLOBAL TEMPORARY TABLE "pears"."OutlookEmail" (
    "OutlookEmailEmailID"            CHAR(20) NOT NULL
   ,"FromAddress"                    CHAR(200) NULL
   ,"MessageID"                      CHAR(50) NULL
   ,"Body"                           long VARCHAR NULL
   ,"Processed"                      tinyint NULL
   ,"ReceivedDatetime"               TIMESTAMP NULL
   ,"Subject"                        CHAR(200) NULL
   ,"TempshiftplanID"                CHAR(20) NULL
   ,"Error"                          CHAR(200) NULL
   ,"OutlookEmailID"                 CHAR(20) NOT NULL
   ,PRIMARY KEY ("OutlookEmailID" ASC) 
) NOT TRANSACTIONAL
GO