# Dictionnaire ERP — INDEX

Généré le **2026-08-05 08:59:53** — base `erp_immo_migrate_1113` — 193 tables · 1760 colonnes analysées — 4.05 s

> Lecture seule. Aucune donnée personnelle (noms, emails, téléphones, IBAN, SIRET, commentaires).
> Relancer : `php tools/diag/dictionnaire.php` · détail module : `php tools/diag/dictionnaire.php commercial`
> **Attention** : volume `reservations` = 0 sur cette base — les taux de remplissage ne sont pas significatifs. Relancer sur la base prod (OVH) pour les chiffres métier.

## Tables (une ligne)

| Module | Table | Vol. | Cols | Mortes | SoftDel | Alertes |
|--------|-------|------|------|--------|---------|---------|
| admin | `migrations` | 364 | 2 | 0 | non | 0 |
| admin | `feature_permission_groups` | 14 | 2 | 0 | non | 0 |
| admin | `settings` | 12 | 6 | 0 | non | 0 |
| admin | `groupes_m365` | 10 | 7 | 1 | non | 0 |
| admin | `features_permissions` | 8 | 5 | 0 | non | 0 |
| admin | `enseignes` | 3 | 10 | 4 | non | 0 |
| admin | `api_logs` | 0 | 19 | 0 | non | 1 |
| admin | `audit_log_permissions` | 0 | 5 | 0 | non | 1 |
| admin | `bug_reports` | 0 | 12 | 0 | non | 1 |
| admin | `bug_report_commentaires` | 0 | 3 | 0 | non | 1 |
| admin | `cache` | 0 | 3 | 0 | non | 1 |
| admin | `cache_locks` | 0 | 3 | 0 | non | 1 |
| admin | `collaborateurs` | 0 | 6 | 0 | non | 1 |
| admin | `communes` | 0 | 10 | 0 | non | 1 |
| admin | `comptes_bancaires` | 0 | 13 | 0 | non | 1 |
| admin | `comptes_comptables` | 0 | 5 | 0 | non | 1 |
| admin | `demandes_fournisseurs` | 0 | 16 | 0 | non | 1 |
| admin | `demande_fournisseur_historique` | 0 | 7 | 0 | non | 1 |
| admin | `entites` | 0 | 8 | 0 | non | 1 |
| admin | `entite_commentaires` | 0 | 4 | 0 | non | 1 |
| admin | `entite_commentaire_mentions` | 0 | 4 | 0 | non | 1 |
| admin | `etablissements` | 0 | 5 | 0 | non | 1 |
| admin | `failed_jobs` | 0 | 6 | 0 | non | 1 |
| admin | `fournisseurs` | 0 | 27 | 0 | non | 1 |
| admin | `fournisseur_audit_statuts` | 0 | 7 | 0 | non | 1 |
| admin | `impersonation_logs` | 0 | 6 | 0 | non | 1 |
| admin | `intacct_classes` | 0 | 5 | 0 | non | 1 |
| admin | `intacct_financial_entities` | 0 | 17 | 0 | non | 1 |
| admin | `jobs` | 0 | 5 | 0 | non | 1 |
| admin | `job_batches` | 0 | 8 | 0 | non | 1 |
| admin | `journal_mises_a_jour` | 0 | 6 | 0 | oui | 1 |
| admin | `leads_marketing` | 0 | 23 | 0 | non | 1 |
| admin | `meta_campaign_codes` | 0 | 6 | 0 | oui | 1 |
| admin | `meta_health_checks` | 0 | 6 | 0 | non | 1 |
| admin | `notifications` | 0 | 5 | 0 | non | 1 |
| admin | `password_reset_tokens` | 0 | 2 | 0 | non | 1 |
| admin | `services_intacct` | 0 | 5 | 0 | non | 1 |
| admin | `sessions` | 0 | 5 | 0 | non | 1 |
| admin | `todo_items` | 0 | 9 | 0 | non | 1 |
| admin | `users` | 0 | 14 | 0 | non | 1 |
| admin | `user_dashboard_widgets` | 0 | 7 | 0 | non | 1 |
| admin | `workflow_validations` | 0 | 12 | 0 | non | 1 |
| aides | `aide_articles` | 0 | 7 | 0 | non | 1 |
| aides | `aide_article_groupes` | 0 | 2 | 0 | non | 1 |
| aides | `aide_article_tag` | 0 | 2 | 0 | non | 1 |
| aides | `aide_medias` | 0 | 6 | 0 | non | 1 |
| aides | `aide_rubriques` | 0 | 5 | 0 | non | 1 |
| aides | `aide_tags` | 0 | 3 | 0 | non | 1 |
| alertes | `alertes` | 0 | 12 | 0 | non | 1 |
| ao | `ao_consultations` | 0 | 11 | 0 | non | 1 |
| ao | `ao_devis` | 0 | 11 | 0 | non | 1 |
| ao | `ao_lots` | 0 | 7 | 0 | non | 1 |
| ao | `appels_offres` | 0 | 24 | 0 | oui | 1 |
| assistant | `assistant_consolidations` | 0 | 10 | 0 | non | 1 |
| assistant | `assistant_conversations` | 0 | 6 | 0 | oui | 1 |
| assistant | `assistant_conversation_taches` | 0 | 2 | 0 | non | 1 |
| assistant | `assistant_messages` | 0 | 4 | 0 | non | 1 |
| assistant | `assistant_message_documents` | 0 | 7 | 0 | non | 1 |
| assistant | `assistant_propositions` | 0 | 7 | 0 | non | 1 |
| assistant | `assistant_suggestions` | 0 | 5 | 0 | non | 1 |
| autre | `lahouari_scores` | 0 | 2 | 0 | non | 1 |
| bilan_budget | `bilan_commentaires` | 0 | 4 | 0 | non | 1 |
| bilan_budget | `bilan_etude_fi_historique` | 0 | 8 | 0 | non | 1 |
| bilan_budget | `categories_frais_generaux` | 0 | 5 | 0 | non | 1 |
| bilan_budget | `lignes_financement` | 0 | 26 | 0 | non | 1 |
| bilan_budget | `postes_budgetaires` | 0 | 8 | 0 | non | 1 |
| bilan_budget | `postes_budgetaires_types` | 0 | 20 | 0 | non | 1 |
| bilan_budget | `programme_budgets` | 0 | 8 | 0 | oui | 1 |
| bilan_budget | `programme_budget_revisions` | 0 | 5 | 0 | non | 1 |
| bilan_budget | `rubriques_bilan` | 0 | 5 | 0 | non | 1 |
| cie | `cie_operations` | 0 | 11 | 0 | oui | 1 |
| cie | `cie_repartitions` | 0 | 5 | 0 | non | 1 |
| commercial | `appels_de_fonds` | 0 | 22 | 0 | non | 1 |
| commercial | `appels_de_fonds_sequences` | 0 | 3 | 0 | non | 1 |
| commercial | `appels_fonds` | 0 | 15 | 0 | oui | 1 |
| commercial | `appels_fonds_associes` | 0 | 7 | 0 | non | 1 |
| commercial | `contacts` | 0 | 32 | 0 | oui | 1 |
| commercial | `contact_access_logs` | 0 | 4 | 0 | non | 1 |
| commercial | `contact_documents` | 0 | 5 | 0 | non | 1 |
| commercial | `contact_programme` | 0 | 3 | 0 | non | 1 |
| commercial | `lots` | 0 | 0 | 0 | non | 1 |
| commercial | `lots_commerciaux` | 0 | 25 | 0 | oui | 1 |
| commercial | `lot_annexes` | 0 | 5 | 0 | non | 1 |
| commercial | `lot_commercial_historique` | 0 | 5 | 0 | non | 1 |
| commercial | `lot_emplacements` | 0 | 4 | 0 | non | 1 |
| commercial | `offres_commerciales` | 0 | 11 | 0 | oui | 1 |
| commercial | `reservations` | 0 | 73 | 0 | oui | 1 |
| commercial | `reservation_documents` | 0 | 7 | 0 | non | 1 |
| commercial | `reservation_historique` | 0 | 5 | 0 | non | 1 |
| commercial | `reservation_observations` | 0 | 3 | 0 | non | 1 |
| factures | `types_factures` | 8 | 3 | 0 | non | 0 |
| factures | `application_avoir` | 0 | 5 | 0 | non | 1 |
| factures | `depot_factures` | 0 | 40 | 0 | oui | 1 |
| factures | `depot_facture_retenues_historiques` | 0 | 9 | 0 | non | 1 |
| factures | `documents_factures` | 0 | 6 | 0 | oui | 1 |
| factures | `factures` | 0 | 41 | 0 | oui | 1 |
| factures | `facture_commentaires` | 0 | 3 | 0 | oui | 1 |
| factures | `facture_commentaire_mentions` | 0 | 4 | 0 | non | 1 |
| factures | `facture_historique` | 0 | 7 | 0 | non | 1 |
| factures | `facture_intacct_apbill_lignes` | 0 | 6 | 0 | non | 1 |
| factures | `facture_lignes_tva` | 0 | 4 | 0 | non | 1 |
| factures | `facture_penalites` | 0 | 2 | 0 | non | 1 |
| factures | `facture_reaffectations` | 0 | 5 | 0 | non | 1 |
| factures | `facture_ventilations` | 0 | 9 | 0 | non | 1 |
| factures | `paiements_intacct` | 0 | 13 | 0 | non | 1 |
| factures | `retenues_garantie` | 0 | 12 | 0 | non | 1 |
| foncier | `types_conditions_suspensives` | 10 | 4 | 0 | non | 0 |
| foncier | `motifs_veille` | 7 | 3 | 0 | non | 0 |
| foncier | `foncier_alerte_configs` | 4 | 4 | 0 | non | 0 |
| foncier | `actes_fonciers` | 0 | 8 | 0 | non | 1 |
| foncier | `acte_parcelle` | 0 | 2 | 0 | non | 1 |
| foncier | `conditions_suspensives` | 0 | 7 | 0 | non | 1 |
| foncier | `dossiers_fonciers` | 0 | 14 | 0 | non | 1 |
| foncier | `dossier_foncier_parcelle` | 0 | 2 | 0 | non | 1 |
| foncier | `dossier_foncier_proprietaire` | 0 | 2 | 0 | non | 1 |
| foncier | `dossier_foncier_responsable` | 0 | 2 | 0 | non | 1 |
| foncier | `entity_documents` | 0 | 9 | 0 | non | 1 |
| foncier | `entity_field_audits` | 0 | 6 | 0 | non | 1 |
| foncier | `foncier_alertes_emises` | 0 | 9 | 0 | non | 1 |
| foncier | `foncier_alerte_runs` | 0 | 5 | 0 | non | 1 |
| foncier | `offres_foncieres` | 0 | 14 | 0 | non | 1 |
| foncier | `offre_parcelle` | 0 | 3 | 0 | non | 1 |
| foncier | `parcelles` | 0 | 15 | 0 | non | 1 |
| foncier | `parcelle_proprietaire` | 0 | 7 | 0 | non | 1 |
| foncier | `promesses` | 0 | 26 | 0 | non | 1 |
| foncier | `promesse_parcelle` | 0 | 3 | 0 | non | 1 |
| foncier | `proprietaires` | 0 | 20 | 0 | non | 1 |
| foncier | `proprietaire_access_logs` | 0 | 4 | 0 | non | 1 |
| foncier | `record_habilitations` | 0 | 6 | 0 | non | 1 |
| foncier | `secteurs` | 0 | 3 | 0 | non | 1 |
| foncier | `secteur_perimetres` | 0 | 4 | 0 | non | 1 |
| foncier | `secteur_suppleants` | 0 | 2 | 0 | non | 1 |
| juridique | `contentieux_juridiques` | 0 | 20 | 0 | non | 1 |
| juridique | `demandes_juridiques` | 0 | 11 | 0 | non | 1 |
| juridique | `demande_juridique_historique` | 0 | 7 | 0 | non | 1 |
| juridique | `demande_suiveurs` | 0 | 2 | 0 | non | 1 |
| juridique | `non_conformites_juridiques` | 0 | 11 | 0 | non | 1 |
| juridique | `pieces_jointes` | 0 | 6 | 0 | non | 1 |
| juridique | `precontentieux_juridiques` | 0 | 16 | 0 | non | 1 |
| location | `location_annonces` | 0 | 9 | 0 | oui | 1 |
| location | `location_audits_candidature` | 0 | 6 | 0 | non | 1 |
| location | `location_candidats` | 0 | 21 | 0 | non | 1 |
| location | `location_candidatures` | 0 | 20 | 0 | oui | 1 |
| location | `location_candidature_commentaires` | 0 | 3 | 0 | non | 1 |
| location | `location_candidature_tokens` | 0 | 4 | 0 | non | 1 |
| location | `location_garants` | 0 | 21 | 0 | non | 1 |
| location | `location_pieces_candidature` | 0 | 10 | 0 | non | 1 |
| marches | `avenants` | 0 | 8 | 0 | non | 1 |
| marches | `avenant_documents` | 0 | 6 | 0 | non | 1 |
| marches | `marches` | 0 | 34 | 0 | oui | 1 |
| marches | `marche_cp_historiques` | 0 | 6 | 0 | non | 1 |
| marches | `marche_devis` | 0 | 5 | 0 | non | 1 |
| marches | `marche_devis_documents` | 0 | 7 | 0 | non | 1 |
| marches | `marche_documents` | 0 | 9 | 0 | non | 1 |
| marches | `marche_historique` | 0 | 6 | 0 | non | 1 |
| marches | `marche_reprise_lignes` | 0 | 8 | 0 | non | 1 |
| marches | `marche_sous_traitants` | 0 | 6 | 0 | non | 1 |
| marches | `penalites` | 0 | 14 | 0 | non | 1 |
| marches | `prestations_tma_programme_overrides` | 0 | 4 | 0 | non | 1 |
| marches | `situations` | 0 | 11 | 0 | non | 1 |
| programmes | `etapes_modeles` | 17 | 13 | 6 | non | 0 |
| programmes | `compte_prorata_sorties` | 0 | 8 | 0 | oui | 1 |
| programmes | `concessionnaire_factures` | 0 | 13 | 0 | non | 1 |
| programmes | `distributions_associes` | 0 | 6 | 0 | non | 1 |
| programmes | `ged_actions_log` | 0 | 8 | 0 | non | 1 |
| programmes | `nf_classeurs` | 0 | 8 | 0 | oui | 1 |
| programmes | `nf_referentiel_pieces_jointes` | 0 | 6 | 0 | non | 1 |
| programmes | `nf_referentiel_reponses` | 0 | 6 | 0 | oui | 1 |
| programmes | `nf_remarques` | 0 | 10 | 0 | oui | 1 |
| programmes | `nf_remarque_pieces_jointes` | 0 | 6 | 0 | non | 1 |
| programmes | `programmes` | 0 | 37 | 0 | oui | 1 |
| programmes | `programme_associes` | 0 | 8 | 0 | non | 1 |
| programmes | `programme_etapes` | 0 | 17 | 0 | non | 1 |
| programmes | `programme_responsables` | 0 | 6 | 0 | non | 1 |
| programmes | `stades_avancement` | 0 | 6 | 0 | non | 1 |
| programmes | `taxes` | 0 | 11 | 0 | non | 1 |
| taches | `task_types` | 5 | 8 | 1 | non | 0 |
| taches | `etiquettes` | 0 | 7 | 0 | non | 1 |
| taches | `projets` | 0 | 4 | 0 | oui | 1 |
| taches | `projet_personnes` | 0 | 3 | 0 | non | 1 |
| taches | `taches_digest_envois` | 0 | 2 | 0 | non | 1 |
| taches | `taches_digest_runs` | 0 | 4 | 0 | non | 1 |
| taches | `taches_suivi` | 0 | 13 | 0 | oui | 1 |
| taches | `tache_suivi_checklist_items` | 0 | 6 | 0 | non | 1 |
| taches | `tache_suivi_commentaires` | 0 | 5 | 0 | oui | 1 |
| taches | `tache_suivi_commentaire_mentions` | 0 | 4 | 0 | non | 1 |
| taches | `tache_suivi_documents` | 0 | 7 | 0 | non | 1 |
| taches | `tache_suivi_etiquette` | 0 | 2 | 0 | non | 1 |
| taches | `tache_suivi_personnes` | 0 | 3 | 0 | non | 1 |
| taches | `tasks` | 0 | 21 | 0 | non | 1 |
| tma | `prestations_tma` | 0 | 7 | 0 | non | 1 |
| tma | `tmas` | 0 | 39 | 0 | oui | 1 |
| tma | `tma_lignes` | 0 | 9 | 0 | non | 1 |

## Colonnes mortes par module

- **admin** : 5
- **aides** : 0
- **alertes** : 0
- **ao** : 0
- **assistant** : 0
- **autre** : 0
- **bilan_budget** : 0
- **cie** : 0
- **commercial** : 0
- **factures** : 0
- **foncier** : 0
- **juridique** : 0
- **location** : 0
- **marches** : 0
- **programmes** : 6
- **taches** : 1
- **tma** : 0

## Notions potentiellement dupliquées

### `tma_montant`
- reservations.tma_montant
- lots_commerciaux.tma_montant_ttc
- tmas (module TMA — montant via lignes / devis, hors colonnes legacy réservation)

### `prix_vente_ttc`
- reservations.prix_vente_ttc
- lots_commerciaux.prix_vente_ttc
- reservation_lots.prix_vente_ttc

### `remises`
- reservations.remises_commerciales_ttc
- lots_commerciaux.remises_ttc

### `notaire`
- reservations.notaire (texte)
- reservations.notaire_fournisseur_id (FK)
- reservations.notaire_double_minute (texte)
- reservations.notaire_double_minute_fournisseur_id (FK)

### `agence_partenaire`
- reservations.agence_nom (texte)
- reservations.agence_fournisseur_id (FK)
- lots_commerciaux.agence_nom (legacy)

### `delai_reflexion_sru`
- reservations.date_sru_fin_delai (calculée Observer)
- reservations.date_expir_reflexion (hors saisie #1179)

### `notification_sru`
- reservations.date_notif_sru (historique / RO #1179)
- reservations.date_sru_envoi (pilote calcul)
- reservations.date_ar_client (réception AR #1178)

### `appels_de_fonds`
- appels_fonds (legacy)
- appels_de_fonds (Intacct)

## Interrupteurs (silences configurés)

- `app/Http/Controllers/TMAController.php:306` — `Log::info('Email désactivé pour [devis TMA client]', [`
- `app/Jobs/UploadAoDocumentToSharePoint.php:123` — `Log::info('Email désactivé pour [alerte SharePoint échec document AO]', [`
- `app/Jobs/UploadDevisToSharePoint.php:105` — `Log::info('Email désactivé pour [alerte SharePoint échec devis AO]', [`
- `app/Services/AlerteService.php:34` — `private const GENERATION_ACTIVE = false;`
- `app/Services/AlerteService.php:1353` — `Log::info('Email désactivé pour [alerte réservation acquéreur]', [`
- `app/Services/NotificationFactureService.php:29` — `Log::info('Email désactivé pour [validation facture NV1]', [`
- `app/Services/NotificationFactureService.php:101` — `Log::info('Email désactivé pour [validation facture NV2 / PDG]', [`
- `app/Services/NotificationFactureService.php:143` — `Log::info('Email désactivé pour [validation facture comptabilité]', [`
- `app/Services/NotificationFactureService.php:154` — `Log::info('Email désactivé pour [relance validation facture]', [`

## FK ON DELETE CASCADE vers `lots_commerciaux`

| Contrainte | Table enfant | Colonne | Volume enfant |
|------------|--------------|---------|---------------|
| `appels_de_fonds_lot_commercial_id_foreign` | `appels_de_fonds` | `lot_commercial_id` | 0 |
| `lot_annexes_lot_fk` | `lot_annexes` | `lot_commercial_id` | 0 |
| `lot_commercial_historique_lot_commercial_id_foreign` | `lot_commercial_historique` | `lot_commercial_id` | 0 |
| `lot_emplacements_lot_commercial_id_foreign` | `lot_emplacements` | `lot_commercial_id` | 0 |
| `offres_commerciales_lot_commercial_id_foreign` | `offres_commerciales` | `lot_commercial_id` | 0 |
| `reservations_lot_commercial_id_foreign` | `reservations` | `lot_commercial_id` | 0 |

## Dettes assumées (hors alerte)

- dual-write reservations.lot_commercial_id + pivot reservation_lots (#1167)
- lots_commerciaux.prix_vente_ttc copie du pivot (#1168)
- appels_de_fonds.lot_commercial_id = lot principal (#1168)
- contacts.co_acquereur / co_contact_id legacy (#1160)
- notaire et agence en texte libre hors FK (#1163, #1174)
- reservations.tma_montant + lots_commerciaux.tma_montant_ttc colonnes conservées hors UI (#1170)
- reservations.date_notif_sru déprécié de la saisie, colonne conservée (#1179)
- SharePoint non renommé après rattachement multi-lots (#1169)

## Tables à 0 ligne

- `actes_fonciers` (foncier) — 8 cols
- `acte_parcelle` (foncier) — 2 cols
- `aide_articles` (aides) — 7 cols
- `aide_article_groupes` (aides) — 2 cols
- `aide_article_tag` (aides) — 2 cols
- `aide_medias` (aides) — 6 cols
- `aide_rubriques` (aides) — 5 cols
- `aide_tags` (aides) — 3 cols
- `alertes` (alertes) — 12 cols
- `ao_consultations` (ao) — 11 cols
- `ao_devis` (ao) — 11 cols
- `ao_lots` (ao) — 7 cols
- `api_logs` (admin) — 19 cols
- `appels_de_fonds` (commercial) — 22 cols
- `appels_de_fonds_sequences` (commercial) — 3 cols
- `appels_fonds` (commercial) — 15 cols
- `appels_fonds_associes` (commercial) — 7 cols
- `appels_offres` (ao) — 24 cols
- `application_avoir` (factures) — 5 cols
- `assistant_consolidations` (assistant) — 10 cols
- `assistant_conversations` (assistant) — 6 cols
- `assistant_conversation_taches` (assistant) — 2 cols
- `assistant_messages` (assistant) — 4 cols
- `assistant_message_documents` (assistant) — 7 cols
- `assistant_propositions` (assistant) — 7 cols
- `assistant_suggestions` (assistant) — 5 cols
- `audit_log_permissions` (admin) — 5 cols
- `avenants` (marches) — 8 cols
- `avenant_documents` (marches) — 6 cols
- `bilan_commentaires` (bilan_budget) — 4 cols
- `bilan_etude_fi_historique` (bilan_budget) — 8 cols
- `bug_reports` (admin) — 12 cols
- `bug_report_commentaires` (admin) — 3 cols
- `cache` (admin) — 3 cols
- `cache_locks` (admin) — 3 cols
- `categories_frais_generaux` (bilan_budget) — 5 cols
- `cie_operations` (cie) — 11 cols
- `cie_repartitions` (cie) — 5 cols
- `collaborateurs` (admin) — 6 cols
- `communes` (admin) — 10 cols
- `comptes_bancaires` (admin) — 13 cols
- `comptes_comptables` (admin) — 5 cols
- `compte_prorata_sorties` (programmes) — 8 cols
- `concessionnaire_factures` (programmes) — 13 cols
- `conditions_suspensives` (foncier) — 7 cols
- `contacts` (commercial) — 32 cols
- `contact_access_logs` (commercial) — 4 cols
- `contact_documents` (commercial) — 5 cols
- `contact_programme` (commercial) — 3 cols
- `contentieux_juridiques` (juridique) — 20 cols
- `demandes_fournisseurs` (admin) — 16 cols
- `demandes_juridiques` (juridique) — 11 cols
- `demande_fournisseur_historique` (admin) — 7 cols
- `demande_juridique_historique` (juridique) — 7 cols
- `demande_suiveurs` (juridique) — 2 cols
- `depot_factures` (factures) — 40 cols
- `depot_facture_retenues_historiques` (factures) — 9 cols
- `distributions_associes` (programmes) — 6 cols
- `documents_factures` (factures) — 6 cols
- `dossiers_fonciers` (foncier) — 14 cols
- `dossier_foncier_parcelle` (foncier) — 2 cols
- `dossier_foncier_proprietaire` (foncier) — 2 cols
- `dossier_foncier_responsable` (foncier) — 2 cols
- `entites` (admin) — 8 cols
- `entite_commentaires` (admin) — 4 cols
- `entite_commentaire_mentions` (admin) — 4 cols
- `entity_documents` (foncier) — 9 cols
- `entity_field_audits` (foncier) — 6 cols
- `etablissements` (admin) — 5 cols
- `etiquettes` (taches) — 7 cols
- `factures` (factures) — 41 cols
- `facture_commentaires` (factures) — 3 cols
- `facture_commentaire_mentions` (factures) — 4 cols
- `facture_historique` (factures) — 7 cols
- `facture_intacct_apbill_lignes` (factures) — 6 cols
- `facture_lignes_tva` (factures) — 4 cols
- `facture_penalites` (factures) — 2 cols
- `facture_reaffectations` (factures) — 5 cols
- `facture_ventilations` (factures) — 9 cols
- `failed_jobs` (admin) — 6 cols
- `foncier_alertes_emises` (foncier) — 9 cols
- `foncier_alerte_runs` (foncier) — 5 cols
- `fournisseurs` (admin) — 27 cols
- `fournisseur_audit_statuts` (admin) — 7 cols
- `ged_actions_log` (programmes) — 8 cols
- `impersonation_logs` (admin) — 6 cols
- `intacct_classes` (admin) — 5 cols
- `intacct_financial_entities` (admin) — 17 cols
- `jobs` (admin) — 5 cols
- `job_batches` (admin) — 8 cols
- `journal_mises_a_jour` (admin) — 6 cols
- `lahouari_scores` (autre) — 2 cols
- `leads_marketing` (admin) — 23 cols
- `lignes_financement` (bilan_budget) — 26 cols
- `location_annonces` (location) — 9 cols
- `location_audits_candidature` (location) — 6 cols
- `location_candidats` (location) — 21 cols
- `location_candidatures` (location) — 20 cols
- `location_candidature_commentaires` (location) — 3 cols
- `location_candidature_tokens` (location) — 4 cols
- `location_garants` (location) — 21 cols
- `location_pieces_candidature` (location) — 10 cols
- `lots` (commercial) — 0 cols
- `lots_commerciaux` (commercial) — 25 cols
- `lot_annexes` (commercial) — 5 cols
- `lot_commercial_historique` (commercial) — 5 cols
- `lot_emplacements` (commercial) — 4 cols
- `marches` (marches) — 34 cols
- `marche_cp_historiques` (marches) — 6 cols
- `marche_devis` (marches) — 5 cols
- `marche_devis_documents` (marches) — 7 cols
- `marche_documents` (marches) — 9 cols
- `marche_historique` (marches) — 6 cols
- `marche_reprise_lignes` (marches) — 8 cols
- `marche_sous_traitants` (marches) — 6 cols
- `meta_campaign_codes` (admin) — 6 cols
- `meta_health_checks` (admin) — 6 cols
- `nf_classeurs` (programmes) — 8 cols
- `nf_referentiel_pieces_jointes` (programmes) — 6 cols
- `nf_referentiel_reponses` (programmes) — 6 cols
- `nf_remarques` (programmes) — 10 cols
- `nf_remarque_pieces_jointes` (programmes) — 6 cols
- `non_conformites_juridiques` (juridique) — 11 cols
- `notifications` (admin) — 5 cols
- `offres_commerciales` (commercial) — 11 cols
- `offres_foncieres` (foncier) — 14 cols
- `offre_parcelle` (foncier) — 3 cols
- `paiements_intacct` (factures) — 13 cols
- `parcelles` (foncier) — 15 cols
- `parcelle_proprietaire` (foncier) — 7 cols
- `password_reset_tokens` (admin) — 2 cols
- `penalites` (marches) — 14 cols
- `pieces_jointes` (juridique) — 6 cols
- `postes_budgetaires` (bilan_budget) — 8 cols
- `postes_budgetaires_types` (bilan_budget) — 20 cols
- `precontentieux_juridiques` (juridique) — 16 cols
- `prestations_tma` (tma) — 7 cols
- `prestations_tma_programme_overrides` (marches) — 4 cols
- `programmes` (programmes) — 37 cols
- `programme_associes` (programmes) — 8 cols
- `programme_budgets` (bilan_budget) — 8 cols
- `programme_budget_revisions` (bilan_budget) — 5 cols
- `programme_etapes` (programmes) — 17 cols
- `programme_responsables` (programmes) — 6 cols
- `projets` (taches) — 4 cols
- `projet_personnes` (taches) — 3 cols
- `promesses` (foncier) — 26 cols
- `promesse_parcelle` (foncier) — 3 cols
- `proprietaires` (foncier) — 20 cols
- `proprietaire_access_logs` (foncier) — 4 cols
- `record_habilitations` (foncier) — 6 cols
- `reservations` (commercial) — 73 cols
- `reservation_documents` (commercial) — 7 cols
- `reservation_historique` (commercial) — 5 cols
- `reservation_observations` (commercial) — 3 cols
- `retenues_garantie` (factures) — 12 cols
- `rubriques_bilan` (bilan_budget) — 5 cols
- `secteurs` (foncier) — 3 cols
- `secteur_perimetres` (foncier) — 4 cols
- `secteur_suppleants` (foncier) — 2 cols
- `services_intacct` (admin) — 5 cols
- `sessions` (admin) — 5 cols
- `situations` (marches) — 11 cols
- `stades_avancement` (programmes) — 6 cols
- `taches_digest_envois` (taches) — 2 cols
- `taches_digest_runs` (taches) — 4 cols
- `taches_suivi` (taches) — 13 cols
- `tache_suivi_checklist_items` (taches) — 6 cols
- `tache_suivi_commentaires` (taches) — 5 cols
- `tache_suivi_commentaire_mentions` (taches) — 4 cols
- `tache_suivi_documents` (taches) — 7 cols
- `tache_suivi_etiquette` (taches) — 2 cols
- `tache_suivi_personnes` (taches) — 3 cols
- `tasks` (taches) — 21 cols
- `taxes` (programmes) — 11 cols
- `tmas` (tma) — 39 cols
- `tma_lignes` (tma) — 9 cols
- `todo_items` (admin) — 9 cols
- `users` (admin) — 14 cols
- `user_dashboard_widgets` (admin) — 7 cols
- `workflow_validations` (admin) — 12 cols