MA

Dave & Marcia Henderson

C6
proposedOne human across time — no job data lives here (JN's contact-workflow era is over).

Identity

  • kindcustomer
  • phone(801) 555-0142
  • emaildhenderson@gmail.com
  • idCT-201

Dedup key = normalized phone + email. Exact match at create → force-link back to this row.

Properties

A contact can own many properties; each hosts many jobs over its life.

Jobs — all time, all trades · lifetime $24,800

JobTradePipelineStageValueBalance

Messages — full thread

  • sms07-19 15:14→ office
    Great, we'll move the cars off the driveway.
  • sms07-19 15:10→ customer
    Your crew arrives Tuesday ~7am. Materials deliver Monday afternoon.
  • email07-18 11:21→ customer
    Signed contract attached for your records (audit #ES-2201).
  • sms07-16 10:02→ office
    We like Weathered Wood.
  • sms07-16 09:41→ customer
    Color selection link — tap to pick your shingle color.
  • email07-12 15:12→ office
    The adjuster left a voicemail — can you call us before Friday?

Full thread (message_log — Twilio numbers move under XOS as-is). Per-job slices of this same thread show on job timelines.