| Customers |
customers |
1 |
id, email |
full_name, name, customer_name, display_name, email_address |
Review |
| Properties |
properties |
1 |
id, customer_id |
client_id, property_name, name, address, street_address |
Review |
| Plans |
plans |
1 |
id, customer_id, property_id, plan_name, status |
client_id, home_id, name, plan_status |
Healthy |
| Inspections |
inspections |
8 |
id, customer_id, property_id, plan_id, inspection_status |
inspection_number, title, status |
Healthy |
| Claims |
claims |
1 |
id, customer_id, property_id, plan_id, inspection_id, claim_number, claim_status |
title, status |
Healthy |
| Invoices |
invoices |
1 |
id, customer_id, property_id, claim_id, invoice_number, status, total_amount |
invoice_total, total |
Healthy |
| Payments |
payments |
1 |
id, invoice_id, status, amount |
payment_reference, reference_no, payment_status, payment_amount, amount_paid |
Healthy |