Table of Contents



pears.TmpNewEmployment

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
NewEmploymentid char(20) NOT NULL
Personid char(20) NULL
etype tinyint NULL 0
temp tinyint NULL 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

Foreign Keys

Referenced By

Indexes

Triggers

Original SQL

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