Generated using SQL Data Dictionary demo version.
| |
Column |
Data Type |
Identity |
Nullable |
Default |
| PK |
ContentItemID |
int |
X |
|
|
|
Content |
nvarchar(max) |
|
X |
|
|
FK
|
ContentTypeID |
int |
|
|
|
|
TabID |
int |
|
|
|
|
ModuleID |
int |
|
|
|
|
ContentKey |
nvarchar(250) |
|
X |
|
|
Indexed |
bit |
|
|
0 |
|
CreatedByUserID |
int |
|
X |
|
|
CreatedOnDate |
datetime |
|
X |
|
|
LastModifiedByUserID |
int |
|
X |
|
|
LastModifiedOnDate |
datetime |
|
X |
|
|
FK
|
StateID |
int |
|
X |
|
Indexes:
-
PK_ContentItems
- (Primary Key)
- (Clustered)
-
IX_ContentItems_TabID
References:
Referenced by:
Used by:
- Procedure
dbo.AddContentItem
- Procedure
dbo.AddTabAfter
- Procedure
dbo.AddTabBefore
- Procedure
dbo.AddTabToEnd
- Procedure
dbo.DeleteContentItem
- Procedure
dbo.DeleteTab
- Procedure
dbo.DeleteTranslatedTabs
- Procedure
dbo.GetContentItem
- Procedure
dbo.GetContentItems
- Procedure
dbo.GetContentItemsByContentType
- Procedure
dbo.GetContentItemsByModuleId
- Procedure
dbo.GetContentItemsByTabId
- Procedure
dbo.GetContentItemsByTerm
- Procedure
dbo.GetContentItemsByVocabularyId
- Procedure
dbo.GetTerm
- Procedure
dbo.GetTermUsage
- Procedure
dbo.GetUnIndexedContentItems
- Procedure
dbo.Journal_GetSearchItems
- Procedure
dbo.UpdateContentItem
- View
- View
- View
- View