pears.IQXNetBehaviourOverride

Stores per-division, per-user-class, or per-user overrides for “IQXNetBehaviour” defaults. When the system resolves a behaviour value it checks this table first, falling back to the base “IQXNetBehaviour.Value” if no matching override is found. Any combination of “DivisionID”, “IQXNetUserClassID”, and “IQXNetUserID” can be supplied; omitting a field means the override applies more broadly.

• IQXNetBehaviourOverrideID

• No incoming foreign keys found.

• No indexes found.

• No triggers found.

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."IQXNetBehaviourOverride"
-- Table comment: Stores per-division, per-user-class, or per-user overrides for "IQXNetBehaviour" defaults. When the system resolves a behaviour value it checks this table first, falling back to the base "IQXNetBehaviour.Value" if no matching override is found. Any combination of "DivisionID", "IQXNetUserClassID", and "IQXNetUserID" can be supplied; omitting a field means the override applies more broadly.
-- Statement count: 12
 
CREATE TABLE "pears"."IQXNetBehaviourOverride" (
    "IQXNetBehaviourOverrideID"      CHAR(20) NOT NULL
   ,"IQXNetBehaviourID"              CHAR(30) NOT NULL
   ,"OverrideValue"                  long VARCHAR NULL
   ,"IQXNetUserClassID"              CHAR(20) NULL
   ,"IQXNetUserID"                   CHAR(20) NULL
   ,"DivisionID"                     CHAR(20) NULL
   ,PRIMARY KEY ("IQXNetBehaviourOverrideID" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."IQXNetBehaviourOverride"."IQXNetBehaviourOverrideID" IS 
	'PK'
GO
 
 
COMMENT ON COLUMN "pears"."IQXNetBehaviourOverride"."IQXNetBehaviourID" IS 
	'FK → IQXNetBehaviour — the behaviour being overridden'
GO
 
 
COMMENT ON COLUMN "pears"."IQXNetBehaviourOverride"."OverrideValue" IS 
	'The replacement value that takes precedence over the default'
GO
 
 
COMMENT ON COLUMN "pears"."IQXNetBehaviourOverride"."IQXNetUserClassID" IS 
	'Optional — restrict to a user class (e.g. CANDIDATE)'
GO
 
 
COMMENT ON COLUMN "pears"."IQXNetBehaviourOverride"."IQXNetUserID" IS 
	'Optional — restrict to a specific user'
GO
 
 
COMMENT ON COLUMN "pears"."IQXNetBehaviourOverride"."DivisionID" IS 
	'Optional — restrict to a specific division'
GO
 
 
COMMENT ON TABLE "pears"."IQXNetBehaviourOverride" IS 
	'Stores per-division, per-user-class, or per-user overrides for "IQXNetBehaviour" defaults. When the system resolves a behaviour value it checks this table first, falling back to the base "IQXNetBehaviour.Value" if no matching override is found. Any combination of "DivisionID", "IQXNetUserClassID", and "IQXNetUserID" can be supplied; omitting a field means the override applies more broadly.'
GO
 
 
ALTER TABLE "pears"."IQXNetBehaviourOverride"
    ADD NOT NULL FOREIGN KEY "IQXNetBehaviour" ("IQXNetBehaviourID" ASC)
    REFERENCES "pears"."IQXNetBehaviour" ("IQXNetBehaviourID")
    ON DELETE CASCADE
GO
 
 
ALTER TABLE "pears"."IQXNetBehaviourOverride"
    ADD FOREIGN KEY "IQXNetUserClass" ("IQXNetUserClassID" ASC)
    REFERENCES "pears"."IQXNetUserClass" ("IQXNetUserClassID")
    ON DELETE CASCADE
GO
 
 
ALTER TABLE "pears"."IQXNetBehaviourOverride"
    ADD FOREIGN KEY "IQXNetUser" ("IQXNetUserID" ASC)
    REFERENCES "pears"."IQXNetUser" ("IQXNetUserID")
    ON DELETE CASCADE
GO
 
 
ALTER TABLE "pears"."IQXNetBehaviourOverride"
    ADD FOREIGN KEY "Division" ("DivisionID" ASC)
    REFERENCES "pears"."Division" ("divisionid")
    ON DELETE CASCADE
GO