Table of Contents



pears.TTBroadbeanBoardsToPostTo

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

Description

Temporary table. Used to assemble Job Board list during posting of Vacancies to Broadbean

Columns

Column Type Null Default Comment
ID integer NOT NULL autoincrement
Instance char(20) NULL
Code char(100) NULL
Selected smallint NULL
ChannelName char(100) NULL
channelid char(100) NULL
FreeToPost smallint NULL
CostPerPost char(100) NULL
ChannelSummary char(100) NULL
QuotaInformation char(100) NULL
cost double NULL
currency char(10) NULL
postedtime timestamp NULL
removaltime timestamp NULL
adverturl char(100) NULL
slots char(20) NULL
responses integer NULL
views integer NULL
returncode integer NULL
returncodeclass char(100) NULL
boardactive tinyint NULL

Primary Key

Foreign Keys

Referenced By

Indexes

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."TTBroadbeanBoardsToPostTo"
-- Table comment: Temporary table. Used to assemble Job Board list during posting of Vacancies to Broadbean
-- Statement count: 2
 
CREATE GLOBAL TEMPORARY TABLE "pears"."TTBroadbeanBoardsToPostTo" (
    "ID"                             INTEGER NOT NULL DEFAULT autoincrement
   ,"Instance"                       CHAR(20) NULL
   ,"Code"                           CHAR(100) NULL
   ,"Selected"                       SMALLINT NULL
   ,"ChannelName"                    CHAR(100) NULL
   ,"channelid"                      CHAR(100) NULL
   ,"FreeToPost"                     SMALLINT NULL
   ,"CostPerPost"                    CHAR(100) NULL
   ,"ChannelSummary"                 CHAR(100) NULL
   ,"QuotaInformation"               CHAR(100) NULL
   ,"cost"                           DOUBLE NULL
   ,"currency"                       CHAR(10) NULL
   ,"postedtime"                     TIMESTAMP NULL
   ,"removaltime"                    TIMESTAMP NULL
   ,"adverturl"                      CHAR(100) NULL
   ,"slots"                          CHAR(20) NULL
   ,"responses"                      INTEGER NULL
   ,"views"                          INTEGER NULL
   ,"returncode"                     INTEGER NULL
   ,"returncodeclass"                CHAR(100) NULL
   ,"boardactive"                    tinyint NULL
   ,PRIMARY KEY ("ID" ASC) 
) ON COMMIT PRESERVE ROWS
GO
 
 
COMMENT ON TABLE "pears"."TTBroadbeanBoardsToPostTo" IS 
	'Temporary table. Used to assemble Job Board list during posting of Vacancies to Broadbean'
GO