🔍 Vérification de la table dm_entsoe_dayahead
=============================================

✅ La table dm_entsoe_dayahead existe

📋 Structure de la table:
-------------------------
id                        int(11)              NOT NULL   [PRI]
trading_date              date                 NOT NULL   [MUL]
delivery_date             date                 NOT NULL   [MUL]
delivery_hour             tinyint(4)           NOT NULL  
delivery_minute           tinyint(3) unsigned  NOT NULL  
position                  tinyint(3) unsigned  NULL      
delivery_start            datetime             NOT NULL  
delivery_end              datetime             NOT NULL  
bidding_zone              varchar(20)          NOT NULL   [MUL]
bidding_zone_name         varchar(50)          NOT NULL  
area_code                 varchar(5)           NOT NULL   [MUL]
price                     decimal(12,4)        NULL      
currency                  varchar(3)           NULL      
resolution                varchar(10)          NULL      
document_type             varchar(50)          NULL      
process_type              varchar(50)          NULL      
api_response_time         datetime             NULL      
created_at                timestamp            NOT NULL   [MUL]
updated_at                timestamp            NOT NULL  
source_url                text                 NULL      

📊 Index de la table:
--------------------
PRIMARY              PRIMARY KEY     id
uk_zone_delivery_time INDEX           bidding_zone, delivery_date, delivery_hour, delivery_minute, position
idx_delivery_date    INDEX           delivery_date
idx_trading_date     INDEX           trading_date
idx_area_code        INDEX           area_code
idx_zone_date        INDEX           bidding_zone, delivery_date
idx_created_at       INDEX           created_at

📈 Statistiques:
----------------
Records totaux: 780
Zones différentes: 9
Première date: 2025-11-28
Dernière date: 2025-11-28
Dernière MAJ: 2025-11-28 09:01:52

✅ Vérification terminée