✅ Connexion BDD réussie !

=== STRUCTURE DE LA TABLE eex_v2_mega_catalog ===

id                        | int(11)         | NOT NULL
provider                  | enum('EPEX','EEX','Nordpool') | NOT NULL
product_type              | enum('SPOT_POWER','POWER_FUTURE','GAS_FUTURE','GAS_SPOT','CO2_FUTURE','GO','AGRICULTURAL_FUTURE','FREIGHT_FUTURE','UNKNOWN_FUTURE') | NOT NULL
contract_level            | enum('generic','specific') | NULL
parent_code               | varchar(50)     | NULL
product_code              | varchar(100)    | NOT NULL
product_name              | varchar(200)    | NOT NULL
scraping_method           | enum('API','HTML','HYBRID') | NULL
is_active                 | tinyint(1)      | NULL
country_code              | varchar(10)     | NULL
country_name              | varchar(100)    | NULL
api_symbol                | varchar(200)    | NULL
api_endpoint              | varchar(500)    | NULL
api_method                | varchar(20)     | NULL
contract_period           | varchar(50)     | NULL
maturity_date             | date            | NULL
contract_year             | year(4)         | NULL
contract_quarter          | tinyint(4)      | NULL
contract_month            | tinyint(4)      | NULL
is_favorite               | tinyint(1)      | NULL
has_year_variants         | tinyint(1)      | NULL
has_quarter_variants      | tinyint(1)      | NULL
has_month_variants        | tinyint(1)      | NULL
target_table              | varchar(100)    | NULL
delivery_type             | varchar(50)     | NULL
spot_market_type          | varchar(50)     | NULL
delivery_start            | date            | NULL
delivery_end              | date            | NULL
granularity               | varchar(50)     | NULL
region                    | varchar(100)    | NULL
market_area               | varchar(100)    | NULL
expected_records_per_day  | int(11)         | NULL
expected_frequency        | varchar(50)     | NULL
data_available_from       | date            | NULL
data_available_to         | date            | NULL
currency                  | varchar(10)     | NULL
unit                      | varchar(50)     | NULL
importance                | enum('principal','secondaire','mineur') | NULL
priority                  | int(11)         | NULL
is_available              | tinyint(1)      | NULL
trading_status            | enum('active','expired','future','suspended') | NULL
is_deprecated             | tinyint(1)      | NULL
service_id                | varchar(50)     | NULL
first_seen_date           | date            | NULL
last_checked_date         | datetime        | NULL
activated_date            | datetime        | NULL
deactivated_date          | datetime        | NULL
deprecated_date           | datetime        | NULL
total_scraped_records     | int(11)         | NULL
last_scraped_date         | date            | NULL
last_scrape_success       | datetime        | NULL
last_scrape_error         | datetime        | NULL
error_count               | int(11)         | NULL
success_rate              | decimal(5,2)    | NULL
description               | text            | NULL
notes                     | text            | NULL
tags                      | varchar(500)    | NULL
config_json               | longtext        | NULL
created_at                | timestamp       | NOT NULL
updated_at                | timestamp       | NOT NULL
created_by                | varchar(100)    | NULL
updated_by                | varchar(100)    | NULL