pears.IQXNetLanguageOverride

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.

• ID

• No incoming foreign keys found.

• No indexes found.

• No triggers found.

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