Table of Contents



pears.IQXNetUserClass

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

Description

Contains a list of the user classes for IQXWeb

Columns

Column Type Null Default Comment
IQXNetUserClassID char(20) NOT NULL
Name char(50) NOT NULL
DefaultStaffID char(20) NULL
ReportsFolder char(250) NULL
DatabaseUser char(50) NULL Database actions will be performed with permissions of this user
SelfRegistrationAllowed tinyint NULL
Services long varchar NULL
Calls long varchar NULL
Jobs long varchar NULL
Selects tinyint NULL

Primary Key

Foreign Keys

Constraint Columns References Delete/update action
Staff DefaultStaffID pears.staff (staffid) ON DELETE SET NULL

Referenced By

Table Constraint Columns Referenced columns
pears.globaldocument IQXNetUserClass IQXNetUserClassID IQXNetUserClassID
pears.IQXNetBehaviourOverride IQXNetUserClass IQXNetUserClassID IQXNetUserClassID
pears.IQXNetLanguageOverride IQXNetUserClass IQXNetUserClassID IQXNetUserClassID
pears.IQXNetReport IQXNetUserClass IQXNetUserClassID IQXNetUserClassID
pears.IQXNetRightAllowed IQXNetUserClass IQXNetUserClassID IQXNetUserClassID
pears.IQXNetRightDefault IQXNetUserClass IQXNetUserClassID IQXNetUserClassID
pears.IQXNetUser IQXNetUserClass IQXNetUserClassID IQXNetUserClassID

Indexes

Triggers

Original SQL

-- IQX database structure split by table
-- Source: IQXDatabaseStructure - with comments.sql
-- Table: "pears"."IQXNetUserClass"
-- Table comment: Contains a list of the user classes for IQXWeb
-- Statement count: 4
 
CREATE TABLE "pears"."IQXNetUserClass" (
    "IQXNetUserClassID"              CHAR(20) NOT NULL
   ,"Name"                           CHAR(50) NOT NULL
   ,"DefaultStaffID"                 CHAR(20) NULL
   ,"ReportsFolder"                  CHAR(250) NULL
   ,"DatabaseUser"                   CHAR(50) NULL
   ,"SelfRegistrationAllowed"        tinyint NULL
   ,"Services"                       long VARCHAR NULL
   ,"Calls"                          long VARCHAR NULL
   ,"Jobs"                           long VARCHAR NULL
   ,"Selects"                        tinyint NULL
   ,PRIMARY KEY ("IQXNetUserClassID" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."IQXNetUserClass"."DatabaseUser" IS 
	'Database actions will be performed with permissions of this user'
GO
 
 
COMMENT ON TABLE "pears"."IQXNetUserClass" IS 
	'Contains a list of the user classes for IQXWeb'
GO
 
 
ALTER TABLE "pears"."IQXNetUserClass"
    ADD FOREIGN KEY "Staff" ("DefaultStaffID" ASC)
    REFERENCES "pears"."staff" ("staffid")
    ON DELETE SET NULL
GO