RecommendedSkills

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

Close relationships within degrees of separation

One

View Definition

SELECT "JobSkills"."SkillId",
    "UserJobRolePreferences"."UserId",
    count("JobSkills"."SkillId") AS "countOfSkills"
   FROM ((("JobSkills"
     JOIN "Jobs" ON (("JobSkills"."JobId" = "Jobs".id)))
     JOIN ( SELECT "Jobs_1".id AS "JobId",
            "JobRolePreferences"."UserId"
           FROM ("Jobs" "Jobs_1"
             JOIN "JobRolePreferences" ON (("Jobs_1"."JobCategoryId" = "JobRolePreferences"."JobCategoryId")))
        UNION
         SELECT "Jobs_1".id AS "JobId",
            "JobRolePreferences"."UserId"
           FROM (("Jobs" "Jobs_1"
             JOIN "JobJobTitles" ON (("Jobs_1".id = "JobJobTitles"."JobId")))
             JOIN "JobRolePreferences" ON (("JobJobTitles"."JobTitleId" = "JobRolePreferences"."JobTitleId")))) "UserJobRolePreferences" ON (("Jobs".id = "UserJobRolePreferences"."JobId")))
     LEFT JOIN "UserSkills" ON ((("JobSkills"."SkillId" = "UserSkills"."SkillId") AND ("UserJobRolePreferences"."UserId" = "UserSkills"."UserId"))))
  WHERE ("UserSkills".id IS NULL)
  GROUP BY "JobSkills"."SkillId", "UserJobRolePreferences"."UserId";

Description

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views