Venue Provider

The mrt_global__venue_provider table lists all synchronizations established between cultural venues and synchronization instances (for ticketing, inventory management, etc.).

All synchronizations, whether currently active or not, are displayed. A cultural venue (identified by a venue_id) can be linked to multiple synchronization instances, and a single synchronization instance can be set up for multiple cultural partners.

This table contains information about the cultural venue, the provider, and the synchronization link (e.g., setup date, last synchronization date, etc.).

Table description

name	data_type	description
provider_id		The unique identifier for the synchronization provider.
provider_name		The name of the synchronization provider.
provider_is_active		Indicates whether the synchronization provider is currently active or not (has active synchronizations).
venue_provider_is_active		Indicates whether the synchronization between this specific venue and this specific provider is currently active or not.
venue_id		Unique identifier for the venue.
last_sync_date		The date of the last synchronization between the venue and the synchronization provider.
creation_date		The date when the synchronization between the venue and the synchronization provider was created.
venue_name		Name of the venue.
venue_department_code		Department code of the venue.
venue_department_name		Department name where of the venue.
venue_creation_date		Date when the venue was created on the application.
venue_is_permanent		Indicates if the venue is permanent. A permanent venue is a venue that can receive public permanently, that can propose offers, and that is managed by the partner. Permanent venues exemple : a library, a cinema. Non permanent venues example : a public garden that hosted a festival once, or a theater that hosted a concert once - it can be permanent for the partner who owns the theater, but not for the partner who is hosted once in this place.
venue_label		Label of the venue. The label is appended by the Ministry as token of quality and standing in its category.
booking_external_url		The provider's external url for booking management.
cancel_external_url		The provider's external url for handling booking cancellations.
notification_external_url		The provider's external url for notifications.
total_individual_offers		The total number of individual offers.
total_collective_offers		The total number of collective offers.
first_individual_offer_creation_date		Date of the first individual offer creation.
first_collective_offer_creation_date		Date of the first collective offer creation.