pears.BroadbeanCandidate

Broadbean Candidate

• BroadbeanCandidateid

• No incoming foreign keys found.

• No indexes found.

• No triggers found.

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