{
  "contact_id": 9,
  "exported_at": "2026-10-22T09:31:21.706Z",
  "tables": {
    "contacts": [
      {
        "id": 9,
        "name": "Sara Evangelista",
        "email": "sara.evangelista@example.com",
        "phone": "+390001000009",
        "kind": "tenant",
        "household_size": 1,
        "ages": "27",
        "occupation": "Impiegata",
        "monthly_income_cents": 160000,
        "contract_type": "determinato",
        "move_in_date": "2026-11-01",
        "stay_months": 24,
        "pets": 0,
        "smoker": 0,
        "guarantor_or_deposit": "Garante: il padre",
        "budget_cents": 55000,
        "areas": "Cassino centro",
        "marketing_consent": 1,
        "birthday": "1999-01-30",
        "created_at": "2026-10-22 03:00:38",
        "address": "Via Sant'Angelo 22, Cassino",
        "requirements": null,
        "has_property_to_sell": null,
        "mortgage_approved": null,
        "first_name": "Sara",
        "last_name": "Evangelista"
      }
    ],
    "contact_roles": [
      {
        "contact_id": 9,
        "role": "tenant",
        "status": "active"
      }
    ],
    "properties": [],
    "activity_log": [
      {
        "id": 5,
        "kind": "whatsapp",
        "source": "tap",
        "contact_id": 9,
        "property_id": 2,
        "enquiry_id": 7,
        "actor": null,
        "created_at": "2026-10-18 05:00:38"
      }
    ],
    "appointments": [
      {
        "id": 4,
        "kind": "visit",
        "starts_at": "2026-10-19 15:30:00",
        "duration_min": 60,
        "contact_id": 9,
        "property_id": 2,
        "title": "",
        "notes": "",
        "created_at": "2026-10-22 03:00:38",
        "status": "done"
      },
      {
        "id": 13,
        "kind": "cleaning",
        "starts_at": "2026-10-26 07:00:00",
        "duration_min": 180,
        "contact_id": 9,
        "property_id": 2,
        "title": "Pulizia prima dell'ingresso",
        "notes": "Pulito Casa.",
        "created_at": "2026-10-22 03:00:38",
        "status": "scheduled"
      },
      {
        "id": 15,
        "kind": "check_in",
        "starts_at": "2026-10-27 15:00:00",
        "duration_min": 60,
        "contact_id": 9,
        "property_id": 2,
        "title": "Consegna chiavi",
        "notes": "",
        "created_at": "2026-10-22 03:00:38",
        "status": "scheduled"
      },
      {
        "id": 17,
        "kind": "visit",
        "starts_at": "2026-10-21 03:00:00",
        "duration_min": 60,
        "contact_id": 9,
        "property_id": 1,
        "title": "",
        "notes": "",
        "created_at": "2026-10-22 03:00:38",
        "status": "scheduled"
      }
    ],
    "messages": [
      {
        "id": 5,
        "channel": "whatsapp",
        "mailbox": "romina",
        "from_addr": "+390001000009",
        "from_name": "Sara Evangelista",
        "reply_to": null,
        "subject": null,
        "body_text": "Buongiorno! Confermo per giovedì alle 17. Posso portare anche mio padre? È lui il garante.",
        "r2_key": null,
        "contact_id": 9,
        "read_at": "2026-10-22 06:08:01",
        "received_at": "2026-10-22 02:30:38"
      }
    ],
    "enquiries": [
      {
        "id": 7,
        "contact_id": 9,
        "property_id": 2,
        "portal": "immobiliare",
        "message": "Posso visitare il bilocale sabato mattina?",
        "received_at": "2026-10-18 03:00:38",
        "status": "follow_up_due",
        "next_action_at": "2026-10-22 02:00:38",
        "draft_email": null,
        "email_sent_at": null,
        "draft_model_at": null,
        "draft_from_model": 0,
        "converted_at": null,
        "draft_at": null
      },
      {
        "id": 9,
        "contact_id": 9,
        "property_id": 8,
        "portal": "sito",
        "message": "L'attico è disponibile da novembre?",
        "received_at": "2026-10-02 03:00:38",
        "status": "closed",
        "next_action_at": null,
        "draft_email": "Gentile Sara, grazie per il suo interesse per l'attico in Viale dei Pini 30.",
        "email_sent_at": "2026-10-03 03:00:38",
        "draft_model_at": null,
        "draft_from_model": 0,
        "converted_at": null,
        "draft_at": null
      }
    ],
    "sent_emails": [
      {
        "id": 2,
        "contact_id": 9,
        "enquiry_id": 9,
        "to_addr": "sara.evangelista@example.com",
        "subject": "La sua richiesta su Viale dei Pini 30, Cassino",
        "body_text": "Gentile Sara, grazie per il suo interesse per l'attico in Viale dei Pini 30.",
        "status": "simulated",
        "postmark_id": null,
        "actor": null,
        "client_key": null,
        "created_at": "2026-10-03 03:00:38",
        "status_at": "2026-10-03 03:00:38"
      }
    ],
    "service_requests": [
      {
        "id": 1,
        "contact_id": 9,
        "property_id": 2,
        "trade": "pulizie",
        "description": "Pulizia completa dell'appartamento prima dell'ingresso.",
        "status": "aperta",
        "created_at": "2026-10-21 03:00:38",
        "cancelled_at": null
      }
    ],
    "quotes": [],
    "reviews": [],
    "notes": [],
    "todos": [],
    "todo_proposals": []
  },
  "files": []
}