.

Generated using SQL Data Dictionary demo version.

Table dbo.Taxonomy_Terms (4 rows)

	Column	Data Type	Identity	Nullable	Default
PK	TermID	int	X
FK	VocabularyID	int
FK	ParentTermID	int		X
	Name	nvarchar(250)
	Description	nvarchar(2500)		X
	Weight	int			0
	TermLeft	int			0
	TermRight	int			0
	CreatedByUserID	int		X
	CreatedOnDate	datetime		X
	LastModifiedByUserID	int		X
	LastModifiedOnDate	datetime		X

Indexes:

PK_Taxonomy_Terms
- (Primary Key)
- (Clustered)
- TermID

References:

dbo.Taxonomy_Terms
- TermID (ParentTermID)
dbo.Taxonomy_Vocabularies
- VocabularyID

Referenced by:

dbo.ContentItems_Tags
- TermID
dbo.Taxonomy_Terms
- ParentTermID (TermID)

Used by:

Procedure
dbo.AddHeirarchicalTerm
Procedure
dbo.AddSimpleTerm
Procedure
dbo.DeleteHeirarchicalTerm
Procedure
dbo.DeleteSimpleTerm
Procedure
dbo.GetContentItemsByTerm
Procedure
dbo.GetContentItemsByVocabularyId
Procedure
dbo.GetTerm
Procedure
dbo.GetTermsByContent
Procedure
dbo.GetTermsByVocabulary
Procedure
dbo.GetTermUsage
Procedure
dbo.UpdateHeirarchicalTerm
Procedure
dbo.UpdateSimpleTerm