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
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
AND SkillRelationType.skillRelationTypeId = RelatedSkills.relationId
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.