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. You can save multiple times a single offer as 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. Determined by the cultural partner via a list of pre-set options in a drop down menu.
offer_creation_date		Date when the offer was created.
offer_subcategory_id		Identifier for the subcategory of the offer. Determined by the cultural partner via a list of pre-set options.
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 during subscription. If you need to study bookings and offers per cultural sector, use the offer categories instead. "Autre" category contains many administrative venues of live performance actors and local authorities. NB : this venue_type_label segmentation is limited and currently being revised.
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). Information collected during registration.
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.