Explain the relation between the RelatedSkills, SkillRelationType, Skill for Taxonomy?

Skill: In this table, we store skill, formatted Skill, description, SkillType(Skill Type is defined as
the type of the skill, for example, Knowledge, Tool, Technology, Soft, Behavioral, etc.)

Related Skills: In the Related Skills table we are storing relatedSkillId, parentSkillId, childSkillId,
relationId which are explained below.

1. relatedSkillId : This is the primary key of the table.
2. parentSkillId : This column contain skill Id (main /search skill id)
3. childSkillId : This is a related skill id from the skill table i.e. the skill related to the
main skill
4. relationId : This is relationId between main skill (search skill)l and child skill i.e.
Parent, tool, Feature and Similar.

Sample Query :

SELECT S1.skill AS 'MainSkill',S2.skill AS 'RelatedSkill', SkillRelationType.relation name AS 'Relation'
FROM Skill S1, Skill S2,RelatedSkills, SkillRelationType
WHERE S1.skillId=RelatedSkills.parentSkillId
AND S2.skillId=RelatedSkills.childSkillId
AND SkillRelationType.skillRelationTypeId = RelatedSkills.relationId
AND S1.skillId=33140

SkillRelationType:

 In this Table, we store skill relation type mean how one skill relates to other ex if one skill is parent to another skill then the relation type is parent same for Tool, Feature, and Similar type.

If you have any questions, you can always contact RChilli Support via creating a ticket at RChilli Helpdesk or simply by sending an email at support@rchilli.com.