Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
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 | |
| Name | Type | Columns | Detail |
| reportfilename | Index | filename | |
-- 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
127.0.0.1