{ "contact_id": 5, "exported_at": "2026-10-22T09:31:23.716Z", "tables": { "contacts": [ { "id": 5, "name": "Luigi Mancini", "email": "luigi.mancini@example.com", "phone": "+390001000005", "kind": "seller", "household_size": null, "ages": null, "occupation": null, "monthly_income_cents": null, "contract_type": null, "move_in_date": null, "stay_months": null, "pets": null, "smoker": null, "guarantor_or_deposit": null, "budget_cents": null, "areas": null, "marketing_consent": 1, "birthday": "1961-11-23", "created_at": "2026-10-22 03:00:38", "address": "Via Roma 15, Cassino", "requirements": null, "has_property_to_sell": null, "mortgage_approved": null, "first_name": "Luigi", "last_name": "Mancini" } ], "contact_roles": [ { "contact_id": 5, "role": "seller", "status": "active" } ], "properties": [ { "id": 1, "address": "Via dei Tigli 45", "comune": "Cassino", "cap": "03043", "listing_type": "sale", "price_cents": 16500000, "bedrooms": 3, "sqm": 95, "description": "Trilocale luminoso al secondo piano, con balcone e posto auto.", "photo_url": "/demo/casa-1.svg", "created_at": "2026-09-12 03:00:38", "owner_contact_id": 5, "provincia": "Frosinone", "bathrooms": 1, "floor": "2", "lift": 0, "orientation": "sud", "condition": "buono", "year_built": 1998, "energy_class": "D", "heating": "autonomo", "condo_fees_cents": 8000, "outdoor": "balcone,posto_auto", "furnished": "no", "street": "tranquilla", "street_notes": "Traversa chiusa, si parcheggia sotto casa.", "nearby": "scuole,negozi,autobus", "pros": "Luminoso tutto il giorno, spese basse, posto auto di proprietà.", "cons": "Senza ascensore, infissi originali degli anni 90.", "public_slug": null, "status": "under_offer", "sold_price_cents": null, "sold_at": null, "tenant_contact_id": null, "lease_end": null }, { "id": 7, "address": "Strada dei Campi 150", "comune": "Pontecorvo", "cap": "03037", "listing_type": "sale", "price_cents": 31500000, "bedrooms": 4, "sqm": 180, "description": "Casale con un ettaro di terreno e annesso rustico.", "photo_url": "/demo/casa-7.svg", "created_at": "2026-09-12 03:00:38", "owner_contact_id": 5, "provincia": null, "bathrooms": null, "floor": null, "lift": null, "orientation": null, "condition": null, "year_built": null, "energy_class": null, "heating": null, "condo_fees_cents": null, "outdoor": null, "furnished": null, "street": null, "street_notes": null, "nearby": null, "pros": null, "cons": null, "public_slug": null, "status": "on_market", "sold_price_cents": null, "sold_at": null, "tenant_contact_id": null, "lease_end": null } ], "activity_log": [ { "id": 1, "kind": "call", "source": "tap", "contact_id": 5, "property_id": 1, "enquiry_id": null, "actor": null, "created_at": "2026-10-22 01:00:38" } ], "appointments": [ { "id": 3, "kind": "call", "starts_at": "2026-10-19 10:30:00", "duration_min": 15, "contact_id": 5, "property_id": 1, "title": "Rinnovo incarico", "notes": "", "created_at": "2026-10-22 03:00:38", "status": "done" }, { "id": 10, "kind": "works", "starts_at": "2026-10-23 06:00:00", "duration_min": 240, "contact_id": 5, "property_id": 7, "title": "Intonaco in facciata", "notes": "Edilizia Tomassi, ponteggio già montato.", "created_at": "2026-10-22 03:00:38", "status": "scheduled" } ], "messages": [ { "id": 4, "channel": "email", "mailbox": "romina", "from_addr": "luigi.mancini@example.com", "from_name": "Luigi Mancini", "reply_to": null, "subject": "Re: Offerta per Via dei Tigli 45", "body_text": "Cara Romina,\n155.000 euro mi vanno bene se il rogito è entro dicembre.\nMi faccia sapere, Luigi Mancini", "r2_key": null, "contact_id": 5, "read_at": "2026-10-20 03:00:38", "received_at": "2026-10-19 21:00:38" } ], "enquiries": [], "sent_emails": [], "service_requests": [ { "id": 3, "contact_id": 5, "property_id": 7, "trade": "muratore", "description": "Rifacimento dell'intonaco in facciata prima della vendita.", "status": "prenotato", "created_at": "2026-10-12 03:00:38", "cancelled_at": null }, { "id": 6, "contact_id": 5, "property_id": 7, "trade": "muratore", "description": "Riparazione delle crepe nel muro di cinta.", "status": "chiuso", "created_at": "2026-09-12 03:00:38", "cancelled_at": null } ], "quotes": [ { "id": 4, "service_request_id": 3, "professional_id": 7, "amount_cents": 320000, "note": "Ponteggio incluso, dieci giorni lavorativi.", "status": "scelto" }, { "id": 5, "service_request_id": 3, "professional_id": 8, "amount_cents": 350000, "note": "Ponteggio a parte.", "status": "scartato" }, { "id": 6, "service_request_id": 3, "professional_id": 9, "amount_cents": 410000, "note": "Tinteggiatura inclusa.", "status": "scartato" }, { "id": 13, "service_request_id": 6, "professional_id": 7, "amount_cents": 90000, "note": "Materiali inclusi.", "status": "scelto" }, { "id": 14, "service_request_id": 6, "professional_id": 8, "amount_cents": 110000, "note": null, "status": "scartato" }, { "id": 15, "service_request_id": 6, "professional_id": 9, "amount_cents": 95000, "note": null, "status": "scartato" } ], "reviews": [ { "id": 3, "service_request_id": 6, "contact_id": 5, "professional_id": 7, "rating": 5, "text": "Sopralluogo rapido e preventivo chiaro.", "created_at": "2026-09-22 03:00:38" } ], "notes": [], "todos": [], "todo_proposals": [ { "id": 2, "body": "Riferire all'acquirente che Luigi Mancini accetta 155.000 euro con rogito entro dicembre.", "kind": "todo", "due_on": "2026-10-22", "entity_type": "contact", "entity_id": 5, "source_type": "message", "source_id": 4, "status": "proposed", "todo_id": null, "created_at": "2026-10-22 03:00:38" }, { "id": 3, "body": "Scrivi a Luigi Mancini per confermare l'appuntamento di domani alle 08:00.", "kind": "todo", "due_on": "2026-10-22", "entity_type": "contact", "entity_id": 5, "source_type": "appointment", "source_id": 10, "status": "proposed", "todo_id": null, "created_at": "2026-10-22 03:00:38" } ] }, "files": [] }