Table of Contents



pears.BroadbeanChannels

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

Description

Broadbean Channels

Columns

Column Type Null Default Comment
BroadbeanChannelid char(20) NOT NULL
Broadbeanvacancyid char(20) NULL
vacancyid char(20) NULL
ChannelName char(100) NULL
channelid char(100) NULL
FreeToPost tinyint NULL
CostPerPost char(10) NULL
ChannelSummary char(100) NULL
QuotaInformation char(100) NULL
cost double NULL
currency char(10) NULL
postedtime timestamp NULL
removaltime timestamp NULL
adverturl char(200) NULL
slots char(20) NULL
responses integer NULL
views integer NULL
returncode integer NULL
returncodeclass char(100) NULL

Primary Key

Foreign Keys

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

Referenced By

Table Constraint Columns Referenced columns
pears.BroadbeanCandidate BroadbeanChannels BroadbeanChannelid BroadbeanChannelid

Indexes

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."BroadbeanChannels"
-- Table comment: Broadbean Channels
-- Statement count: 4
 
CREATE TABLE "pears"."BroadbeanChannels" (
    "BroadbeanChannelid"             CHAR(20) NOT NULL
   ,"Broadbeanvacancyid"             CHAR(20) NULL
   ,"vacancyid"                      CHAR(20) NULL
   ,"ChannelName"                    CHAR(100) NULL
   ,"channelid"                      CHAR(100) NULL
   ,"FreeToPost"                     tinyint NULL
   ,"CostPerPost"                    CHAR(10) NULL
   ,"ChannelSummary"                 CHAR(100) NULL
   ,"QuotaInformation"               CHAR(100) NULL
   ,"cost"                           DOUBLE NULL
   ,"currency"                       CHAR(10) NULL
   ,"postedtime"                     TIMESTAMP NULL
   ,"removaltime"                    TIMESTAMP NULL
   ,"adverturl"                      CHAR(200) NULL
   ,"slots"                          CHAR(20) NULL
   ,"responses"                      INTEGER NULL
   ,"views"                          INTEGER NULL
   ,"returncode"                     INTEGER NULL
   ,"returncodeclass"                CHAR(100) NULL
   ,PRIMARY KEY ("BroadbeanChannelid" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."BroadbeanChannels" IS 
	'Broadbean Channels'
GO
 
 
ALTER TABLE "pears"."BroadbeanChannels"
    ADD FOREIGN KEY "BroadbeanVacancy" ("Broadbeanvacancyid" ASC)
    REFERENCES "pears"."BroadbeanVacancy" ("Broadbeanvacancyid")
    ON DELETE CASCADE
GO
 
 
ALTER TABLE "pears"."BroadbeanChannels"
    ADD FOREIGN KEY "vacancy" ("vacancyid" ASC)
    REFERENCES "pears"."vacancy" ("vacancyid")
    ON DELETE CASCADE
GO