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 |