Offer Model
The mrt_global__offer table is designed to store comprehensive information about offer nor product metadata.
Table description
| name | data_type | description |
|---|---|---|
| offer_id | STRING | Unique identifier for the offer. |
| offer_product_id | STRING | Identifier for the product associated with the offer. |
| offer_product_humanized_id | STRING | Human-readable identifier for the product associated with the offer. |
| offer_id_at_providers | STRING | Identifier for the offer at external providers. |
| is_synchronised | BOOLEAN | Indicates whether the offer is synchronized with API systems and has a product_id. |
| offer_name | STRING | Name of the offer as it appears in the application. |
| offer_description | STRING | Offer description (synopsis, further details on the show) as provided by thecultural partner and displayed in app. |
| offer_category_id | STRING | Identifier for the category of the offer. |
| last_stock_price | NUMERIC | The last recorded stock price for the offer. |
| offer_creation_date | DATE | Date when the offer was created. |
| offer_created_at | DATETIME | Timestamp when the offer was created. |
| offer_updated_date | DATETIME | Timestamp when the offer was last updated. |
| offer_is_duo | BOOLEAN | Indicates if the offer can be booked as a duo. |
| item_id | STRING | Identifier for the item associated with the offer used internally by the data science team. |
| offer_is_underage_selectable | BOOLEAN | Indicates if the offer is selectable for underage users. |
| offer_type_domain | STRING | Deprecated: The offer's category type,as many metadata info are specific to certain |
| offer types. Can be either "BOOK", "MUSIC", "SHOW" or "MOVIE". | ||
| offer_is_bookable | BOOLEAN | Indicates if the offer is bookable. |
| venue_is_virtual | BOOLEAN | Indicates if the venue is virtual. Each offerer has a virtual venue, it is only used to publish digital offers. |
| digital_goods | BOOLEAN | Indicates if the offer includes digital goods. |
| physical_goods | BOOLEAN | Indicates if the offer includes physical goods. |
| event | BOOLEAN | Indicates if the offer is an event. |
| offer_humanized_id | STRING | Human-readable identifier for the offer used in various platforms. |
| passculture_pro_url | STRING | URL to the offer on PassCulture Pro. |
| webapp_url | STRING | URL to the offer on the web application. |
| offer_subcategory_id | STRING | Identifier for the subcategory of the offer. |
| offer_url | STRING | URL to the offer. |
| is_national | BOOLEAN | Indicates if the offer is available nationally. |
| is_active | BOOLEAN | Indicates if the offer is active. |
| offer_validation | STRING | Validation status of the offer. |
| author | STRING | The offer's author (a book's author, a music's singer, a movie's director). |
| performer | STRING | Performers involved in this offer. |
| stage_director | STRING | Stage director, if applicable. |
| theater_movie_id | STRING | Allociné identifier for the movie, if applicable. |
| theater_room_id | STRING | Allociné identifier for the theater room, if applicable. |
| speaker | STRING | Speaker or professor, if applicable. |
| movie_type | STRING | Type of movie, if applicable (e.g., feature film, short film). |
| visa | STRING | Film visa number, if applicable. |
| release_date | STRING | Release date, if applicable. |
| genres | STRING | Genres of the film, if applicable. |
| companies | STRING | Companies involved in the production or distribution of the film, if applicable. |
| countries | STRING | Countries where the film was produced, if applicable. |
| casting | STRING | Actors in the film, if applicable. |
| isbn | STRING | ISBN of the book, if applicable. |
| titelive_gtl_id | STRING | Unique identifier of the Genre Tite Live (GTL) associated to this offer. |
| rayon | STRING | Literary genre, if applicable. |
| book_editor | STRING | Editor of the book, if applicable. |
| type | STRING | Type of the offer. |
| sub_type | STRING | Sub-type of the offer. |
| mediation_humanized_id | STRING | Human-readable identifier for mediation. |
| total_individual_bookings | INT64 | Total number of individual bookings. |
| total_cancelled_individual_bookings | INT64 | Total number of cancelled individual bookings. |
| total_used_individual_bookings | INT64 | Total number of used individual bookings. |
| total_favorites | INT64 | Total number of times this offer was favorited. |
| total_stock_quantity | INT64 | Total remaining stock quantity. |
| total_first_bookings | INT64 | Total number of bookings that are first bookings. |
| venue_id | STRING | Unique identifier for the venue. |
| venue_name | STRING | Name of the venue. |
| venue_department_code | STRING | Department code of the venue. |
| venue_region_name | STRING | Region name where the venue is located. |
| venue_postal_code | STRING | Postal code of the venue. |
| venue_city | STRING | City where the venue is located. |
| venue_epci | STRING | EPCI code of the venue. |
| venue_academy_name | STRING | Academy of the venue. |
| venue_density_label | STRING | Detailed density label of the venue's location. |
| venue_macro_density_label | STRING | Macro density label of the venue's location (urbain, rural) |
| venue_label | STRING | Label of the venue. The label is appended by the Ministry as token of quality and standing in its category. |
| partner_id | STRING | Unique identifier of the partner. |
| offerer_id | STRING | Unique identifier of the offerer. |
| offerer_name | STRING | Name of the offerer. |
| venue_type_label | STRING | Type of the venue ('Musée', 'Cinéma','Librairie', etc). Selected by the partner in a drop-down list. |
| venue_iris_internal_id | STRING | Internal IRIS identifier for the venue. |
| offerer_address_id | STRING | The unique identifier for the mapping between an offerer and an address where he created offers. |
| offer_publication_date | DATETIME | Publication date of the offer. |
| is_future_scheduled | BOOLEAN | Indicates if the offer is scheduled for the future. |
| total_headlines | INT64 | Number of different times the offer was headlined on the app venue page. (an offer headline can be desactivated and reactivated) |
| is_headlined | BOOLEAN | Indicates if the offer is currently headlined on the app venue page. |
| first_headline_date | DATETIME | First date of headline on the app venue page. |
| last_headline_date | DATETIME | Last date of headline on the app venue page. |
| venue_density_level | STRING | ID of the density level of the venue (cf venue_density_label). |
| venue_department_name | STRING | Department name where of the venue. |
| venue_is_permanent | BOOLEAN | 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. |
| offer_last_provider_id | STRING | Id of the offer's last provider. |
| is_local_authority | BOOLEAN | Indicates if the offerer is a local authority or not. |