Table: Stock
The mrt_global__stock table provides a detailed view of stock-related data, capturing essential information about stock availability, pricing,
and associated offers. A stock has one quantity : available quantity of goods or tickets (can be null if the quantity is unlimited - ex : digital goods),
a price, and (only for events) a date.
One stock is linked to one offer, but one offer can be linked to several stocks, because an offer can have
several prices (ex : some theaters has different prices for a single show), several dates (ex : a cinema has different screenings for one movie).
Table description
| name | data_type | description |
|---|---|---|
| stock_id | Unique identifier for the stock. | |
| stock_beginning_date | Timestamp of the beginning of the event. Only for event offers. | |
| stock_last_provider_id | Identifier of the provider that synchronised this stock. Only for the synchronised offers. | |
| stock_booking_limit_date | Timestamp that specifies when it is no longer possible to book the offer linked to this stock. | |
| stock_creation_date | Creation date of the stock. | |
| stock_features | Movie features only for synchronised cinema screening offers (ex : VO, VF, 3D). Can be a list if several features applies to the stock. | |
| stock_price | Price of the stock. O if free. | |
| stock_quantity | Total quantity that had been available when the stock is created. Constant. If null, the quantity is unlimited (ex : digital offers). | |
| total_available_stock | Quantity of remaining stock. (stock_quantity - non cancelled bookings) | |
| total_cancelled_bookings | Total number of cancelled bookings. | |
| total_non_cancelled_bookings | Total number of bookings that were not cancelled, both individual and collective. | |
| total_paid_bookings | Total number of paid bookings. | |
| total_bookings | Total number of bookings, both individual and collective. | |
| offer_id | Unique identifier for the offer. | |
| offer_name | Name of the offer as it appears in the application. | |
| offer_subcategory_id | Identifier for the subcategory of the offer. Determined by the cultural partner via a list of pre-set options. | |
| offerer_id | Unique identifier of the offerer. | |
| partner_id | Unique identifier of the partner. | |
| price_category_id | Identifier for the price category. | |
| price_category_label | Label of the price category. Description written by the cultural partner of the price category of this stock (ex : "Pass 2 jours", "Prix +18 ans"). Null if there is no specific price category for the offer. | |
| price_category_label_id | Identifier for the price category label. | |
| venue_department_code | Department code of the venue. | |
| offerer_is_epn | BOOLEAN | Boolean true when the offerer is flagged as a national public structure. |