.

Generated using SQL Data Dictionary demo version.

Table dbo.HtmlText (3 rows)

	Column	Data Type	Identity	Nullable	Default
FK	ModuleID	int
PK	ItemID	int	X
	Content	ntext		X
	Version	int		X
FK	StateID	int		X
	IsPublished	bit		X
	CreatedByUserID	int		X
	CreatedOnDate	datetime		X
	LastModifiedByUserID	int		X
	LastModifiedOnDate	datetime		X
	Summary	ntext		X

Indexes:

PK_HtmlText
- (Primary Key)
- (Clustered)
- ItemID

IX_HtmlText_ModuleID_Version
- ModuleID
- Version

References:

dbo.Modules
- ModuleID
dbo.WorkflowStates
- StateID

Referenced by:

dbo.HtmlTextLog
- ItemID
dbo.HtmlTextUsers
- ItemID

Used by:

Procedure
dbo.AddHtmlText
Procedure
dbo.DeleteHtmlText
Procedure
dbo.DeleteHtmlTextUsers
Procedure
dbo.GetAllHtmlText
Procedure
dbo.GetHtmlText
Procedure
dbo.GetTopHtmlText
Procedure
dbo.UpdateHtmlText