Skip to main content

Element Template Tables

The Element Template tables have an undetermined amount of columns. However, they all have the following columns in common:

SF_CasesResultsTemplate Table Columns

ColumnTypeComments
CaseID (PK, FK)Nvarchar(40), not nullID for a specific CASE. In SF_Case table it is named just ID.
ID (PK)Nvarchar(40), not nullSpecific ID for that Element within the Database.
NameNvarchar(128), nullName of the Element.
DescriptionNvarchar(128), nullDescription for the Element. It is optional and can be blank.
CategoriesNvarchar(128), nullElement Category in which the Template of the Element is related.