Relationships

Review linked-record relationships across customers, properties, plans, inspections, claims, invoices, and payments in 4 P’s.

Relationship Checks
14
Linked Records
28
Unlinked Records
7

Relationship Notes

  1. Use this page to see where relationship chains are strong and where records are missing parent links.
  2. A high unlinked count usually means imports, manual edits, or partial workflows left records disconnected.
  3. Check audit.php after fixing relationships to confirm the missing-link counts go down.
  4. For full operational flow, the strongest chain is customer → property → plan → inspection/claim → invoice → payment.

Quick Read

Signal Value
Total linked relationships 28
Total unlinked relationships 7
Checks available 14

Relationship Matrix

Relationship Linked Unlinked Status
Properties → Customers 1 0 Clean
Plans → Customers 1 0 Clean
Plans → Properties 1 0 Clean
Inspections → Customers 8 0 Clean
Inspections → Properties 8 0 Clean
Inspections → Plans 1 7 Review
Claims → Customers 1 0 Clean
Claims → Properties 1 0 Clean
Claims → Plans 1 0 Clean
Claims → Inspections 1 0 Clean
Invoices → Customers 1 0 Clean
Invoices → Properties 1 0 Clean
Invoices → Claims 1 0 Clean
Payments → Invoices 1 0 Clean