pears.IQXNetLanguageOverride [iqx]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== pears.IQXNetLanguageOverride ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

===== 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 =====
  * ID

===== Foreign Keys =====
^ Constraint ^ Columns ^ References ^ Delete/update action ^
| IQXNetLanguage | IQXNetLanguageID | [[database:tables:pears_iqxnetlanguage|pears.IQXNetLanguage (IQXNetLanguageID)]] | NOT NULL; ON DELETE CASCADE |
| IQXNetUserClass | IQXNetUserClassID | [[database:tables:pears_iqxnetuserclass|pears.IQXNetUserClass (IQXNetUserClassID)]] | ON DELETE SET NULL |
| division | DivisionID | [[database:tables:pears_division|pears.Division (divisionid)]] | ON DELETE SET NULL |

===== Referenced By =====
  * No incoming foreign keys found.

===== Indexes =====
  * No indexes found.

===== Triggers =====
  * No triggers found.

===== Original SQL =====
<code 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
</code>