Table of Contents



pears.IQXHubMonitor

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

Description

details of hub activity version run time etc.

Columns

Column Type Null Default Comment
MachineName char(50) NOT NULL
Exe char(100) NOT NULL
Instance char(50) NOT NULL
MachineIP char(50) NULL
ExeVersion char(20) NULL
JobRunnerVersion char(20) NULL
WebServicesVersion char(20) NULL
Profile char(50) NULL
JobRunnerSchedule char(20) NULL
Started timestamp NULL
LastCheckin timestamp NULL
LastWebRequest timestamp NULL
BackupFolder char(100) NULL
StaticDataURL char(100) NULL
InfoComment char(100) NULL
Critical tinyint NULL 0

Primary Key

Foreign Keys

Referenced By

Indexes

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."IQXHubMonitor"
-- Table comment: details of hub activity version run time etc.
-- Statement count: 2
 
CREATE TABLE "pears"."IQXHubMonitor" (
    "MachineName"                    CHAR(50) NOT NULL
   ,"Exe"                            CHAR(100) NOT NULL
   ,"Instance"                       CHAR(50) NOT NULL
   ,"MachineIP"                      CHAR(50) NULL
   ,"ExeVersion"                     CHAR(20) NULL
   ,"JobRunnerVersion"               CHAR(20) NULL
   ,"WebServicesVersion"             CHAR(20) NULL
   ,"Profile"                        CHAR(50) NULL
   ,"JobRunnerSchedule"              CHAR(20) NULL
   ,"Started"                        TIMESTAMP NULL
   ,"LastCheckin"                    TIMESTAMP NULL
   ,"LastWebRequest"                 TIMESTAMP NULL
   ,"BackupFolder"                   CHAR(100) NULL
   ,"StaticDataURL"                  CHAR(100) NULL
   ,"InfoComment"                    CHAR(100) NULL
   ,"Critical"                       tinyint NULL DEFAULT 0
   ,PRIMARY KEY ("MachineName" ASC,"Exe" ASC,"Instance" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."IQXHubMonitor" IS 
	'details of hub activity version run time etc.'
GO