Documentation

{{docApp.title}}

{{docApp.description}}

How can we help?

{{docApp.searchError}}
{{product.name}}

Searching in {{docApp.searchFilterBySpecificBookTitle}}

{{docApp.searchResultFilteredItems.length}} results for: {{docApp.currentResultsSearchText}} in {{docApp.searchFilterBySpecificBookTitle}}
Search results have been limited. There are a total of {{docApp.searchResponse.totalResultsAvailable}} matches.

You have an odd number of " characters in your search terms - each one needs closing with a matching " character!

{{docApp.libraryHomeViewProduct.title || docApp.libraryHomeViewProduct.id}}

{{docApp.libraryHomeViewProduct.description}}

  1. {{book.title}}

{{group.title || group.id}}

{{group.description}}

  1. {{book.title}}

{{group.title}}

Relationship Entities

Details

Table ID: h_sm_relationship_entities

Details of the relationship between a Request and another entity and if they've been accepted as a solution

Table Attributes

Name Value
Primary Key h_id

Columns

Name & ID Description Column Attributes Relationships
Id
h_id
Entity ID
Type INTEGER
Nullable false
Primary Key true
Auto Increment true
Is an Accepted Solution
h_flg_acceptedsolution
Flag showing if the linked request provides an accepted solution
Type INTEGER
Nullable true
The entity ID
h_entity_id
ID of the entity
Type VARCHAR
Size 100
Nullable false
Indexed true
The entity name
h_entity_name
Name of the entity
Type VARCHAR
Size 100
Nullable false
Indexed true
The linked entity id
h_linked_entity_id
The id of the linked entity
Type VARCHAR
Size 100
Nullable false
Indexed true
The linked entity name
h_linked_entity_name
The name of the linked entity
Type VARCHAR
Size 100
Nullable false
Indexed true
The relationship link ID
h_fk_rel_link_id
>The ID of the RelationshipLink entity which define the type of link between the 2 entities
Type VARCHAR
Size 32
Nullable true
Indexed true
The user type
h_fk_rel_type_id
>The id of the RelationshipType which define the type of relationship between the entity and the linked entity
Type VARCHAR
Size 32
Nullable true
Indexed true
In This Document