Table of Contents



pears.BroadbeanVacancy

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

Description

Links to vacancy - which vacancy posted to BB

Columns

Column Type Null Default Comment
Broadbeanvacancyid char(20) NOT NULL
vacancyid char(20) NULL
advertid char(100) NULL
createtime timestamp NULL
Locationid integer NULL
consultant char(50) NULL
office char(50) NULL
team char(50) NULL
username char(40) NULL
jobtitle char(65) NULL
jobref char(20) NULL
jobtype char(10) NULL
locationpath char(150) NULL
closetime timestamp NULL
continent integer NULL
country integer NULL
region integer NULL
place integer NULL
subplace integer NULL
subsubplace integer NULL
subsubsubplace integer NULL
Duration char(30) NULL
Salary_From double NULL
Salary_To double NULL
Salary_per char(5) NULL
Salary_Benefits char(50) NULL
Skills char(65) NULL
Description long varchar NULL
Summary long varchar NULL
clientdetails char(100) NULL
Profile char(100) NULL
JobOffer char(100) NULL
Salary_Currency char(10) NULL
Industry char(100) NULL
AdvertCheckDate timestamp NULL
StartDate timestamp NULL

Primary Key

Foreign Keys

Constraint Columns References Delete/update action
vacancy vacancyid pears.vacancy (vacancyid) ON DELETE CASCADE

Referenced By

Table Constraint Columns Referenced columns
pears.BroadbeanCandidate BroadbeanVacancy Broadbeanvacancyid Broadbeanvacancyid
pears.BroadbeanChannels BroadbeanVacancy Broadbeanvacancyid Broadbeanvacancyid

Indexes

Name Type Columns Detail
broadbeanadvertid Unique index advertid

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."BroadbeanVacancy"
-- Table comment: Links to vacancy - which vacancy posted to BB
-- Statement count: 4
 
CREATE TABLE "pears"."BroadbeanVacancy" (
    "Broadbeanvacancyid"             CHAR(20) NOT NULL
   ,"vacancyid"                      CHAR(20) NULL
   ,"advertid"                       CHAR(100) NULL
   ,"createtime"                     TIMESTAMP NULL
   ,"Locationid"                     INTEGER NULL
   ,"consultant"                     CHAR(50) NULL
   ,"office"                         CHAR(50) NULL
   ,"team"                           CHAR(50) NULL
   ,"username"                       CHAR(40) NULL
   ,"jobtitle"                       CHAR(65) NULL
   ,"jobref"                         CHAR(20) NULL
   ,"jobtype"                        CHAR(10) NULL
   ,"locationpath"                   CHAR(150) NULL
   ,"closetime"                      TIMESTAMP NULL
   ,"continent"                      INTEGER NULL
   ,"country"                        INTEGER NULL
   ,"region"                         INTEGER NULL
   ,"place"                          INTEGER NULL
   ,"subplace"                       INTEGER NULL
   ,"subsubplace"                    INTEGER NULL
   ,"subsubsubplace"                 INTEGER NULL
   ,"Duration"                       CHAR(30) NULL
   ,"Salary_From"                    DOUBLE NULL
   ,"Salary_To"                      DOUBLE NULL
   ,"Salary_per"                     CHAR(5) NULL
   ,"Salary_Benefits"                CHAR(50) NULL
   ,"Skills"                         CHAR(65) NULL
   ,"Description"                    long VARCHAR NULL
   ,"Summary"                        long VARCHAR NULL
   ,"clientdetails"                  CHAR(100) NULL
   ,"Profile"                        CHAR(100) NULL
   ,"JobOffer"                       CHAR(100) NULL
   ,"Salary_Currency"                CHAR(10) NULL
   ,"Industry"                       CHAR(100) NULL
   ,"AdvertCheckDate"                TIMESTAMP NULL
   ,"StartDate"                      TIMESTAMP NULL
   ,PRIMARY KEY ("Broadbeanvacancyid" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."BroadbeanVacancy" IS 
	'Links to vacancy - which vacancy posted to BB'
GO
 
 
ALTER TABLE "pears"."BroadbeanVacancy"
    ADD FOREIGN KEY "vacancy" ("vacancyid" ASC)
    REFERENCES "pears"."vacancy" ("vacancyid")
    ON DELETE CASCADE
GO
 
 
CREATE UNIQUE INDEX "broadbeanadvertid" ON "pears"."BroadbeanVacancy"
    ( "advertid" )
GO