=== TABLE: exercices ===
  id (int) PRI
  id_copro (int) MUL
  debut (date) 
  fin (date) 
  nom (int) 
  namecode (text) 
  cloture (int) 
  encours (int) 

=== TABLE: budgets ===
  TABLE NOT FOUND

=== TABLE: appels ===
  id (int) PRI
  id_user (int) MUL
  date (date) 
  nom (text) 
  montant (decimal(10,2)) 
  chemin (text) 
  copro (int) MUL
  vue (int) 
  date_vue (datetime) 
  id_exercice (int) MUL
  trimestre (int) 

=== TABLE: comptes_bancaires ===
  TABLE NOT FOUND

=== TABLE: operations ===
  id (int) PRI
  id_user (int) MUL
  depenses (float(10,2)) 
  revenus (float(10,2)) 
  date (date) 
  contenu (text) 

=== TABLE: compta_lignes ===
  TABLE NOT FOUND

=== TABLE: factures ===
  id (int) PRI
  id_copro (int) MUL
  id_exercice (int) MUL
  fichier_nom (varchar(255)) 
  fichier_chemin (varchar(500)) 
  fichier_type (varchar(50)) 
  fichier_taille (int) 
  fichier_hash (varchar(64)) MUL
  fournisseur_nom (varchar(255)) MUL
  fournisseur_id (int) MUL
  montant_ttc (decimal(10,2)) 
  montant_ht (decimal(10,2)) 
  montant_tva (decimal(10,2)) 
  date_facture (date) MUL
  pattern_date_facture_detected (varchar(500)) 
  date_echeance (date) 
  pattern_date_echeance_detected (varchar(500)) 
  numero_facture (varchar(100)) 
  pattern_numero_detected (varchar(500)) 
  reference (varchar(100)) 
  id_operation_bancaire (int) MUL
  date_paiement (date) 
  mode_paiement (enum('virement','prelevement','cheque','cb','especes','autre')) 
  id_ecriture_comptable (int) 
  compte_401 (varchar(20)) 
  id_travaux (int) MUL
  compte_charge (varchar(20)) 
  paye_par_fond_travaux (tinyint(1)) 
  id_ecriture_fond_travaux (bigint) 
  exclure_budget_reel (tinyint(1)) 
  statut (enum('pending','processed','validated','rejected','duplicate','cancelled')) MUL
  confiance_score (decimal(3,2)) 
  necessite_validation (tinyint(1)) 
  valide_par (int) 
  valide_le (datetime) 
  texte_ocr (text) 
  created_at (datetime) 
  updated_at (datetime) 
  created_by (int) 

=== TABLE: users ===
  id (int) PRI
  uuid (varchar(36)) 
  mail (varchar(255)) MUL
  role (enum('president','tresorier','secretaire')) 
  prenom (varchar(255)) 
  nom (varchar(255)) 
  compte_450 (varchar(20)) MUL
  societe (int) 
  achat (date) 
  parti (int) 
  copro (int) MUL
  admin (tinyint(1)) 
  secure_mail (tinyint(1)) 
  adresse (text) 
  code_postal (text) 
  ville (text) 
  token (text) 
  calendar_token (varchar(64)) UNI
  tel (varchar(25)) 
  password (varchar(255)) 
  verified (tinyint(1)) 
  verification_token (varchar(255)) 
  reset_token (varchar(255)) 
  reset_expiration (datetime) 
  last_login (datetime) 
  login_count (int) 
  gender (enum('Homme','Femme','Autre')) 
  created_at (timestamp) 
  last_co (timestamp) 
  bio (varchar(160)) 
  display_title (varchar(50)) 
  avatar_frame (varchar(30)) 
  company (varchar(100)) 
  syndicos_token (varchar(255)) 
  rentos_token (varchar(255)) 
  id_rentos (int) 
  invitation_token (varchar(64)) MUL
  invitation_sent_at (datetime) 
  invitation_used_at (datetime) 

=== TABLE: syndics ===
  id_copro (int) PRI
  id_gerant (int) 
  id_president (int) 
  nom (text) 
  adresse (text) 
  code_postal (text) 
  ville (varchar(255)) 
  immat (text) 
  valide (int) 
  type_syndic (enum('benevole','cooperatif')) 
  is_founder (tinyint(1)) 
  trial_ends (date) 
  creation (datetime) 
  total_tantiemes (int unsigned) 
  latitude (decimal(10,7)) 
  longitude (decimal(10,7)) 
  geocoded_at (datetime) 
  view_zoom (float) 
  view_pitch (float) 
  view_bearing (float) 
  position_manual (tinyint(1)) 

=== TABLE: lots ===
  id (int) PRI
  numero (varchar(20)) 
  denomination (varchar(150)) 
  user (int) 
  tantieme (decimal(11,2)) 
  etage (int) 
  copro (int) MUL
  eau (int) 
  elec (int) 
  habitation (tinyint(1)) 
  location (int) 
  lot_attached (int) 
  vendu (int) 
  date_vente (date) 
  vendu_a (text) 
  type (int) 
  superficie (decimal(11,2)) 
  id_batiment (int) 

=== TABLE: plan_comptable ===
  id (int) PRI
  numero_compte (varchar(20)) MUL
  libelle (varchar(255)) 
  type_compte (enum('actif','passif','charge','produit','tiers')) 
  id_copro (int) MUL
  id_entite (int) 
  type_entite (enum('fournisseur','coproprietaire','banque','autre')) MUL
  actif (tinyint(1)) 
  date_creation (timestamp) 
  date_modification (timestamp) 
  classe (varchar(10)) 

=== TABLE: ecritures ===
  TABLE NOT FOUND

=== TABLE: journaux ===
  TABLE NOT FOUND