3.1.1.1.20.1 Data Model
RecordId: primary key: A 64-bit unique signed integer that is unique for each entry in the table. The store assigns a unique value when a new row is inserted into the table. This forms the RecordId field of the ServerRole data structure.
ServerRecordID: foreign key (ADM_ServersTable, RecordId) on delete cascade: This specifies the record identifier of the row in the ADM_ServersTable that specifies the server on which the server role is present.
ServerRoleDetails: This specifies the properties pertaining to the specific server role instance. These details are modeled on the following properties of the ServerRole data structure.
AuditFileAccessStatus
EventViewerAccessStatus
LastRefreshTime
RpcAccessStatus
ServerRoleFlag
ServerRoleInclusionStatus
ServerStatus
ServiceStatusModifiedTime
The ServerRoleFlag has to be unique for any given ServerRecordID, which means that the given combination of Server Record Identifier and the ServerRoleFlag has to be unique in the table.