Table of Contents



pears.IQXNetLanguageOverride

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

Description

Allows agencies to override the default terminology defined in “IQXNetLanguage” on a per-division and/or per-user-class basis. When the system resolves a label it checks this table first, using the most specific match available, before falling back to the “IQXNetLanguage.DefaultValue”. Omitting “DivisionID” or “IQXNetUserClassID” makes the override apply more broadly.

Columns

Column Type Null Default Comment
ID integer NOT NULL autoincrement
IQXNetLanguageID char(50) NOT NULL FK → IQXNetLanguage — the label being overridden
OverrideValue char(100) NOT NULL The replacement text
IQXNetUserClassID char(20) NULL Optional — restrict override to a user class
DivisionID char(20) NULL Optional — restrict override to a division
IQXNetLanguageOverrideID char(20) NULL PK

Primary Key

Foreign Keys

Constraint Columns References Delete/update action
IQXNetLanguage IQXNetLanguageID pears.IQXNetLanguage (IQXNetLanguageID) NOT NULL; ON DELETE CASCADE
IQXNetUserClass IQXNetUserClassID pears.IQXNetUserClass (IQXNetUserClassID) ON DELETE SET NULL
division DivisionID pears.Division (divisionid) ON DELETE SET NULL

Referenced By

Indexes

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."IQXNetLanguageOverride"
-- Table comment: Allows agencies to override the default terminology defined in "IQXNetLanguage" on a per-division and/or per-user-class basis. When the system resolves a label it checks this table first, using the most specific match available, before falling back to the "IQXNetLanguage.DefaultValue". Omitting "DivisionID" or "IQXNetUserClassID" makes the override apply more broadly.
-- Statement count: 10
 
CREATE TABLE "pears"."IQXNetLanguageOverride" (
    "ID"                             INTEGER NOT NULL DEFAULT autoincrement
   ,"IQXNetLanguageID"               CHAR(50) NOT NULL
   ,"OverrideValue"                  CHAR(100) NOT NULL
   ,"IQXNetUserClassID"              CHAR(20) NULL
   ,"DivisionID"                     CHAR(20) NULL
   ,"IQXNetLanguageOverrideID"       CHAR(20) NULL
   ,PRIMARY KEY ("ID" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."IQXNetLanguageOverride"."IQXNetLanguageID" IS 
	'FK → IQXNetLanguage — the label being overridden'
GO
 
 
COMMENT ON COLUMN "pears"."IQXNetLanguageOverride"."OverrideValue" IS 
	'The replacement text'
GO
 
 
COMMENT ON COLUMN "pears"."IQXNetLanguageOverride"."IQXNetUserClassID" IS 
	'Optional — restrict override to a user class'
GO
 
 
COMMENT ON COLUMN "pears"."IQXNetLanguageOverride"."DivisionID" IS 
	'Optional — restrict override to a division'
GO
 
 
COMMENT ON COLUMN "pears"."IQXNetLanguageOverride"."IQXNetLanguageOverrideID" IS 
	'PK'
GO
 
 
COMMENT ON TABLE "pears"."IQXNetLanguageOverride" IS 
	'Allows agencies to override the default terminology defined in "IQXNetLanguage" on a per-division and/or per-user-class basis. When the system resolves a label it checks this table first, using the most specific match available, before falling back to the "IQXNetLanguage.DefaultValue". Omitting "DivisionID" or "IQXNetUserClassID" makes the override apply more broadly.'
GO
 
 
ALTER TABLE "pears"."IQXNetLanguageOverride"
    ADD NOT NULL FOREIGN KEY "IQXNetLanguage" ("IQXNetLanguageID" ASC)
    REFERENCES "pears"."IQXNetLanguage" ("IQXNetLanguageID")
    ON DELETE CASCADE
GO
 
 
ALTER TABLE "pears"."IQXNetLanguageOverride"
    ADD FOREIGN KEY "IQXNetUserClass" ("IQXNetUserClassID" ASC)
    REFERENCES "pears"."IQXNetUserClass" ("IQXNetUserClassID")
    ON DELETE SET NULL
GO
 
 
ALTER TABLE "pears"."IQXNetLanguageOverride"
    ADD FOREIGN KEY "division" ("DivisionID" ASC)
    REFERENCES "pears"."Division" ("divisionid")
    ON DELETE SET NULL
GO