pears.externalemployment

Employment for temps when the company doesn't exist in IQX.

• extemploymentid

• No incoming foreign keys found.

• No indexes found.

• No triggers found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."externalemployment"
-- Table comment: Employment for temps when the company doesn't exist in IQX.
-- Statement count: 3
 
CREATE TABLE "pears"."externalemployment" (
    "extemploymentid"                CHAR(20) NOT NULL
   ,"personid"                       CHAR(20) NOT NULL
   ,"companyname"                    CHAR(50) NULL
   ,"startdate"                      DATE NULL
   ,"leavedate"                      DATE NULL
   ,"temp"                           SMALLINT NULL DEFAULT 0
   ,"note"                           CHAR(100) NULL
   ,"salary"                         NUMERIC(12,2) NULL
   ,"position"                       CHAR(50) NULL
   ,"ExtendedNotes"                  long VARCHAR NULL
   ,"noreemploy"                     SMALLINT NULL DEFAULT 0
   ,"Concurrent"                     SMALLINT NULL DEFAULT 0
   ,PRIMARY KEY ("extemploymentid" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."externalemployment" IS 
	'Employment for temps when the company doesn''t exist in IQX.'
GO
 
 
ALTER TABLE "pears"."externalemployment"
    ADD NOT NULL FOREIGN KEY "person" ("personid" ASC)
    REFERENCES "pears"."Person" ("personid")
GO