Table of Contents



pears.BroadbeanCandidate

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

Description

Broadbean Candidate

Columns

Column Type Null Default Comment
BroadbeanCandidateid char(20) NOT NULL
BroadbeanChannelid char(20) NULL
Broadbeanvacancyid char(20) NULL
vacancyid char(20) NULL
personid char(20) NULL
ChannelName char(100) NULL
channelid char(100) NULL
applicationtime timestamp NULL
name char(100) NULL
forename char(60) NULL
salutation char(60) NULL
surname char(60) NULL
address char(100) NULL
street char(60) NULL
town char(60) NULL
postcode char(20) NULL
email char(100) NULL
phone char(30) NULL
body long varchar NULL
xmlformat long varchar NULL
broadbeandocumentid char(20) NULL
filename char(100) NULL
rank char(20) NULL
sourceid char(40) NULL
shortlisted tinyint NULL
BroadbeanRejectionReasonID char(20) NULL
BroadbeanRejectionReasonDate timestamp NULL
cvtext long varchar NULL

Primary Key

Foreign Keys

Constraint Columns References Delete/update action
BroadbeanChannels BroadbeanChannelid pears.BroadbeanChannels (BroadbeanChannelid) ON DELETE CASCADE
BroadbeanVacancy Broadbeanvacancyid pears.BroadbeanVacancy (Broadbeanvacancyid) ON DELETE CASCADE
vacancy vacancyid pears.vacancy (vacancyid) ON DELETE CASCADE
person personid pears.Person (personid) ON DELETE CASCADE

Referenced By

Indexes

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."BroadbeanCandidate"
-- Table comment: Broadbean Candidate
-- Statement count: 6
 
CREATE TABLE "pears"."BroadbeanCandidate" (
    "BroadbeanCandidateid"           CHAR(20) NOT NULL
   ,"BroadbeanChannelid"             CHAR(20) NULL
   ,"Broadbeanvacancyid"             CHAR(20) NULL
   ,"vacancyid"                      CHAR(20) NULL
   ,"personid"                       CHAR(20) NULL
   ,"ChannelName"                    CHAR(100) NULL
   ,"channelid"                      CHAR(100) NULL
   ,"applicationtime"                TIMESTAMP NULL
   ,"name"                           CHAR(100) NULL
   ,"forename"                       CHAR(60) NULL
   ,"salutation"                     CHAR(60) NULL
   ,"surname"                        CHAR(60) NULL
   ,"address"                        CHAR(100) NULL
   ,"street"                         CHAR(60) NULL
   ,"town"                           CHAR(60) NULL
   ,"postcode"                       CHAR(20) NULL
   ,"email"                          CHAR(100) NULL
   ,"phone"                          CHAR(30) NULL
   ,"body"                           long VARCHAR NULL
   ,"xmlformat"                      long VARCHAR NULL
   ,"broadbeandocumentid"            CHAR(20) NULL
   ,"filename"                       CHAR(100) NULL
   ,"rank"                           CHAR(20) NULL
   ,"sourceid"                       CHAR(40) NULL
   ,"shortlisted"                    tinyint NULL
   ,"BroadbeanRejectionReasonID"     CHAR(20) NULL
   ,"BroadbeanRejectionReasonDate"   TIMESTAMP NULL
   ,"cvtext"                         long VARCHAR NULL
   ,PRIMARY KEY ("BroadbeanCandidateid" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."BroadbeanCandidate" IS 
	'Broadbean Candidate'
GO
 
 
ALTER TABLE "pears"."BroadbeanCandidate"
    ADD FOREIGN KEY "BroadbeanChannels" ("BroadbeanChannelid" ASC)
    REFERENCES "pears"."BroadbeanChannels" ("BroadbeanChannelid")
    ON DELETE CASCADE
GO
 
 
ALTER TABLE "pears"."BroadbeanCandidate"
    ADD FOREIGN KEY "BroadbeanVacancy" ("Broadbeanvacancyid" ASC)
    REFERENCES "pears"."BroadbeanVacancy" ("Broadbeanvacancyid")
    ON DELETE CASCADE
GO
 
 
ALTER TABLE "pears"."BroadbeanCandidate"
    ADD FOREIGN KEY "vacancy" ("vacancyid" ASC)
    REFERENCES "pears"."vacancy" ("vacancyid")
    ON DELETE CASCADE
GO
 
 
ALTER TABLE "pears"."BroadbeanCandidate"
    ADD FOREIGN KEY "person" ("personid" ASC)
    REFERENCES "pears"."Person" ("personid")
    ON DELETE CASCADE
GO