pears.IQXNetRightAllowed

Contains the allowed rights for each user class

• IQXNetRightID, IQXNetUserClassID, 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"."IQXNetRightAllowed"
-- Table comment: Contains the allowed rights for each user class
-- Statement count: 5
 
CREATE TABLE "pears"."IQXNetRightAllowed" (
    "IQXNetRightID"                  CHAR(20) NOT NULL
   ,"IQXNetUserClassID"              CHAR(20) NOT NULL
   ,"ID"                             CHAR(20) NOT NULL
   ,"MaintainOnWeb"                  tinyint NULL
   ,PRIMARY KEY ("IQXNetRightID" ASC,"IQXNetUserClassID" ASC,"ID" ASC) 
)
GO
 
 
COMMENT ON COLUMN "pears"."IQXNetRightAllowed"."ID" IS 
	'* for class limit. ID for a more targeted limit e.g. client companyid'
GO
 
 
COMMENT ON TABLE "pears"."IQXNetRightAllowed" IS 
	'Contains the allowed rights for each user class'
GO
 
 
ALTER TABLE "pears"."IQXNetRightAllowed"
    ADD NOT NULL FOREIGN KEY "IQXNetRight" ("IQXNetRightID" ASC)
    REFERENCES "pears"."IQXNetRight" ("IQXNetRightID")
    ON DELETE CASCADE
GO
 
 
ALTER TABLE "pears"."IQXNetRightAllowed"
    ADD NOT NULL FOREIGN KEY "IQXNetUserClass" ("IQXNetUserClassID" ASC)
    REFERENCES "pears"."IQXNetUserClass" ("IQXNetUserClassID")
    ON DELETE CASCADE
GO