Table of Contents



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

Foreign Keys

Referenced By

Table Constraint Columns Referenced columns
pears.LocalWebPageDivision LocalWebPage id ID

Indexes

Triggers

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