pears.BroadbeanChannels

Broadbean Channels

• BroadbeanChannelid

• No indexes found.

• No triggers found.

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