Table of Contents



pears.report

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

Description

Report & job templates registered with the system.

Columns

Column Type Null Default Comment
reportid char(20) NOT NULL
name char(50) NULL
filename char(100) NULL
agencyid char(20) NULL
type char(3) NULL
accesslevel smallint NULL 0
drilldown smallint NULL 0
preservereportorder smallint NULL 0
special char(10) NULL
preservereportwhere smallint NULL 0
sortorder smallint NULL
usecount integer NULL
lastused timestamp NULL
lastusedby char(25) NULL
notes long varchar NULL
WebLocation char(100) NULL Used for custom iqxWeb images
SaveAsPDFtoDOCS tinyint NULL 0
ContainsFormFields tinyint NULL 0
reporttypeid char(50) NULL
ContainsLibraryFiles smallint NULL 0

Primary Key

Foreign Keys

Constraint Columns References Delete/update action
agencydetails agencyid pears.agencydetails (agencyid) ON DELETE SET NULL
reporttype reporttypeid pears.ReportType (ReportTypeID) ON DELETE SET NULL

Referenced By

Table Constraint Columns Referenced columns
pears.DocumentPack Report ReportID reportid
pears.DocumentPackReport Report ReportID reportid
pears.NotificationReports Report Reportid reportid
pears.ReportDepartment Report Reportid reportid
pears.ReportDivision Report Reportid reportid

Indexes

Name Type Columns Detail
reportfilename Index filename

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."report"
-- Table comment: Report & job templates registered with the system.
-- Statement count: 6
 
CREATE TABLE "pears"."report" (
    "reportid"                       CHAR(20) NOT NULL
   ,"name"                           CHAR(50) NULL
   ,"filename"                       CHAR(100) NULL
   ,"agencyid"                       CHAR(20) NULL
   ,"type"                           CHAR(3) NULL
   ,"accesslevel"                    SMALLINT NULL DEFAULT 0
   ,"drilldown"                      SMALLINT NULL DEFAULT 0
   ,"preservereportorder"            SMALLINT NULL DEFAULT 0
   ,"special"                        CHAR(10) NULL
   ,"preservereportwhere"            SMALLINT NULL DEFAULT 0
   ,"sortorder"                      SMALLINT NULL
   ,"usecount"                       INTEGER NULL
   ,"lastused"                       TIMESTAMP NULL
   ,"lastusedby"                     CHAR(25) NULL
   ,"notes"                          long VARCHAR NULL
   ,"WebLocation"                    CHAR(100) NULL
   ,"SaveAsPDFtoDOCS"                tinyint NULL DEFAULT 0
   ,"ContainsFormFields"             tinyint NULL DEFAULT 0
   ,"reporttypeid"                   CHAR(50) NULL
   ,"ContainsLibraryFiles"           SMALLINT NULL DEFAULT 0
   ,PRIMARY KEY ("reportid" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."report"."WebLocation" IS 
	'Used for custom iqxWeb images'
GO
 
 
COMMENT ON TABLE "pears"."report" IS 
	'Report & job templates registered with the system.'
GO
 
 
ALTER TABLE "pears"."report"
    ADD FOREIGN KEY "agencydetails" ("agencyid" ASC)
    REFERENCES "pears"."agencydetails" ("agencyid")
    ON DELETE SET NULL
GO
 
 
ALTER TABLE "pears"."report"
    ADD FOREIGN KEY "reporttype" ("reporttypeid" ASC)
    REFERENCES "pears"."ReportType" ("ReportTypeID")
    ON DELETE SET NULL
GO
 
 
CREATE INDEX "reportfilename" ON "pears"."report"
    ( "filename" )
GO