pears.IQXNetLanguage

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.

• IQXNetLanguageID

• No outgoing foreign keys found.

• No indexes found.

• No triggers found.

-- 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