RecommendedSkills


Description

The view is used for recommending skills to users. The view excludes skills that a user already have. This view counts the number of time each skill is used by the jobs that each user prefers. A user prefers a job when there is a matching preference for the job category or JobJobTitles.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
SkillId uuid 2147483647 null

Foreign key, referencing public.Skills

UserId uuid 2147483647 null

Foreign key, referencing public.Users

countOfSkills int8 19 null

Count of the skill (with SkillId) appearing in jobs that user (with UserId) prefers.

Relationships

View Definition


Possibly Referenced Tables/Views