Table of Contents



pears.TTBroadbean

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

Description

Temporary table. Used to assemble Vacancy details when posting of Vacancies to Broadbean

Columns

Column Type Null Default Comment
Instance char(20) NOT NULL
JobTitle char(65) NULL
Industry char(100) NULL
JobType char(9) NULL
VacancyID char(20) NULL
BroadbeanLocationID integer NULL
JobRef char(20) NULL
Duration char(20) NULL
StartDate char(20) NULL
Salary_From integer NULL
Salary_To integer NULL
Salary_per char(5) NULL
Salary_Benefits char(50) NULL
Skills char(65) NULL
Description char(6000) NULL
Continent integer NULL
Region integer NULL
Country integer NULL
Place integer NULL
SubPlace integer NULL
SubSubPlace integer NULL
SubSubSubPlace integer NULL
Office char(50) NULL
consultant char(50) NULL
Team char(50) NULL
createtime timestamp NULL
summary char(600) NULL
clientdetails char(100) NULL
Profile char(100) NULL
closetime timestamp NULL
JobOffer char(100) NULL
id char(20) NULL
Salary_Currency char(20) NULL
RedirectOnCompletion char(200) NULL

Primary Key

Foreign Keys

Referenced By

Indexes

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."TTBroadbean"
-- Table comment: Temporary table. Used to assemble Vacancy details when posting of Vacancies to Broadbean
-- Statement count: 2
 
CREATE GLOBAL TEMPORARY TABLE "pears"."TTBroadbean" (
    "Instance"                       CHAR(20) NOT NULL
   ,"JobTitle"                       CHAR(65) NULL
   ,"Industry"                       CHAR(100) NULL
   ,"JobType"                        CHAR(9) NULL
   ,"VacancyID"                      CHAR(20) NULL
   ,"BroadbeanLocationID"            INTEGER NULL
   ,"JobRef"                         CHAR(20) NULL
   ,"Duration"                       CHAR(20) NULL
   ,"StartDate"                      CHAR(20) NULL
   ,"Salary_From"                    INTEGER NULL
   ,"Salary_To"                      INTEGER NULL
   ,"Salary_per"                     CHAR(5) NULL
   ,"Salary_Benefits"                CHAR(50) NULL
   ,"Skills"                         CHAR(65) NULL
   ,"Description"                    CHAR(6000) NULL
   ,"Continent"                      INTEGER NULL
   ,"Region"                         INTEGER NULL
   ,"Country"                        INTEGER NULL
   ,"Place"                          INTEGER NULL
   ,"SubPlace"                       INTEGER NULL
   ,"SubSubPlace"                    INTEGER NULL
   ,"SubSubSubPlace"                 INTEGER NULL
   ,"Office"                         CHAR(50) NULL
   ,"consultant"                     CHAR(50) NULL
   ,"Team"                           CHAR(50) NULL
   ,"createtime"                     TIMESTAMP NULL
   ,"summary"                        CHAR(600) NULL
   ,"clientdetails"                  CHAR(100) NULL
   ,"Profile"                        CHAR(100) NULL
   ,"closetime"                      TIMESTAMP NULL
   ,"JobOffer"                       CHAR(100) NULL
   ,"id"                             CHAR(20) NULL
   ,"Salary_Currency"                CHAR(20) NULL
   ,"RedirectOnCompletion"           CHAR(200) NULL
   ,PRIMARY KEY ("Instance" ASC) 
) ON COMMIT PRESERVE ROWS
GO
 
 
COMMENT ON TABLE "pears"."TTBroadbean" IS 
	'Temporary table. Used to assemble Vacancy details when posting of Vacancies to Broadbean'
GO