RoleObjectPrivs

Primary Key

Primary Key	Field Type
ID	int

Fields

Field	Field Type	Null	Notes	Description
CanEdit	bit	yes
CanAdd	bit	yes
CanView	bit	yes
CanDelete	bit	yes
CanSecure	bit	yes
ObjectGuid	uniqueidentifier		Default = (newid())

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
ObjectTypesID	int		ObjectTypes.ID
ClientRolesID	int		ClientRoles.ID

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_RoleObjectPrivs_ClientRolesID	ClientRolesID
IX_RoleObjectPrivs_ClientRolesID_ObjectTypesID_ObjectGuid	ClientRolesID, ID, ObjectTypesID, ObjectGuid
IX_RoleObjectPrivs_ObjectTypesID	ObjectTypesID
PK_ObjectPrivs	ID	yes	yes	yes