ClientUserFieldPrivacy
Primary Key
| Primary Key | Field Type |
|---|---|
| ID | int |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| FieldID | int | |||
| FieldAttribID | int | Default = 0 | ||
| Private | bit | yes | Default = 1 |
Foreign Keys
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| BackOfficeSystemPeopleID | int | yes | BackOfficeSystemPeople.ID |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| IX_ClientUserFieldPrivacy_BackOfficeSystemPeopleID | BackOfficeSystemPeopleID | |||
| PK_ClientUserFieldPrivacy | ID | yes | yes | yes |
| UK_ClientUserFieldPrivacy_FieldID_FieldAttribID_BackOfficeSystemPeopleID | FieldID, FieldAttribID, BackOfficeSystemPeopleID | yes |