SITEPERMISSION
Stores the flattened version of a system role application user's site permissions. This table was created so that the sql would not have to walk the site hierarchy when querying on site permissions.
Primary Key
| Primary Key |
Field Type |
| ID |
uniqueidentifier |
Fields
| Field |
Field Type |
Null |
Notes |
Description |
| SYSTEMROLENAME |
nvarchar(255) |
|
Default = '' |
|
| SITENAME |
nvarchar(1024) |
|
Default = '' |
|
Foreign Keys
| Foreign Key |
Field Type |
Null |
Notes |
Description |
| SYSTEMROLEID |
uniqueidentifier |
|
SYSTEMROLE.ID
|
FK to SYSTEMROLE |
| SITEID |
uniqueidentifier |
|
SITE.ID
|
FK to SITE |
| SYSTEMROLEAPPUSERID |
uniqueidentifier |
|
SYSTEMROLEAPPUSER.ID
|
FK to SYSTEMROLEAPPUSER |
| APPUSERID |
uniqueidentifier |
|
APPUSER.ID
|
FK to APPUSER |
Indexes
| Index Name |
Fields |
Unique |
Primary |
Clustered |
| IX_SITEPERMISSION_APPUSERID |
APPUSERID |
|
|
|
| IX_SITEPERMISSION_SITEID |
SITEID |
|
|
|
| IX_SITEPERMISSION_SYSTEMROLEAPPUSERID |
SYSTEMROLEAPPUSERID |
|
|
|
| IX_SITEPERMISSION_SYSTEMROLEID |
SYSTEMROLEID |
|
|
|
| IX_SITEPERMISSION_SYSTEMROLEID_APPUSERID |
SYSTEMROLEID, APPUSERID |
|
|
|
| PK_SITEPERMISSION |
ID |
yes |
yes |
yes |
Triggers