Diagnostic dm_mega_catalog

1. Structure de la table

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

2. Nombre total d'enregistrements

Total: 682

3. Providers disponibles

Provider	Nombre
EEX	617
Nordpool	33
EPEX	22
CME	10

4. Favoris par provider

Provider	Total	Favoris
EEX	617	79
Nordpool	33	0
EPEX	22	0
CME	10	0

5. Types de produits par provider

EPEX

SPOT_POWER: 22 produits

EEX

POWER_FUTURE: 284 produits
GAS_FUTURE: 206 produits
GAS_SPOT: 86 produits
FREIGHT_FUTURE: 23 produits
GO: 9 produits
AGRICULTURAL_FUTURE: 5 produits
CO2_FUTURE: 3 produits
UNKNOWN_FUTURE: 1 produits

Nordpool

SPOT_POWER: 17 produits
POWER_FUTURE: 16 produits

CME

ENERGY_FUTURE: 6 produits
FX_FUTURE: 2 produits
COMMODITY_FUTURE: 2 produits

6. Exemples d'enregistrements (5 premiers)

id	provider	product_type	contract_level	product_code	product_name	scraping_method	is_active	auction	country_code	country_name	api_symbol	api_endpoint	api_method	target_table	spot_market_type	granularity	market_area	expected_records_per_day	currency	unit	importance	priority	is_available	trading_status	service_id	success_rate	description	notes	created_at	updated_at	created_by	updated_by
1	EPEX	SPOT_POWER	generic	FR	EPEX Spot France	HTML	1	MRC	FR	France		https://www.epexspot.com/en/market-data?market_area=FR&trading_date=	GET	scrapp_epex_v2	Day-Ahead	15min	FR	96	EUR	€/MWh	principal	50	1	active	epex_spot	100.00	Marché spot Day-Ahead français - 96 quarts d'heure		2025-10-31 11:06:51	2025-11-20 09:19:42	system	system
2	EPEX	SPOT_POWER	generic	BE	EPEX Spot Belgique	HTML	1	MRC	BE	Belgique		https://www.epexspot.com/en/market-data?market_area=BE&trading_date=	GET	scrapp_epex_v2	Day-Ahead	15min	BE	96	EUR	€/MWh	principal	50	1	active	epex_spot	100.00	Marché spot Day-Ahead belge - 96 quarts d'heure		2025-10-31 11:06:51	2025-11-05 17:22:32	system	system
3	EPEX	SPOT_POWER	generic	CH	EPEX Spot Suisse	HTML	1	CH	CH	Suisse		https://www.epexspot.com/en/market-data?market_area=CH&trading_date=	GET	scrapp_epex_v2	Day-Ahead	hourly	CH	24	EUR	€/MWh	secondaire	50	1	active	epex_spot	100.00	Marché spot Day-Ahead suisse - 24 heures		2025-10-31 11:06:51	2025-11-05 17:22:35	system	system
4	EPEX	SPOT_POWER	generic	GB	EPEX Spot Grande-Bretagne	HTML	1	GB	GB	Royaume-Uni		https://www.epexspot.com/en/market-data?market_area=GB&trading_date=	GET	scrapp_epex_v2	Day-Ahead	hourly	GB	24	GBP	£/MWh	secondaire	50	1	active	epex_spot	100.00	Marché spot Day-Ahead britannique - 24 heures		2025-10-31 11:06:51	2025-11-05 17:22:48	system	system
22	EEX	GO	generic	GO-EU	Garanties d'Origine Européennes	API	0		EU	Union Européenne	TBD		GET	eex_v2_futures					EUR		secondaire	50	1	active		100.00	Garanties d'origine pour l'électricité renouvelable	À implémenter - nécessite investigation API EEX	2025-10-31 11:06:52	2025-11-03 12:00:52	system	target_table_update