database:tables:pears_reporttype



pears.ReportType

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

Columns

Column Type Null Default Comment
ReportTypeID char(50) NOT NULL
Notes char(100) NULL
sortorder smallint NULL

Primary Key

  • ReportTypeID

Foreign Keys

  • No outgoing foreign keys found.

Referenced By

Table Constraint Columns Referenced columns
pears.report reporttype reporttypeid ReportTypeID

Indexes

  • No indexes found.

Triggers

  • No triggers found.

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."ReportType"
-- Table comment: 
-- Statement count: 1
 
CREATE TABLE "pears"."ReportType" (
    "ReportTypeID"                   CHAR(50) NOT NULL
   ,"Notes"                          CHAR(100) NULL
   ,"sortorder"                      SMALLINT NULL
   ,PRIMARY KEY ("ReportTypeID" ASC) 
)
GO
  • database/tables/pears_reporttype.txt
  • Last modified: 2026/08/07 19:24
  • by 127.0.0.1