database:tables:pears_localwebpage



pears.LocalWebPage

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
ID char(20) NOT NULL
PageText long varchar NULL
WebLocation char(100) NULL Used for custom iqxWeb pages

Primary Key

  • ID

Foreign Keys

  • No outgoing foreign keys found.

Referenced By

Table Constraint Columns Referenced columns
pears.LocalWebPageDivision LocalWebPage id ID

Indexes

  • No indexes found.

Triggers

  • No triggers found.

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."LocalWebPage"
-- Table comment: 
-- Statement count: 2
 
CREATE TABLE "pears"."LocalWebPage" (
    "ID"                             CHAR(20) NOT NULL
   ,"PageText"                       long VARCHAR NULL
   ,"WebLocation"                    CHAR(100) NULL
   ,PRIMARY KEY ("ID" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."LocalWebPage"."WebLocation" IS 
	'Used for custom iqxWeb pages'
GO
  • database/tables/pears_localwebpage.txt
  • Last modified: 2026/08/07 19:24
  • by 127.0.0.1