{
  "user_version": 88,
  "tables": {
    "assurance_pro": [
      {
        "name": "id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 1
      },
      {
        "name": "server_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "sync_status",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'local_only'",
        "pk": 0
      },
      {
        "name": "updated_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "deleted_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "diagnostiqueur_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "compagnie",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "numero_contrat",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "date_debut",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "date_fin",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "montant_garantie",
        "type": "REAL",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      }
    ],
    "audit_log": [
      {
        "name": "id",
        "type": "INTEGER",
        "notnull": 0,
        "dflt": null,
        "pk": 1
      },
      {
        "name": "entity",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "entity_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "mission_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "field",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "old_value",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "new_value",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "timestamp",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      }
    ],
    "audit_logs": [
      {
        "name": "id",
        "type": "INTEGER",
        "notnull": 0,
        "dflt": null,
        "pk": 1
      },
      {
        "name": "entity_type",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "entity_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "action",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "old_value",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "new_value",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "created_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      }
    ],
    "biens": [
      {
        "name": "id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 1
      },
      {
        "name": "server_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "sync_status",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'local_only'",
        "pk": 0
      },
      {
        "name": "updated_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "deleted_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "client_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "type_bien",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'Appartement'",
        "pk": 0
      },
      {
        "name": "adresse_numero",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "adresse_rue",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "code_postal",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "ville",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "pays",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'France'",
        "pk": 0
      },
      {
        "name": "annee_construction",
        "type": "INTEGER",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "surface_habitable",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "surface_totale",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "nb_pieces",
        "type": "INTEGER",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "nb_etages",
        "type": "INTEGER",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "type_chauffage",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "energie_chauffage",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "reference_cadastrale",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "numero_lot",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "photos",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'[]'",
        "pk": 0
      },
      {
        "name": "documents",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'[]'",
        "pk": 0
      },
      {
        "name": "numero_module",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "numero_groupe",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "niveau",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "numero_porte",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "type_ecs",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "energie_ecs",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "nommage_fichier",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "section_cadastrale",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "nom_residence",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "latitude",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "longitude",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "bdnb_data",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "bdnb_updated_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "nom_groupe",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "adresse_groupe",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "code_batiment",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "nom_batiment",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "code_entree",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "type_logement",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "last_imported_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "last_manual_edit_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "import_orphaned_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "typologie",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "invariant_fiscal",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "nom_locataire",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "tel_locataire",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "email_locataire",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "nom_gardien",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "tel_gardien",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "adresse_loge_gardien",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "owner_siret",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      }
    ],
    "certifications": [
      {
        "name": "id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 1
      },
      {
        "name": "server_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "sync_status",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'local_only'",
        "pk": 0
      },
      {
        "name": "updated_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "deleted_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "diagnostiqueur_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "type",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "numero_certificat",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "organisme",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "date_obtention",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "date_expiration",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "photo_uri",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "departements",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'[]'",
        "pk": 0
      },
      {
        "name": "alerte_60j",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      }
    ],
    "clients": [
      {
        "name": "id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 1
      },
      {
        "name": "server_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "sync_status",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'local_only'",
        "pk": 0
      },
      {
        "name": "updated_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "deleted_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "type_client",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'Particulier'",
        "pk": 0
      },
      {
        "name": "civilite",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "nom",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "prenom",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "raison_sociale",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "siret",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "adresse_facturation_numero",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "adresse_facturation_rue",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "code_postal",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "ville",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "pays",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'France'",
        "pk": 0
      },
      {
        "name": "telephones",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'[]'",
        "pk": 0
      },
      {
        "name": "emails",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'[]'",
        "pk": 0
      },
      {
        "name": "notes",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "statut",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'Actif'",
        "pk": 0
      },
      {
        "name": "nommage_rapport",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "nommage_rapports",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'{}'",
        "pk": 0
      },
      {
        "name": "tarifs_client",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'[]'",
        "pk": 0
      },
      {
        "name": "initiales",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      }
    ],
    "comptages_menuiseries_dpeic": [
      {
        "name": "id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 1
      },
      {
        "name": "immeuble_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "menuiserie_type_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "paroi_type_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "orientation",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "nb",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      }
    ],
    "croquis": [
      {
        "name": "id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 1
      },
      {
        "name": "mission_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "bien_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "titre",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "image_fond_uri",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "modele_3d_uri",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "server_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "sync_status",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "'pending_sync'",
        "pk": 0
      },
      {
        "name": "created_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "updated_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "deleted_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "pixels_per_meter",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      }
    ],
    "croquis_annotations": [
      {
        "name": "id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 1
      },
      {
        "name": "croquis_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "diag_type",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "type_element",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "donnees_json",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "element_reference_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "server_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "sync_status",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "'pending_sync'",
        "pk": 0
      },
      {
        "name": "created_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "updated_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "deleted_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      }
    ],
    "custom_amiante_presets": [
      {
        "name": "id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 1
      },
      {
        "name": "nom_zpso",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "materiau_suspect",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "caracteristiques",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      }
    ],
    "diag_amiante": [
      {
        "name": "id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 1
      },
      {
        "name": "server_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "sync_status",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'pending_sync'",
        "pk": 0
      },
      {
        "name": "created_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "updated_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "deleted_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "mission_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "bien_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "type_mission",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'RAAT'",
        "pk": 0
      },
      {
        "name": "laboratoire",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "demandeur",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "nature_travaux",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "notes_generales",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "date_visite",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "is_finished",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "rapports_labo_pdf",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "'[]'",
        "pk": 0
      }
    ],
    "diag_crep": [
      {
        "name": "id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 1
      },
      {
        "name": "server_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "sync_status",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'pending_sync'",
        "pk": 0
      },
      {
        "name": "updated_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "deleted_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "created_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "mission_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "bien_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "type_mission",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'CREP'",
        "pk": 0
      },
      {
        "name": "uds_json",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'[]'",
        "pk": 0
      },
      {
        "name": "notes_generales",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "date_visite",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "is_finished",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "etalonnage_entree_json",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'{}'",
        "pk": 0
      },
      {
        "name": "etalonnage_sortie_json",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'{}'",
        "pk": 0
      },
      {
        "name": "uds_trash_json",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'[]'",
        "pk": 0
      }
    ],
    "diag_dpe": [
      {
        "name": "id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 1
      },
      {
        "name": "server_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "sync_status",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'pending_sync'",
        "pk": 0
      },
      {
        "name": "created_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "updated_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "deleted_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "mission_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "bien_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "type_dpe",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'existant'",
        "pk": 0
      },
      {
        "name": "type_bien",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'maison'",
        "pk": 0
      },
      {
        "name": "annee_construction",
        "type": "INTEGER",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "surface_reference_m2",
        "type": "REAL",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "hauteur_sous_plafond_m",
        "type": "REAL",
        "notnull": 1,
        "dflt": "2.5",
        "pk": 0
      },
      {
        "name": "nombre_niveaux",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "1",
        "pk": 0
      },
      {
        "name": "nombre_niveaux_batiment",
        "type": "INTEGER",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "surface_batiment_m2",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "nb_logements_batiment",
        "type": "INTEGER",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "surface_habitable_immeuble",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "nombre_appartement",
        "type": "INTEGER",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "position_dans_batiment",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "departement",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "altitude_m",
        "type": "REAL",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "zone_climatique",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "photo_bien_uri",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "ventilation_json",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'{}'",
        "pk": 0
      },
      {
        "name": "confort_ete",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "inertie",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "plusieurs_facade_exposee",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "1",
        "pk": 0
      },
      {
        "name": "cep_m2_an",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "cef_m2_an",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "eges_m2_an",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "classe_energie",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "classe_ges",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "classe_dpe",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "cout_annuel_min",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "cout_annuel_max",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "deperditions_json",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'{}'",
        "pk": 0
      },
      {
        "name": "resultats_json",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'{}'",
        "pk": 0
      },
      {
        "name": "date_visite",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "is_finished",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "notes_generales",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      }
    ],
    "diag_electricite": [
      {
        "name": "id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 1
      },
      {
        "name": "server_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "sync_status",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'pending_sync'",
        "pk": 0
      },
      {
        "name": "created_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "updated_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "deleted_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "mission_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "bien_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "points_controle",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'[]'",
        "pk": 0
      },
      {
        "name": "notes_generales",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "date_visite",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "is_finished",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "numero_compteur",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "photo_compteur",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "numero_pdl",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "installation_alimentee",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "1",
        "pk": 0
      },
      {
        "name": "titulaire_nom",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "titulaire_prenom",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "titulaire_adresse",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "titulaire_cp",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "titulaire_ville",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "photo_compteur_pres",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      }
    ],
    "diag_gaz": [
      {
        "name": "id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 1
      },
      {
        "name": "server_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "sync_status",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'pending_sync'",
        "pk": 0
      },
      {
        "name": "created_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "updated_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "deleted_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "mission_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "bien_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "points_controle",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'[]'",
        "pk": 0
      },
      {
        "name": "notes_generales",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "date_visite",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "is_finished",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "numero_compteur",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "photo_compteur",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "numero_pce",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "numero_point_livraison",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "titulaire_nom",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "titulaire_prenom",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "titulaire_adresse",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "titulaire_cp",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "titulaire_ville",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "photo_compteur_pres",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "type_gaz",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "type_batiment",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "gpl_recipient",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "gpl_distributeur",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "gpl_numero_livraison",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      }
    ],
    "diag_gaz_appareils": [
      {
        "name": "id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 1
      },
      {
        "name": "server_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "sync_status",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'pending_sync'",
        "pk": 0
      },
      {
        "name": "created_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "updated_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "deleted_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "diag_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "type_appareil",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "marque",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "modele",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "description",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "localisation_piece_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "photos",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'[]'",
        "pk": 0
      },
      {
        "name": "controles_json",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'[]'",
        "pk": 0
      }
    ],
    "diag_hap": [
      {
        "name": "id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 1
      },
      {
        "name": "server_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "sync_status",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'local_only'",
        "pk": 0
      },
      {
        "name": "updated_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "deleted_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "mission_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "bien_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "norme_reference",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "'NF X 46-102'",
        "pk": 0
      },
      {
        "name": "date_commande",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "date_visite",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "heure_arrivee",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "duree_reperage",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "accompagnateur",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "'Sans accompagnateur'",
        "pk": 0
      },
      {
        "name": "perimetre_reperage",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "objet_mission",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "labo_nom",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "labo_adresse",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "labo_accreditation",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "doc_rapports_amiante",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "'Non'",
        "pk": 0
      },
      {
        "name": "doc_ouvrages",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "'Non'",
        "pk": 0
      },
      {
        "name": "doc_acces_zones",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "'Non'",
        "pk": 0
      },
      {
        "name": "doc_observations",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "'Néant'",
        "pk": 0
      },
      {
        "name": "plan_prevention",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "'Oui'",
        "pk": 0
      },
      {
        "name": "conclusion_globale",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "notes_generales",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "carottes_json",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'[]'",
        "pk": 0
      },
      {
        "name": "hap_map_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "is_finished",
        "type": "INTEGER",
        "notnull": 0,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "created_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      }
    ],
    "diag_lidar": [
      {
        "name": "id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 1
      },
      {
        "name": "server_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "sync_status",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'pending_sync'",
        "pk": 0
      },
      {
        "name": "created_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "updated_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "deleted_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "mission_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "bien_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "date_visite",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "is_finished",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "surface_totale_sol",
        "type": "REAL",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "surface_totale_habitable",
        "type": "REAL",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "surface_totale_murs",
        "type": "REAL",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "volume_total",
        "type": "REAL",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "nb_pieces_scannees",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "notes_generales",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "export_json",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      }
    ],
    "diagnostiqueur": [
      {
        "name": "id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 1
      },
      {
        "name": "server_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "sync_status",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'local_only'",
        "pk": 0
      },
      {
        "name": "updated_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "deleted_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "civilite",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'M.'",
        "pk": 0
      },
      {
        "name": "nom",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "prenom",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "raison_sociale",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "forme_juridique",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'EI'",
        "pk": 0
      },
      {
        "name": "siret",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "code_ape",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "tva_intracommunautaire",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "rib",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "iban",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "bic",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "logo_uri",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "signature_uri",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "adresse_numero",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "adresse_rue",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "code_postal",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "ville",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "pays",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'France'",
        "pk": 0
      },
      {
        "name": "telephone_fixe",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "telephone_mobile",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "email",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "site_web",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "conditions_paiement",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "mentions_legales",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "pied_de_page",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "numero_depart_factures",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "1",
        "pk": 0
      },
      {
        "name": "numero_depart_devis",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "1",
        "pk": 0
      },
      {
        "name": "prefixe_numerotation",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'DIAG'",
        "pk": 0
      },
      {
        "name": "certifications_json",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'[]'",
        "pk": 0
      },
      {
        "name": "assurance_json",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "appareil_xrf_json",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'{}'",
        "pk": 0
      },
      {
        "name": "smtp_host",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "smtp_port",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "587",
        "pk": 0
      },
      {
        "name": "smtp_secure",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'tls'",
        "pk": 0
      },
      {
        "name": "smtp_email",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "smtp_password",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "smtp_from_name",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "smtp_enabled",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "email_templates_json",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'{}'",
        "pk": 0
      }
    ],
    "documents_generes": [
      {
        "name": "id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 1
      },
      {
        "name": "server_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "sync_status",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'local_only'",
        "pk": 0
      },
      {
        "name": "updated_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "deleted_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "mission_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "bien_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "type_document",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "label",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "file_uri",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "file_size",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "format",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'pdf'",
        "pk": 0
      },
      {
        "name": "created_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      }
    ],
    "dpe_baies": [
      {
        "name": "id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 1
      },
      {
        "name": "server_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "sync_status",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'pending_sync'",
        "pk": 0
      },
      {
        "name": "created_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "updated_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "deleted_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "diag_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "nom",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "type_baie",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'fenetre'",
        "pk": 0
      },
      {
        "name": "inclinaison",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'verticale'",
        "pk": 0
      },
      {
        "name": "materiau",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'pvc'",
        "pk": 0
      },
      {
        "name": "type_ouverture",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'battante'",
        "pk": 0
      },
      {
        "name": "type_vitrage",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'double'",
        "pk": 0
      },
      {
        "name": "remplissage",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'air'",
        "pk": 0
      },
      {
        "name": "epaisseur_lame_mm",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "type_volet",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'sans_volet'",
        "pk": 0
      },
      {
        "name": "orientation",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'sud'",
        "pk": 0
      },
      {
        "name": "surface_m2",
        "type": "REAL",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "nombre",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "1",
        "pk": 0
      },
      {
        "name": "uw_saisi",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "ug_calcule",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "uw_calcule",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "ujn_calcule",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "sw",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "masque_proche",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "masque_lointain",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "source_lidar",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "mur_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      }
    ],
    "dpe_chauffages": [
      {
        "name": "id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 1
      },
      {
        "name": "server_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "sync_status",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'pending_sync'",
        "pk": 0
      },
      {
        "name": "created_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "updated_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "deleted_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "diag_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "nom",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "type_installation",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'individuel'",
        "pk": 0
      },
      {
        "name": "type_generateur",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "marque",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "modele",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "puissance_kw",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "annee_installation",
        "type": "INTEGER",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "type_emetteur",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'radiateurs_eau'",
        "pk": 0
      },
      {
        "name": "type_regulation",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'sans'",
        "pk": 0
      },
      {
        "name": "type_distribution",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'pas_reseau'",
        "pk": 0
      },
      {
        "name": "part_chauffage_pct",
        "type": "REAL",
        "notnull": 1,
        "dflt": "100",
        "pk": 0
      },
      {
        "name": "rendement_generation",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "rendement_emission",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "rendement_distribution",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "rendement_regulation",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "priorite",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "1",
        "pk": 0
      },
      {
        "name": "ademe_gen_ch_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "ademe_energie_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "ademe_emetteur_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "identifiant_reseau_chaleur",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "date_arrete_reseau_chaleur",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "ratio_virtualisation",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      }
    ],
    "dpe_climatisations": [
      {
        "name": "id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 1
      },
      {
        "name": "server_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "sync_status",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'pending_sync'",
        "pk": 0
      },
      {
        "name": "created_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "updated_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "deleted_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "diag_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "type_installation",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'individuel'",
        "pk": 0
      },
      {
        "name": "type_systeme",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "annee_installation",
        "type": "INTEGER",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "seer",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      }
    ],
    "dpe_ecs": [
      {
        "name": "id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 1
      },
      {
        "name": "server_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "sync_status",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'pending_sync'",
        "pk": 0
      },
      {
        "name": "created_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "updated_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "deleted_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "diag_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "nom",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "type_installation",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'individuel'",
        "pk": 0
      },
      {
        "name": "type_ecs",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "energie",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'electrique'",
        "pk": 0
      },
      {
        "name": "volume_ballon_litres",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "annee_installation",
        "type": "INTEGER",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "distribution",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'non_bouclee'",
        "pk": 0
      },
      {
        "name": "rendement_generation",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "rendement_distribution",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "rendement_stockage",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "ademe_gen_ecs_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "ademe_energie_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      }
    ],
    "dpe_murs": [
      {
        "name": "id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 1
      },
      {
        "name": "server_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "sync_status",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'pending_sync'",
        "pk": 0
      },
      {
        "name": "created_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "updated_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "deleted_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "diag_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "nom",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "type_mur",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'inconnu'",
        "pk": 0
      },
      {
        "name": "epaisseur_cm",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "orientations",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'[]'",
        "pk": 0
      },
      {
        "name": "donne_sur",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'exterieur'",
        "pk": 0
      },
      {
        "name": "surface_m2",
        "type": "REAL",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "surface_deductible_m2",
        "type": "REAL",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "etat_isolation",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'inconnu'",
        "pk": 0
      },
      {
        "name": "position_isolation",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "epaisseur_isolant_cm",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "resistance_isolant",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "annee_isolation",
        "type": "INTEGER",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "u_saisi",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "u_calcule",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "coefficient_b",
        "type": "REAL",
        "notnull": 1,
        "dflt": "1",
        "pk": 0
      },
      {
        "name": "doublage",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "source_lidar",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      }
    ],
    "dpe_plafonds": [
      {
        "name": "id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 1
      },
      {
        "name": "server_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "sync_status",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'pending_sync'",
        "pk": 0
      },
      {
        "name": "created_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "updated_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "deleted_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "diag_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "nom",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "type_plafond",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'inconnu'",
        "pk": 0
      },
      {
        "name": "donne_sur",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'exterieur'",
        "pk": 0
      },
      {
        "name": "surface_m2",
        "type": "REAL",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "etat_isolation",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'inconnu'",
        "pk": 0
      },
      {
        "name": "position_isolation",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "epaisseur_isolant_cm",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "resistance_isolant",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "annee_isolation",
        "type": "INTEGER",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "u_saisi",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "u_calcule",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "coefficient_b",
        "type": "REAL",
        "notnull": 1,
        "dflt": "1",
        "pk": 0
      },
      {
        "name": "source_lidar",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      }
    ],
    "dpe_planchers": [
      {
        "name": "id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 1
      },
      {
        "name": "server_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "sync_status",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'pending_sync'",
        "pk": 0
      },
      {
        "name": "created_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "updated_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "deleted_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "diag_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "nom",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "type_plancher",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'inconnu'",
        "pk": 0
      },
      {
        "name": "donne_sur",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'terre_plein'",
        "pk": 0
      },
      {
        "name": "surface_m2",
        "type": "REAL",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "perimetre_m",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "etat_isolation",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'inconnu'",
        "pk": 0
      },
      {
        "name": "position_isolation",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "epaisseur_isolant_cm",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "resistance_isolant",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "annee_isolation",
        "type": "INTEGER",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "u_saisi",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "u_calcule",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "coefficient_b",
        "type": "REAL",
        "notnull": 1,
        "dflt": "1",
        "pk": 0
      },
      {
        "name": "source_lidar",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      }
    ],
    "dpe_ponts_thermiques": [
      {
        "name": "id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 1
      },
      {
        "name": "server_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "sync_status",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'pending_sync'",
        "pk": 0
      },
      {
        "name": "updated_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "deleted_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "created_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "diag_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "type_jonction",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "lineaire_m",
        "type": "REAL",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "position_isolation",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'sans_isolation'",
        "pk": 0
      },
      {
        "name": "psi",
        "type": "REAL",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "coefficient_b",
        "type": "REAL",
        "notnull": 1,
        "dflt": "1.0",
        "pk": 0
      },
      {
        "name": "source",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'manuel'",
        "pk": 0
      },
      {
        "name": "reference_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "nom",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      }
    ],
    "dpe_portes": [
      {
        "name": "id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 1
      },
      {
        "name": "server_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "sync_status",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'pending_sync'",
        "pk": 0
      },
      {
        "name": "created_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "updated_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "deleted_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "diag_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "nom",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "type_porte",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'opaque_pleine'",
        "pk": 0
      },
      {
        "name": "materiau",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'bois'",
        "pk": 0
      },
      {
        "name": "donne_sur",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'exterieur'",
        "pk": 0
      },
      {
        "name": "surface_m2",
        "type": "REAL",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "nombre",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "1",
        "pk": 0
      },
      {
        "name": "u_saisi",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "u_calcule",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "coefficient_b",
        "type": "REAL",
        "notnull": 1,
        "dflt": "1",
        "pk": 0
      },
      {
        "name": "source_lidar",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "mur_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "orientation",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'sud'",
        "pk": 0
      }
    ],
    "dpe_productions_enr": [
      {
        "name": "id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 1
      },
      {
        "name": "server_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "sync_status",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'pending_sync'",
        "pk": 0
      },
      {
        "name": "created_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "updated_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "deleted_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "diag_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "type_production",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'photovoltaique'",
        "pk": 0
      },
      {
        "name": "surface_capteurs_m2",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "production_kwh_an",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      }
    ],
    "dpe_ventilations": [
      {
        "name": "id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 1
      },
      {
        "name": "server_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "sync_status",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'pending_sync'",
        "pk": 0
      },
      {
        "name": "created_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "updated_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "deleted_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "diag_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "type_ventilation",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'ventilation_naturelle_conduits'",
        "pk": 0
      },
      {
        "name": "annee_installation",
        "type": "INTEGER",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "debit_m3_h_m2",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "rendement_echangeur",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      }
    ],
    "floor_plans": [
      {
        "name": "id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 1
      },
      {
        "name": "property_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "diagnostic_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "floor",
        "type": "INTEGER",
        "notnull": 0,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "floor_label",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "'RDC'",
        "pk": 0
      },
      {
        "name": "data",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "total_area",
        "type": "REAL",
        "notnull": 0,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "room_count",
        "type": "INTEGER",
        "notnull": 0,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "created_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "updated_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "synced",
        "type": "INTEGER",
        "notnull": 0,
        "dflt": "0",
        "pk": 0
      }
    ],
    "immeubles_dpeic": [
      {
        "name": "id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 1
      },
      {
        "name": "server_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "sync_status",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "updated_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "deleted_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "mission_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "bien_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "adresse",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "annee_construction",
        "type": "INTEGER",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "surface_totale",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "nb_logements",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "nb_niveaux",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "hauteur_sous_plafond",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "types_planchers_bas",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'[]'",
        "pk": 0
      },
      {
        "name": "types_planchers_hauts",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'[]'",
        "pk": 0
      },
      {
        "name": "gestion_homogene",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "notes",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "created_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "niveau_min",
        "type": "INTEGER",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "niveau_max",
        "type": "INTEGER",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "groupe_code",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "groupe_nom",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "groupe_adresse",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "batiment_code",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "batiment_nom",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      }
    ],
    "logements_dpeic": [
      {
        "name": "id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 1
      },
      {
        "name": "server_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "sync_status",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "updated_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "deleted_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "immeuble_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "numero_lot",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "numero_porte",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "etage",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "typologie",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "surface",
        "type": "REAL",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "position",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "plancher_bas",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "plancher_haut",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "a_visiter",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "visite",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "rattache_a_visite_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "ordre",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "niveau_numerique",
        "type": "INTEGER",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "position_etage_override",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "invariant_fiscal",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      }
    ],
    "memo_normes": [
      {
        "name": "id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 1
      },
      {
        "name": "server_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "sync_status",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'local_only'",
        "pk": 0
      },
      {
        "name": "created_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "updated_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "deleted_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "categorie",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "titre",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "uri",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "mime_type",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'application/pdf'",
        "pk": 0
      },
      {
        "name": "file_size",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      }
    ],
    "menuiseries_types_dpeic": [
      {
        "name": "id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 1
      },
      {
        "name": "server_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "sync_status",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "updated_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "deleted_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "immeuble_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "code",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "nature",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "largeur",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "hauteur",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "materiau",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "type_vitrage",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "epaisseur_lame",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "gaz_lame",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "type_fermeture",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "a_battant",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "photo_uri",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "notes",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "mode_ouverture",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "vir",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "dormant_sup_20mm",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "materiau_volet",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "pose",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      }
    ],
    "metre_doors": [
      {
        "name": "id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 1
      },
      {
        "name": "server_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "sync_status",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'local_only'",
        "pk": 0
      },
      {
        "name": "updated_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "deleted_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "niveau_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "piece_a_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "piece_a_wall_idx",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "position_along_wall",
        "type": "REAL",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "width",
        "type": "REAL",
        "notnull": 1,
        "dflt": "0.9",
        "pk": 0
      },
      {
        "name": "height",
        "type": "REAL",
        "notnull": 1,
        "dflt": "2.1",
        "pk": 0
      },
      {
        "name": "sill",
        "type": "REAL",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "type",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'porte'",
        "pk": 0
      },
      {
        "name": "sens",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "piece_b_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "state",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'exterior'",
        "pk": 0
      },
      {
        "name": "proposed_name",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      }
    ],
    "metre_niveaux": [
      {
        "name": "id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 1
      },
      {
        "name": "server_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "sync_status",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'local_only'",
        "pk": 0
      },
      {
        "name": "updated_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "deleted_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "bien_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "nom",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "altitude_m",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "ordre",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "hauteur_sous_plafond_default",
        "type": "REAL",
        "notnull": 1,
        "dflt": "2.5",
        "pk": 0
      }
    ],
    "metre_pieces": [
      {
        "name": "id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 1
      },
      {
        "name": "server_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "sync_status",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'local_only'",
        "pk": 0
      },
      {
        "name": "updated_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "deleted_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "niveau_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "nom",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "type",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "vertices_json",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'[]'",
        "pk": 0
      },
      {
        "name": "hauteur_sous_plafond",
        "type": "REAL",
        "notnull": 1,
        "dflt": "2.5",
        "pk": 0
      },
      {
        "name": "origin_door_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "closed",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "surface_sol",
        "type": "REAL",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "perimetre",
        "type": "REAL",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "ordre_saisie",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      }
    ],
    "missions": [
      {
        "name": "id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 1
      },
      {
        "name": "server_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "sync_status",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "updated_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "deleted_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "client_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "reference",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "statut",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'Brouillon'",
        "pk": 0
      },
      {
        "name": "date_rdv",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "heure_rdv",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "duree_estimee",
        "type": "INTEGER",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "biens",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'[]'",
        "pk": 0
      },
      {
        "name": "prix_ht_total",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "tva",
        "type": "REAL",
        "notnull": 1,
        "dflt": "20",
        "pk": 0
      },
      {
        "name": "notes",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "donneur_ordre",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "diagnostiqueur_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "timer_start",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "NULL",
        "pk": 0
      },
      {
        "name": "timer_elapsed_seconds",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "signature_client_uri",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "NULL",
        "pk": 0
      },
      {
        "name": "numero_bon_commande",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "date_visite",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "owner_device_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "owner_device_name",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "transferred_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      }
    ],
    "parois_types_dpeic": [
      {
        "name": "id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 1
      },
      {
        "name": "server_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "sync_status",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "updated_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "deleted_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "immeuble_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "code",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "type_paroi",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "orientation",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "adjacent_a",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "coefficient_b",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "longueur",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "hauteur",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "surface_brute",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "composition",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "isolation",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "epaisseur_isolant",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "photo_uri",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "notes",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "doublage_sup_15mm",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "coefficient_b_override",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "aiu",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "aue",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "aiu_mesures",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'[]'",
        "pk": 0
      },
      {
        "name": "aue_mesures",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'[]'",
        "pk": 0
      },
      {
        "name": "isole_lnc",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "logements_lies_ids",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'[]'",
        "pk": 0
      },
      {
        "name": "applique_5pct_cloisons",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "1",
        "pk": 0
      },
      {
        "name": "aiu_isolee",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "aue_isolee",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "type_mur_arrete",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "type_plancher_bas_arrete",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "type_plafond_arrete",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "adjacent_arrete",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "surfaces_mesures",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'[]'",
        "pk": 0
      }
    ],
    "piece_photos": [
      {
        "name": "id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 1
      },
      {
        "name": "server_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "sync_status",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'pending_sync'",
        "pk": 0
      },
      {
        "name": "created_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "updated_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "deleted_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "piece_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "mission_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "bien_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "uri",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "latitude",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "longitude",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "note",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      }
    ],
    "plan_assemblies": [
      {
        "name": "id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 1
      },
      {
        "name": "server_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "sync_status",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'pending_sync'",
        "pk": 0
      },
      {
        "name": "updated_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "deleted_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "mission_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "bien_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "placements_json",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'[]'",
        "pk": 0
      },
      {
        "name": "viewport_json",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'{}'",
        "pk": 0
      }
    ],
    "ponts_thermiques_dpeic": [
      {
        "name": "id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 1
      },
      {
        "name": "server_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "sync_status",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "updated_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "deleted_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "immeuble_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "type_pont",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "longueur",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "psi",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "calcul_auto",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "1",
        "pk": 0
      },
      {
        "name": "notes",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "type_pont_arrete",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      }
    ],
    "prelevement_amiante": [
      {
        "name": "id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 1
      },
      {
        "name": "server_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "sync_status",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'pending_sync'",
        "pk": 0
      },
      {
        "name": "created_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "updated_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "deleted_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "diag_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "zpso_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "piece_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "numero_echantillon",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "localisation",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "composant",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "nature_materiau",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "etat_conservation",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "accessibilite",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "resultat_labo",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "'En attente'",
        "pk": 0
      },
      {
        "name": "photos",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'[]'",
        "pk": 0
      }
    ],
    "releves_logements_dpeic": [
      {
        "name": "id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 1
      },
      {
        "name": "server_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "sync_status",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "updated_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "deleted_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "logement_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "date_visite",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "menuiseries_placees",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'[]'",
        "pk": 0
      },
      {
        "name": "chauffage",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'{}'",
        "pk": 0
      },
      {
        "name": "ecs",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'{}'",
        "pk": 0
      },
      {
        "name": "ventilation",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'{}'",
        "pk": 0
      },
      {
        "name": "refroidissement",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'{}'",
        "pk": 0
      },
      {
        "name": "photos",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'[]'",
        "pk": 0
      },
      {
        "name": "conformite_syndic",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'non-applicable'",
        "pk": 0
      },
      {
        "name": "notes",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "confirmations_parois",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'{}'",
        "pk": 0
      },
      {
        "name": "confirmation_plancher_bas",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "confirmation_plancher_haut",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      }
    ],
    "releves_surfaces": [
      {
        "name": "id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 1
      },
      {
        "name": "server_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "sync_status",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "updated_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "deleted_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "mission_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "bien_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "nom",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "methode",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'simple'",
        "pk": 0
      },
      {
        "name": "forme_simple",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "longueur",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "largeur",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "base",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "hauteur",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "points_triangulation",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "surface_brute",
        "type": "REAL",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "mode_calcul",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'ajouter'",
        "pk": 0
      },
      {
        "name": "retranchement",
        "type": "REAL",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "surface_nette",
        "type": "REAL",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "inclure_habitable",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "1",
        "pk": 0
      },
      {
        "name": "inclure_carrez",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "1",
        "pk": 0
      },
      {
        "name": "inclure_reference",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "1",
        "pk": 0
      },
      {
        "name": "inclure_au_sol",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "1",
        "pk": 0
      },
      {
        "name": "descriptif_json",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "notes",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "description",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "niveau",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "non_visite",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "motif_non_visite",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "parties_json",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "hauteur_sous_plafond",
        "type": "REAL",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "rampant_zones_json",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      }
    ],
    "scans_lidar_pieces": [
      {
        "name": "id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 1
      },
      {
        "name": "server_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "sync_status",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'pending_sync'",
        "pk": 0
      },
      {
        "name": "created_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "updated_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "deleted_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "diag_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "mission_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "bien_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "nom_piece",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "niveau",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "surface_sol",
        "type": "REAL",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "hauteur_sous_plafond",
        "type": "REAL",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "perimetre",
        "type": "REAL",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "volume",
        "type": "REAL",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "murs_json",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'[]'",
        "pk": 0
      },
      {
        "name": "ouvertures_json",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'[]'",
        "pk": 0
      },
      {
        "name": "surface_murs_brute",
        "type": "REAL",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "surface_murs_nette",
        "type": "REAL",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "surface_vitree",
        "type": "REAL",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "notes",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "statut",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'brouillon'",
        "pk": 0
      },
      {
        "name": "scan_duration_seconds",
        "type": "REAL",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      }
    ],
    "surface_scans": [
      {
        "name": "id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 1
      },
      {
        "name": "server_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "sync_status",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'local_only'",
        "pk": 0
      },
      {
        "name": "updated_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "deleted_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "mission_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "bien_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "piece_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "nom_piece",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "sol_total",
        "type": "REAL",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "carrez",
        "type": "REAL",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "boutin",
        "type": "REAL",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "floor_polygon_json",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'[]'",
        "pk": 0
      },
      {
        "name": "scan_duration",
        "type": "REAL",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "vertex_count",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "created_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "point_cloud_path",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "height_grid_json",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "ransac_json",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "manual_surfaces_json",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "raw_mesh_path",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      }
    ],
    "tarifs": [
      {
        "name": "id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 1
      },
      {
        "name": "server_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "sync_status",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'local_only'",
        "pk": 0
      },
      {
        "name": "updated_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "deleted_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "label",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "type_diagnostic",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "prix_ht",
        "type": "REAL",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "tva",
        "type": "REAL",
        "notnull": 1,
        "dflt": "20",
        "pk": 0
      },
      {
        "name": "prix_prelevement_ht",
        "type": "REAL",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      },
      {
        "name": "is_active",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "1",
        "pk": 0
      },
      {
        "name": "ordre",
        "type": "INTEGER",
        "notnull": 1,
        "dflt": "0",
        "pk": 0
      }
    ],
    "zpso_amiante": [
      {
        "name": "id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 1
      },
      {
        "name": "server_id",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "sync_status",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'pending_sync'",
        "pk": 0
      },
      {
        "name": "created_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "updated_at",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "deleted_at",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "diag_id",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "nom",
        "type": "TEXT",
        "notnull": 1,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "description",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "materiau",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "caracteristiques",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "pieces_concernees",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'[]'",
        "pk": 0
      },
      {
        "name": "statut_conservation",
        "type": "TEXT",
        "notnull": 0,
        "dflt": null,
        "pk": 0
      },
      {
        "name": "numero_zpso",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "photos",
        "type": "TEXT",
        "notnull": 1,
        "dflt": "'[]'",
        "pk": 0
      },
      {
        "name": "decision_amiante",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "justification_decision",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      },
      {
        "name": "resultat_evaluation",
        "type": "TEXT",
        "notnull": 0,
        "dflt": "''",
        "pk": 0
      }
    ]
  },
  "indexes": [
    {
      "name": "idx_audit_entity",
      "table": "audit_log",
      "sql": "CREATE INDEX idx_audit_entity ON audit_log(entity, entity_id)"
    },
    {
      "name": "idx_audit_mission",
      "table": "audit_log",
      "sql": "CREATE INDEX idx_audit_mission ON audit_log(mission_id)"
    },
    {
      "name": "idx_biens_batiment",
      "table": "biens",
      "sql": "CREATE INDEX idx_biens_batiment ON biens(client_id, numero_groupe, code_batiment)"
    },
    {
      "name": "idx_biens_client",
      "table": "biens",
      "sql": "CREATE INDEX idx_biens_client ON biens(client_id)"
    },
    {
      "name": "idx_biens_groupe",
      "table": "biens",
      "sql": "CREATE INDEX idx_biens_groupe ON biens(client_id, numero_groupe)"
    },
    {
      "name": "idx_biens_owner_siret",
      "table": "biens",
      "sql": "CREATE INDEX idx_biens_owner_siret ON biens(owner_siret)"
    },
    {
      "name": "idx_biens_sync",
      "table": "biens",
      "sql": "CREATE INDEX idx_biens_sync ON biens(sync_status)"
    },
    {
      "name": "idx_biens_upsert_key",
      "table": "biens",
      "sql": "CREATE INDEX idx_biens_upsert_key ON biens(client_id, numero_groupe, numero_lot)"
    },
    {
      "name": "idx_clients_nom",
      "table": "clients",
      "sql": "CREATE INDEX idx_clients_nom ON clients(nom, prenom, raison_sociale)"
    },
    {
      "name": "idx_clients_statut",
      "table": "clients",
      "sql": "CREATE INDEX idx_clients_statut ON clients(statut)"
    },
    {
      "name": "idx_clients_sync",
      "table": "clients",
      "sql": "CREATE INDEX idx_clients_sync ON clients(sync_status)"
    },
    {
      "name": "idx_comptages_menuis_immeuble",
      "table": "comptages_menuiseries_dpeic",
      "sql": "CREATE INDEX idx_comptages_menuis_immeuble ON comptages_menuiseries_dpeic(immeuble_id)"
    },
    {
      "name": "idx_diag_amiante_bien",
      "table": "diag_amiante",
      "sql": "CREATE INDEX idx_diag_amiante_bien ON diag_amiante(bien_id)"
    },
    {
      "name": "idx_diag_amiante_mission",
      "table": "diag_amiante",
      "sql": "CREATE INDEX idx_diag_amiante_mission ON diag_amiante(mission_id)"
    },
    {
      "name": "idx_diag_crep_bien",
      "table": "diag_crep",
      "sql": "CREATE INDEX idx_diag_crep_bien ON diag_crep(bien_id)"
    },
    {
      "name": "idx_diag_crep_mission",
      "table": "diag_crep",
      "sql": "CREATE INDEX idx_diag_crep_mission ON diag_crep(mission_id)"
    },
    {
      "name": "idx_diag_dpe_bien",
      "table": "diag_dpe",
      "sql": "CREATE INDEX idx_diag_dpe_bien ON diag_dpe(bien_id)"
    },
    {
      "name": "idx_diag_dpe_mission",
      "table": "diag_dpe",
      "sql": "CREATE INDEX idx_diag_dpe_mission ON diag_dpe(mission_id)"
    },
    {
      "name": "idx_diag_elec_bien",
      "table": "diag_electricite",
      "sql": "CREATE INDEX idx_diag_elec_bien ON diag_electricite(bien_id)"
    },
    {
      "name": "idx_diag_elec_mission",
      "table": "diag_electricite",
      "sql": "CREATE INDEX idx_diag_elec_mission ON diag_electricite(mission_id)"
    },
    {
      "name": "idx_diag_gaz_app_diag_id",
      "table": "diag_gaz_appareils",
      "sql": "CREATE INDEX idx_diag_gaz_app_diag_id ON diag_gaz_appareils(diag_id)"
    },
    {
      "name": "idx_diag_gaz_bien",
      "table": "diag_gaz",
      "sql": "CREATE INDEX idx_diag_gaz_bien ON diag_gaz(bien_id)"
    },
    {
      "name": "idx_diag_gaz_mission",
      "table": "diag_gaz",
      "sql": "CREATE INDEX idx_diag_gaz_mission ON diag_gaz(mission_id)"
    },
    {
      "name": "idx_diag_hap_bien",
      "table": "diag_hap",
      "sql": "CREATE INDEX idx_diag_hap_bien ON diag_hap(bien_id)"
    },
    {
      "name": "idx_diag_hap_mission",
      "table": "diag_hap",
      "sql": "CREATE INDEX idx_diag_hap_mission ON diag_hap(mission_id)"
    },
    {
      "name": "idx_diag_lidar_bien",
      "table": "diag_lidar",
      "sql": "CREATE INDEX idx_diag_lidar_bien ON diag_lidar(bien_id)"
    },
    {
      "name": "idx_diag_lidar_mission",
      "table": "diag_lidar",
      "sql": "CREATE INDEX idx_diag_lidar_mission ON diag_lidar(mission_id)"
    },
    {
      "name": "idx_dpe_baies_diag",
      "table": "dpe_baies",
      "sql": "CREATE INDEX idx_dpe_baies_diag ON dpe_baies(diag_id)"
    },
    {
      "name": "idx_dpe_chauffages_diag",
      "table": "dpe_chauffages",
      "sql": "CREATE INDEX idx_dpe_chauffages_diag ON dpe_chauffages(diag_id)"
    },
    {
      "name": "idx_dpe_clim_diag",
      "table": "dpe_climatisations",
      "sql": "CREATE INDEX idx_dpe_clim_diag ON dpe_climatisations(diag_id)"
    },
    {
      "name": "idx_dpe_ecs_diag",
      "table": "dpe_ecs",
      "sql": "CREATE INDEX idx_dpe_ecs_diag ON dpe_ecs(diag_id)"
    },
    {
      "name": "idx_dpe_murs_diag",
      "table": "dpe_murs",
      "sql": "CREATE INDEX idx_dpe_murs_diag ON dpe_murs(diag_id)"
    },
    {
      "name": "idx_dpe_plafonds_diag",
      "table": "dpe_plafonds",
      "sql": "CREATE INDEX idx_dpe_plafonds_diag ON dpe_plafonds(diag_id)"
    },
    {
      "name": "idx_dpe_planchers_diag",
      "table": "dpe_planchers",
      "sql": "CREATE INDEX idx_dpe_planchers_diag ON dpe_planchers(diag_id)"
    },
    {
      "name": "idx_dpe_ponts_thermiques_diag",
      "table": "dpe_ponts_thermiques",
      "sql": "CREATE INDEX idx_dpe_ponts_thermiques_diag ON dpe_ponts_thermiques(diag_id)"
    },
    {
      "name": "idx_dpe_portes_diag",
      "table": "dpe_portes",
      "sql": "CREATE INDEX idx_dpe_portes_diag ON dpe_portes(diag_id)"
    },
    {
      "name": "idx_dpe_prod_enr_diag",
      "table": "dpe_productions_enr",
      "sql": "CREATE INDEX idx_dpe_prod_enr_diag ON dpe_productions_enr(diag_id)"
    },
    {
      "name": "idx_dpe_vent_diag",
      "table": "dpe_ventilations",
      "sql": "CREATE INDEX idx_dpe_vent_diag ON dpe_ventilations(diag_id)"
    },
    {
      "name": "idx_floor_plans_diagnostic",
      "table": "floor_plans",
      "sql": "CREATE INDEX idx_floor_plans_diagnostic ON floor_plans(diagnostic_id)"
    },
    {
      "name": "idx_floor_plans_property",
      "table": "floor_plans",
      "sql": "CREATE INDEX idx_floor_plans_property ON floor_plans(property_id)"
    },
    {
      "name": "idx_immeubles_dpeic_mission",
      "table": "immeubles_dpeic",
      "sql": "CREATE INDEX idx_immeubles_dpeic_mission ON immeubles_dpeic(mission_id)"
    },
    {
      "name": "idx_logements_dpeic_immeuble",
      "table": "logements_dpeic",
      "sql": "CREATE INDEX idx_logements_dpeic_immeuble ON logements_dpeic(immeuble_id)"
    },
    {
      "name": "idx_memo_normes_categorie",
      "table": "memo_normes",
      "sql": "CREATE INDEX idx_memo_normes_categorie ON memo_normes(categorie)"
    },
    {
      "name": "idx_menuis_types_dpeic_immeuble",
      "table": "menuiseries_types_dpeic",
      "sql": "CREATE INDEX idx_menuis_types_dpeic_immeuble ON menuiseries_types_dpeic(immeuble_id)"
    },
    {
      "name": "idx_metre_doors_niveau",
      "table": "metre_doors",
      "sql": "CREATE INDEX idx_metre_doors_niveau ON metre_doors(niveau_id)"
    },
    {
      "name": "idx_metre_doors_piece_a",
      "table": "metre_doors",
      "sql": "CREATE INDEX idx_metre_doors_piece_a ON metre_doors(piece_a_id)"
    },
    {
      "name": "idx_metre_niveaux_bien",
      "table": "metre_niveaux",
      "sql": "CREATE INDEX idx_metre_niveaux_bien ON metre_niveaux(bien_id)"
    },
    {
      "name": "idx_metre_pieces_niveau",
      "table": "metre_pieces",
      "sql": "CREATE INDEX idx_metre_pieces_niveau ON metre_pieces(niveau_id)"
    },
    {
      "name": "idx_missions_owner_device",
      "table": "missions",
      "sql": "CREATE INDEX idx_missions_owner_device ON missions(owner_device_id)"
    },
    {
      "name": "idx_parois_types_dpeic_immeuble",
      "table": "parois_types_dpeic",
      "sql": "CREATE INDEX idx_parois_types_dpeic_immeuble ON parois_types_dpeic(immeuble_id)"
    },
    {
      "name": "idx_piece_photos_piece",
      "table": "piece_photos",
      "sql": "CREATE INDEX idx_piece_photos_piece ON piece_photos(piece_id)"
    },
    {
      "name": "idx_plan_assembly_bien",
      "table": "plan_assemblies",
      "sql": "CREATE INDEX idx_plan_assembly_bien ON plan_assemblies(bien_id)"
    },
    {
      "name": "idx_ponts_thermiques_dpeic_immeuble",
      "table": "ponts_thermiques_dpeic",
      "sql": "CREATE INDEX idx_ponts_thermiques_dpeic_immeuble ON ponts_thermiques_dpeic(immeuble_id)"
    },
    {
      "name": "idx_prel_amiante_diag",
      "table": "prelevement_amiante",
      "sql": "CREATE INDEX idx_prel_amiante_diag ON prelevement_amiante(diag_id)"
    },
    {
      "name": "idx_prel_amiante_zpso",
      "table": "prelevement_amiante",
      "sql": "CREATE INDEX idx_prel_amiante_zpso ON prelevement_amiante(zpso_id)"
    },
    {
      "name": "idx_releves_log_dpeic_logement",
      "table": "releves_logements_dpeic",
      "sql": "CREATE INDEX idx_releves_log_dpeic_logement ON releves_logements_dpeic(logement_id)"
    },
    {
      "name": "idx_scans_lidar_diag",
      "table": "scans_lidar_pieces",
      "sql": "CREATE INDEX idx_scans_lidar_diag ON scans_lidar_pieces(diag_id)"
    },
    {
      "name": "idx_scans_lidar_mission",
      "table": "scans_lidar_pieces",
      "sql": "CREATE INDEX idx_scans_lidar_mission ON scans_lidar_pieces(mission_id)"
    },
    {
      "name": "idx_surface_scans_bien",
      "table": "surface_scans",
      "sql": "CREATE INDEX idx_surface_scans_bien ON surface_scans(bien_id)"
    },
    {
      "name": "idx_surface_scans_mission",
      "table": "surface_scans",
      "sql": "CREATE INDEX idx_surface_scans_mission ON surface_scans(mission_id)"
    },
    {
      "name": "idx_zpso_amiante_diag",
      "table": "zpso_amiante",
      "sql": "CREATE INDEX idx_zpso_amiante_diag ON zpso_amiante(diag_id)"
    }
  ]
}