=== APPOINTMENTS ===
id - int unsigned
inspection_id - int unsigned
order_id - int unsigned
site_id - int unsigned
cee_operation_id - int unsigned
inspector_id - int unsigned
appointment_date - date
appointment_time - time
duration_minutes - int
status - enum('pending_call','scheduled','confirmed','in_progress','completed','cancelled','rescheduled')
contact_name - varchar(200)
contact_phone - varchar(20)
call_scheduled_date - date
called_at - datetime
confirmed_at - datetime
completed_at - datetime
call_notes - text
is_sampled - tinyint(1)
sampling_batch_id - int unsigned
site_latitude - decimal(10,8)
site_longitude - decimal(11,8)
distance_from_previous_km - decimal(8,2)
priority - enum('low','normal','high','urgent')
deadline - date
notes - text
created_at - timestamp
updated_at - timestamp

=== INSPECTIONS ===
id - int unsigned
reference - varchar(50)
order_id - int unsigned
appointment_id - int unsigned
site_id - int unsigned
cee_operation_id - int unsigned
inspector_id - int unsigned
status - enum('draft','scheduled','in_progress','completed','cancelled')
cancelled_at - datetime
cancellation_reason - text
type - enum('initial','complementary','contradictory')
scheduled_date - date
scheduled_time - time
start_latitude - decimal(10,8)
start_longitude - decimal(11,8)
start_accuracy - float
end_latitude - decimal(10,8)
end_longitude - decimal(11,8)
started_at - timestamp
completed_at - timestamp
duration_minutes - int
notes - text
client_signature - varchar(500)
client_signatory_name - varchar(100)
inspector_signature - varchar(500)
created_at - timestamp
updated_at - timestamp
synced_at - timestamp
operation_group - varchar(100)
operation_type - varchar(100)
site_address - varchar(255)
site_postal_code - varchar(10)
site_city - varchar(100)
site_contact_name - varchar(200)
site_contact_phone - varchar(20)
site_latitude - decimal(10,8)
site_longitude - decimal(11,8)

=== CEE_OPERATIONS ===
id - int unsigned
excel_file_id - int unsigned
excel_row - int unsigned
internal_code - int unsigned
demandeur_raison_sociale - varchar(255)
demandeur_siren - varchar(255)
reference_emmy - varchar(100)
reference_interne - varchar(100)
operation_code_id - int unsigned
beneficiaire_nom - varchar(100)
beneficiaire_prenom - varchar(100)
beneficiaire_site_nom - varchar(255)
beneficiaire_raison_sociale - varchar(255)
beneficiaire_siren - varchar(255)
beneficiaire_siege_adresse - varchar(255)
beneficiaire_siege_cp - varchar(255)
beneficiaire_siege_ville - varchar(100)
operation_adresse - varchar(255)
operation_cp - varchar(255)
operation_ville - varchar(100)
volume_hors_precarite - decimal(15,2)
volume_precarite - decimal(15,2)
fiche_operation - varchar(20)
date_engagement - date
date_facture - date
date_achevement - date
nature_bonification - varchar(100)
professionnel_siren - varchar(255)
professionnel_raison_sociale - varchar(255)
sous_traitant_siren - varchar(255)
sous_traitant_raison_sociale - varchar(255)
nature_role_actif - varchar(255)
montant_role_actif - decimal(15,2)
controle_siren - varchar(255)
controle_raison_sociale - varchar(255)
entreprise_siret - varchar(255)
beneficiaire_telephone - varchar(20)
beneficiaire_email - varchar(255)
contact_siren - varchar(255)
contact_raison_sociale - varchar(255)
selection_aleatoire - varchar(50)
rdv_pris - varchar(50)
rdv_realise - varchar(50)
rdv_commentaire - text
date_visite - date
chantier_accessible - varchar(50)
travaux_realises - varchar(50)
surface_declaree - decimal(10,2)
surface_mesuree - decimal(10,2)
surface_estimee - decimal(10,2)
surface_retenue - decimal(10,2)
ecart_surface - decimal(5,2)
ecart_conforme - varchar(50)
ecart_raisons - text
surface_commentaires - text
isolant_type - varchar(100)
isolant_marque_reference - varchar(255)
isolant_r_lambda - varchar(50)
isolant_epaisseur_theorique - int
isolant_epaisseur_mesuree - varchar(50)
isolant_homogeneite - varchar(50)
isolant_commentaires - text
pare_vapeur - varchar(100)
capot_protection - varchar(100)
ecart_au_feu - varchar(100)
rehausse_trappe - varchar(100)
absence_blocage_trappe - varchar(50)
piges_reperage - varchar(100)
absence_humidite - varchar(50)
qualite_pose_tenue - varchar(50)
qualite_pose_continuite - varchar(50)
materiaux_combustibles - varchar(50)
qualite_commentaires - text
doc_engagement - varchar(100)
doc_realisation - varchar(100)
doc_cadre_contribution - varchar(100)
delai_7_jours - varchar(100)
documents_commentaires - text
conclusion - varchar(100)
conclusion_commentaires - text
controle_contact_effectue - varchar(50)
existence_travaux - varchar(50)
absence_non_qualite - varchar(50)
non_qualite_commentaire - text
conclusion_contact - varchar(100)
actions_correctives - text
conformite_apres_correction - varchar(50)
operation_retiree_redeposee - varchar(255)
commentaires_generaux - text
niveau_precarite - varchar(100)
version_coup_de_pouce - varchar(50)
status - enum('pending','assigned','in_progress','completed','cancelled')
assigned_inspector_id - int unsigned
inspection_id - int unsigned
filled_at - timestamp
filled_by - int unsigned
created_at - timestamp
updated_at - timestamp
source_file_id - int
source_beneficiary_type - varchar(10)
operation_lat - decimal(10,8)
operation_lng - decimal(11,8)