Table of Contents



pears.IQXNetLanguage

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

Description

Stores the default terminology and label definitions used throughout iqxWEB. Each entry represents a single UI string identified by a structured key in the pattern “v2-{userclass}-{component}-{key}” (e.g. “v2-cand-registration-firstname”). These defaults can be selectively overridden per division or user class via “IQXNetLanguageOverride” without modifying the base record.

Columns

Column Type Null Default Comment
IQXNetLanguageID char(50) NOT NULL PK — structured key, e.g. v2-cand-registration-firstname
Description char(100) NOT NULL Human-readable description of what this label is for
DefaultValue char(100) NOT NULL The default text/label displayed in the UI

Primary Key

Foreign Keys

Referenced By

Table Constraint Columns Referenced columns
pears.IQXNetLanguageOverride IQXNetLanguage IQXNetLanguageID IQXNetLanguageID

Indexes

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."IQXNetLanguage"
-- Table comment: Stores the default terminology and label definitions used throughout iqxWEB. Each entry represents a single UI string identified by a structured key in the pattern "v2-{userclass}-{component}-{key}" (e.g. "v2-cand-registration-firstname"). These defaults can be selectively overridden per division or user class via "IQXNetLanguageOverride" without modifying the base record.
-- Statement count: 5
 
CREATE TABLE "pears"."IQXNetLanguage" (
    "IQXNetLanguageID"               CHAR(50) NOT NULL
   ,"Description"                    CHAR(100) NOT NULL
   ,"DefaultValue"                   CHAR(100) NOT NULL
   ,PRIMARY KEY ("IQXNetLanguageID" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."IQXNetLanguage"."IQXNetLanguageID" IS 
	'PK — structured key, e.g. v2-cand-registration-firstname'
GO
 
 
COMMENT ON COLUMN "pears"."IQXNetLanguage"."Description" IS 
	'Human-readable description of what this label is for'
GO
 
 
COMMENT ON COLUMN "pears"."IQXNetLanguage"."DefaultValue" IS 
	'The default text/label displayed in the UI'
GO
 
 
COMMENT ON TABLE "pears"."IQXNetLanguage" IS 
	'Stores the default terminology and label definitions used throughout iqxWEB. Each entry represents a single UI string identified by a structured key in the pattern "v2-{userclass}-{component}-{key}" (e.g. "v2-cand-registration-firstname"). These defaults can be selectively overridden per division or user class via "IQXNetLanguageOverride" without modifying the base record.'
GO