concept

CH table metadata: omie.offer_blocks

Complex day-ahead offer DETAIL (OMIE `det` — Mercado Diario → 4. Ofertas → "Detalle de las ofertas al mercado diario"). One row per tramo/block of a complex offer, linked to omie.offer_headers on (datetime, program, offer_code). Same reverse-engineering caveat as omie.offer_headers — see its table_comment. Verified against 258756 real rows on 2026-01-01, cross-checked to share the same offer_code population as omie.offer_headers for that day.

# `omie.offer_blocks` Complex day-ahead offer DETAIL (OMIE `det` — Mercado Diario → 4. Ofertas → "Detalle de las ofertas al mercado diario"). One row per tramo/block of a complex offer, linked to omie.offer_headers on (datetime, program, offer_code). Same reverse-engineering caveat as omie.offer_headers — see its table_comment. Verified against 258756 real rows on 2026-01-01, cross-checked to share the same offer_code population as omie.offer_headers for that day.