.

Generated using SQL Data Dictionary demo version.

Table dbo.ContentWorkflowStatePermission (0 rows)

	Column	Data Type	Identity	Nullable	Default
PK	WorkflowStatePermissionID	int	X
UK , FK	StateID	int
UK , FK	PermissionID	int
	AllowAccess	bit
UK	RoleID	int		X
UK , FK	UserID	int		X
	CreatedByUserID	int		X
	CreatedOnDate	datetime		X
	LastModifiedByUserID	int		X
	LastModifiedOnDate	datetime		X

Indexes:

PK_ContentWorkflowStatePermission
- (Primary Key)
- (Clustered)
- WorkflowStatePermissionID

IX_ContentWorkflowStatePermission
- (Unique)
- StateID
- PermissionID
- RoleID
- UserID

References:

dbo.ContentWorkflowStates
- StateID
dbo.Permission
- PermissionID
dbo.Users
- UserID

Used by:

Procedure
dbo.AddContentWorkflowStatePermission
Procedure
dbo.DeleteContentWorkflowStatePermission
Procedure
dbo.UpdateContentWorkflowStatePermission
View
dbo.vw_ContentWorkflowStatePermissions