pears.IQXNetUserClass

Contains a list of the user classes for IQXWeb

• IQXNetUserClassID

• No indexes found.

• No triggers found.

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