Favorite

The Global Favorite table lists all the offers placed in favourites on the platform.

All logged-in users, whether they have received a credit or not, can favorite an offer. As of now, only offers can be favorited. An offer can be favorited by multiple users, and a user can favorite multiple offers.

Table description

name	data_type	description
favorite_id		The unique identifier for the favorite.
favorite_creation_date		Date when the favorite was created.
favorite_created_at		Timestamp when the favorite was created.
user_id		Unique identifier for a user.
offer_id		Unique identifier for the offer.
offer_name		Name of the offer as it appears in the application.
offer_category_id		Identifier for the category of the offer.
offer_creation_date		Date when the offer was created.
offer_subcategory_id		Identifier for the subcategory of the offer.
venue_id		Unique identifier for the venue.
venue_name		Name of the venue.
venue_label		Label of the venue. The label is appended by the Ministry as token of quality and standing in its category.
partner_id		Unique identifier of the partner.
offerer_id		Unique identifier of the offerer.
offerer_name		Name of the offerer.
venue_type_label		Type of the venue ('Musée', 'Cinéma','Librairie', etc). Selected by the partner in a drop-down list.
venue_region_name		Region name where the venue is located.
venue_department_code		Department code of the venue.
venue_department_name		Department name where of the venue.
venue_postal_code		Postal code of the venue.
venue_city		City where the venue is located.
venue_academy_name		Academy of the venue.
venue_density_label		Detailed density label of the venue's location.
venue_macro_density_label		Macro density label of the venue's location (urbain, rural)
venue_density_level		ID of the density level of the venue (cf venue_density_label).
user_department_code		Department code associated with the user's registered address.
user_department_name		Department name associated with the user's registered address.
user_postal_code		Postal code of the user's registered address.
user_city		City associated with the user's registered address.
user_activity		User's registered activity (student, apprentice, unemployed etc). Registered at first grant deposit and updated when the user applies for its GRANT_18.
user_civility		Registered civility of the user (male, female).
user_age		Current age of the user.
user_is_priority_public		Boolean. Indicates if the user considered as a pass Culture priority public (users that are either residing in a rural area, in a QPV or are not in education).
user_is_unemployed		Boolean. Indicates if the user is unemployed as per its registered activity.
user_is_in_education		Boolean. Indicates if the user is in education, based on their registered activity. According to the INSEE, a user is considered to be in education if they fall under one of the following categories: Middle school student (Collégien), High school student (Lycéen), University student (Étudiant), Apprentice (Apprenti), Work-study student (Alternant).
user_is_in_qpv		Boolean. Indicates if the user's registered address is in a priority neighborhood (QPV).
current_deposit_type		Type of the user's current deposit.
user_current_deposit_reform_category		The current deposit reform category associated with the user.
user_epci		EPCI code associated with the user's registered address. An EPCI is a French public body enabling municipalities to collaborate on shared local services and development.
user_density_label		String column.Density label (urban, rural) of the user's registered address.
user_city_code		The INSEE code of the city associated with the user's registered address.
user_macro_density_label		Macro density label of the user's registered address.
user_region_name		Region name of the user's registered address.
user_academy_name		Academy name associated with the user's registered address.