=== ANALYSE STRUCTURE TABLE ===

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

=== CONTRAINTE UNIQUE ===
Contrainte: `provider`,`product_type`,`product_code`

=== ÉCHANTILLON DONNÉES ===
  Provider: EEX, Type: GAS_SPOT, Code: '#E.TTF_GND1', Symbol: '#E.TTF_GND1', Name: 'TTF Gas Day-Ahead'
  Provider: EEX, Type: GAS_SPOT, Code: '#E.PEG_GND1', Symbol: '#E.PEG_GND1', Name: 'PEG Gas Day-Ahead'
  Provider: EEX, Type: GAS_SPOT, Code: '#E.NBP_GPND', Symbol: '#E.NBP_GPND', Name: 'NBP Gas Day-Ahead'