BackOfficeSystems
Primary Key
| Primary Key | Field Type |
|---|---|
| ID | int |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| Name | nvarchar(50) | |||
| Guid | uniqueidentifier | Default = (newid()) | ||
| SysOptions | ntext | yes | ||
| DisplayControl | nvarchar(256) | yes | ||
| UserPropertiesControl | nvarchar(256) | yes | ||
| Available | bit | Default = 1 | ||
| CallbackTypeAssemblyName | nvarchar(256) | yes | ||
| CallbackTypeName | nvarchar(256) | yes | ||
| RoleRefresherAssemblyName | nvarchar(256) | yes | ||
| RoleRefresherTypeName | nvarchar(256) | yes |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| IX_BackOfficeSystems_ID_GUID_Name | ID, Guid, Name | |||
| PK_BackOfficeSystems1 | ID | yes | yes |
Referenced by
| Referenced by | Field |
|---|---|
| BackOfficeSystemPeople | BackOfficeSystemID |
| BackOfficeUserImportErrRecords | BackOfficeSystemsId |
| NotificationSubscription | BackOfficeSystemsID |