Table of Contents



pears.IQXHubBackup

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

Description

Results of IQXHub Backup events

Columns

Column Type Null Default Comment
IQXHubBackupID char(20) NOT NULL
WhenExecuted timestamp NULL current timestamp
Description char(50) NOT NULL
Failure tinyint NULL 0
Corruption tinyint NULL 0
NotifyFailure tinyint NULL 0
Details long varchar NULL

Primary Key

Foreign Keys

Referenced By

Indexes

Name Type Columns Detail
IQXHubBackupWhen Index WhenExecuted

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."IQXHubBackup"
-- Table comment: Results of IQXHub Backup events
-- Statement count: 3
 
CREATE TABLE "pears"."IQXHubBackup" (
    "IQXHubBackupID"                 CHAR(20) NOT NULL
   ,"WhenExecuted"                   TIMESTAMP NULL DEFAULT CURRENT TIMESTAMP
   ,"Description"                    CHAR(50) NOT NULL
   ,"Failure"                        tinyint NULL DEFAULT 0
   ,"Corruption"                     tinyint NULL DEFAULT 0
   ,"NotifyFailure"                  tinyint NULL DEFAULT 0
   ,"Details"                        long VARCHAR NULL
   ,PRIMARY KEY ("IQXHubBackupID" ASC) 
)
GO
 
 
COMMENT ON TABLE "pears"."IQXHubBackup" IS 
	'Results of IQXHub Backup events'
GO
 
 
CREATE INDEX "IQXHubBackupWhen" ON "pears"."IQXHubBackup"
    ( "WhenExecuted" )
GO