pears.TmpNewEmployment

• NewEmploymentid

• 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"."TmpNewEmployment"
-- Table comment: 
-- Statement count: 1
 
CREATE GLOBAL TEMPORARY TABLE "pears"."TmpNewEmployment" (
    "NewEmploymentid"                CHAR(20) NOT NULL
   ,"Personid"                       CHAR(20) NULL
   ,"etype"                          tinyint NULL DEFAULT 0
   ,"temp"                           tinyint NULL DEFAULT 0
   ,"companyname"                    CHAR(50) NULL
   ,"position"                       CHAR(40) NULL
   ,"companyid"                      CHAR(20) NULL
   ,"startdate"                      DATE NULL
   ,"leavedate"                      DATE NULL
   ,"extendednotes"                  long VARCHAR NULL
   ,PRIMARY KEY ("NewEmploymentid" ASC) 
) NOT TRANSACTIONAL
GO