Table: Offer

This model exports validated offers data for ministry use. It contains information about cultural offers including: - Offer details (ID, name, description, category, subcategory) - Offer characteristics (duo, bookable, digital/physical goods, event) - Temporal information (creation, update, publication dates) - Status information (synchronization, national scope, active status) - Related entities (offerer, venue, product, item)

Table description

name	data_type	description
offer_id	STRING	Unique identifier for the offer.
offer_is_synchronised		Indicates whether the offer is synchronized with API systems and has a product_id.
offer_name		Name of the offer as it appears in the application.
offer_description		Offer description (synopsis, further details on the show) as provided by thecultural partner and displayed in app.
offer_subcategory		Identifier for the subcategory of the offer.
offer_category		Identifier for the category of the offer.
offer_created_at		Timestamp when the offer was created.
offer_updated_at		Timestamp when the offer was last updated.
offer_is_duo		Indicates if the offer can be booked as a duo.
offer_is_bookable		Indicates if the offer is bookable.
offer_is_digital_goods		Indicates if the offer includes digital goods.
offer_is_physical_goods		Indicates if the offer includes physical goods.
offer_is_event		Indicates if the offer is an event.
webapp_url		URL to the offer on the web application.
offer_url		URL to the offer.
offer_is_national		Indicates if the offer is available nationally.
offer_is_active		Indicates if the offer is active.
offerer_address_id		The unique identifier for the mapping between an offerer and an address where he created offers.
offer_publication_date		Publication date of the offer.
offer_product_id		Identifier for the product associated with the offer.
item_id		Identifier for the item associated with the offer used internally by the data science team.
venue_id		Unique identifier for the venue.
offerer_id		Unique identifier of the offerer.