{
  "contact_id": 1,
  "exported_at": "2026-10-22T09:31:52.173Z",
  "tables": {
    "contacts": [
      {
        "id": 1,
        "name": "Giulia Ferrante",
        "email": "giulia.ferrante@example.com",
        "phone": "+390001000001",
        "kind": "buyer",
        "household_size": 3,
        "ages": "38, 36, 4",
        "occupation": "Insegnante",
        "monthly_income_cents": 210000,
        "contract_type": "indeterminato",
        "move_in_date": null,
        "stay_months": null,
        "pets": null,
        "smoker": null,
        "guarantor_or_deposit": null,
        "budget_cents": 18000000,
        "areas": "Cassino centro, Cervaro",
        "marketing_consent": 1,
        "birthday": "1988-03-14",
        "created_at": "2026-10-22 03:00:38",
        "address": "Via Casilina Nord 120, Cassino",
        "requirements": "Trilocale con balcone o giardino, zona centrale",
        "has_property_to_sell": 0,
        "mortgage_approved": 1,
        "first_name": "Giulia",
        "last_name": "Ferrante"
      }
    ],
    "contact_roles": [
      {
        "contact_id": 1,
        "role": "buyer",
        "status": "active"
      }
    ],
    "properties": [],
    "activity_log": [
      {
        "id": 3,
        "kind": "email",
        "source": "tap",
        "contact_id": 1,
        "property_id": 1,
        "enquiry_id": 10,
        "actor": null,
        "created_at": "2026-10-14 05:00:38"
      },
      {
        "id": 2,
        "kind": "call",
        "source": "contacted",
        "contact_id": 1,
        "property_id": 1,
        "enquiry_id": 10,
        "actor": null,
        "created_at": "2026-10-14 04:00:38"
      }
    ],
    "appointments": [
      {
        "id": 2,
        "kind": "visit",
        "starts_at": "2026-10-19 09:00:00",
        "duration_min": 60,
        "contact_id": 1,
        "property_id": 1,
        "title": "",
        "notes": "Portare la planimetria.",
        "created_at": "2026-10-22 03:00:38",
        "status": "done"
      },
      {
        "id": 8,
        "kind": "call",
        "starts_at": "2026-10-22 07:30:00",
        "duration_min": 15,
        "contact_id": 1,
        "property_id": 7,
        "title": "Conferma visita",
        "notes": "",
        "created_at": "2026-10-22 03:00:38",
        "status": "scheduled"
      },
      {
        "id": 9,
        "kind": "visit",
        "starts_at": "2026-10-22 08:00:00",
        "duration_min": 60,
        "contact_id": 1,
        "property_id": 7,
        "title": "",
        "notes": "",
        "created_at": "2026-10-22 03:00:38",
        "status": "scheduled"
      }
    ],
    "messages": [
      {
        "id": 1,
        "channel": "email",
        "mailbox": "romina",
        "from_addr": "giulia.ferrante@example.com",
        "from_name": "Giulia Ferrante",
        "reply_to": null,
        "subject": "Seconda visita in Via dei Tigli 45",
        "body_text": "Buongiorno Romina,\ndopo la visita di ieri ne abbiamo parlato a casa: ci piacerebbe tornare a vedere l'appartamento con mio marito, magari sabato mattina.\n\nSi può salire anche in cantina?\n\nGrazie, Giulia",
        "r2_key": null,
        "contact_id": 1,
        "read_at": "2026-10-22 06:06:31",
        "received_at": "2026-10-22 01:00:38"
      }
    ],
    "enquiries": [
      {
        "id": 8,
        "contact_id": 1,
        "property_id": 7,
        "portal": "casa.it",
        "message": "Il casale ha l'allaccio al gas?",
        "received_at": "2026-10-16 03:00:38",
        "status": "follow_up_due",
        "next_action_at": "2026-10-24 03:00:38",
        "draft_email": null,
        "email_sent_at": null,
        "draft_model_at": null,
        "draft_from_model": 0,
        "converted_at": null,
        "draft_at": null
      },
      {
        "id": 10,
        "contact_id": 1,
        "property_id": 1,
        "portal": "immobiliare",
        "message": "Vorrei vedere il trilocale con mio marito.",
        "received_at": "2026-10-14 03:00:38",
        "status": "called",
        "next_action_at": null,
        "draft_email": "Gentile Giulia, grazie per il suo interesse per il trilocale in Via dei Tigli 45.",
        "email_sent_at": "2026-10-15 03:00:38",
        "draft_model_at": null,
        "draft_from_model": 0,
        "converted_at": null,
        "draft_at": null
      }
    ],
    "sent_emails": [
      {
        "id": 1,
        "contact_id": 1,
        "enquiry_id": 10,
        "to_addr": "giulia.ferrante@example.com",
        "subject": "La sua richiesta su Via dei Tigli 45, Cassino",
        "body_text": "Gentile Giulia, grazie per il suo interesse per il trilocale in Via dei Tigli 45.",
        "status": "simulated",
        "postmark_id": null,
        "actor": null,
        "client_key": null,
        "created_at": "2026-10-15 03:00:38",
        "status_at": "2026-10-15 03:00:38"
      },
      {
        "id": 3,
        "contact_id": 1,
        "enquiry_id": null,
        "to_addr": "giulia.ferrante@example.com",
        "subject": "Grazie per la visita",
        "body_text": "Buongiorno Giulia, grazie per la visita di ieri in Via dei Tigli 45.",
        "status": "simulated",
        "postmark_id": null,
        "actor": null,
        "client_key": null,
        "created_at": "2026-10-20 03:00:38",
        "status_at": "2026-10-20 03:00:38"
      }
    ],
    "service_requests": [],
    "quotes": [],
    "reviews": [],
    "notes": [],
    "todos": [
      {
        "id": 3,
        "body": "Richiamare per confermare la visita di domani.",
        "done": 0,
        "entity_type": "contact",
        "entity_id": 1,
        "created_at": "2026-10-22 03:00:38",
        "kind": "todo",
        "urgent": 1,
        "due_on": null
      }
    ],
    "todo_proposals": [
      {
        "id": 1,
        "body": "Rispondere a Giulia Ferrante per la seconda visita in Via dei Tigli 45, sabato mattina, con la cantina.",
        "kind": "todo",
        "due_on": "2026-10-22",
        "entity_type": "contact",
        "entity_id": 1,
        "source_type": "message",
        "source_id": 1,
        "status": "proposed",
        "todo_id": null,
        "created_at": "2026-10-22 03:00:38"
      }
    ]
  },
  "files": []
}