| Primary Key | Field Type |
|---|---|
 ID |
uniqueidentifier |
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 SYSTEMROLENAME |
nvarchar(255) | Default = '' | ||
| SITENAME |
nvarchar(1024) | Default = '' |
| 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 |
| Index Name | Field(s) | Unique | Primary | Clustered |
|---|---|---|---|---|
 IX_SITEPERMISSION_APPUSERID |
APPUSERID | |||
| IX_SITEPERMISSION_SITEID |
SITEID | |||
| IX_SITEPERMISSION_SYSTEMROLEAPPUSERID |
SYSTEMROLEAPPUSERID | |||
| IX_SITEPERMISSION_SYSTEMROLEID |
SYSTEMROLEID | |||
| PK_SITEPERMISSION |
ID |  |
|
|
| Trigger Name | Description |
|---|---|
 TR_SITEPERMISSION_AUDIT_ETLDELETEDID |