fct_helper_matching_preferences


Description

Matching Preferences allow Lookout to best match customers with helpers that have suitable skills and experience. When members create a new match request, they pick the preferences most important to them. The more specific their match request is, the better Lookout can surface ideal candidates from the Marketplace.

Matching Preferences are made up of a Matching Preferences category. Within that category, category preferences are then added in.

Columns

Column Type Children Parents Comments
helper_matching_preference_id text

The unique helper matching preference ID generated using the helper ID and matching preference ID.
helper_id int8

The helper ID associated with the matching preference. E.g. 482.
matching_preference varchar

The name of the matching preference. E.g. Japanese.
matching_preference_id int8

The ID of the matching preference. E.g. 1523.
matching_preference_category varchar

The name of the category that the matching preference belongs to. E.g. Language. Staffers create this category in the Lookout settings.
matching_preference_category_id int8

The ID of the helper matching preference category. E.g. 59.
category_public_to_members bool

Indicates whether the matching preference category is able to be selected as a preference by users in the app. One of True, False.
category_recommendable bool

Indicates whether the matching preference category is recommendable. One of True, False. This allows Staffers, Members and Authorised Representatives to recommend Helpers for preferences in this category.
category_icon_label varchar

The label of the icon associated with the matching preference category. E.g. arts_and_crafts.
category_created_at timestamp

The timestamp, in UTC, when the matching preference category was created. E.g. 2021-03-02 00:12:59.996101
category_updated_at timestamp

The timestamp, in UTC, when the matching preference category was last updated. E.g. 2021-03-02 00:12:59.996101
company_id int8
dim_companies.company_id Implied Constraint R

ID of the company. E.g.: 345.

Indexes

Constraint Name Type Sort Column(s)
fct_helper_matching_preferences_pkey Primary key Asc helper_matching_preference_id
fct_helper_matching_preferences_company_id_idx Performance Asc company_id
fct_helper_matching_preferences_helper_id_idx Performance Asc helper_id

Relationships

Close relationships within degrees of separation