pears.IQXNetRight
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
Description
Contains all the IQXWeb rights for all user classes
Columns
| Column | Type | Null | Default | Comment |
|---|---|---|---|---|
| IQXNetRightID | char(20) | NOT NULL | ||
| Description | char(100) | NOT NULL | ||
| SortOrder | smallint | NULL |
Primary Key
- IQXNetRightID
Foreign Keys
- No outgoing foreign keys found.
Referenced By
| Table | Constraint | Columns | Referenced columns |
|---|---|---|---|
| pears.IQXNetReport | IQXNetRight | IQXNetRightID | IQXNetRightID |
| pears.IQXNetRightAllowed | IQXNetRight | IQXNetRightID | IQXNetRightID |
| pears.IQXNetRightAssigned | IQXNetRight | IQXNetRightID | IQXNetRightID |
| pears.IQXNetRightDefault | IQXNetRight | IQXNetRightID | IQXNetRightID |
Indexes
- No indexes found.
Triggers
- No triggers found.
Original SQL
-- IQX database structure split by table -- Source: IQXDatabaseStructure - with comments.sql -- Table: "pears"."IQXNetRight" -- Table comment: Contains all the IQXWeb rights for all user classes -- Statement count: 2 CREATE TABLE "pears"."IQXNetRight" ( "IQXNetRightID" CHAR(20) NOT NULL ,"Description" CHAR(100) NOT NULL ,"SortOrder" SMALLINT NULL ,PRIMARY KEY ("IQXNetRightID" ASC) ) GO COMMENT ON TABLE "pears"."IQXNetRight" IS 'Contains all the IQXWeb rights for all user classes' GO