| id | address | inspection_date |
|---|---|---|
| 1 | 123 Main St | 2022-01-01 |
| 2 | 456 Elm St | 2022-01-02 |
| 3 | 789 Oak St | 2022-01-03 |
| 4 | 135 Maple Ave | 2022-01-04 |
| 5 | 987 Pine Rd | 2022-01-05 |
| id | issue_type |
|---|---|
| 1 | Roof Damage |
| 2 | Foundation Crack |
| 3 | Electrical Problem |
| 4 | Plumbing Issue |
| 5 | Pest Infestation |
| home_inspection_id | issue_id |
|---|---|
| (→ Home_Inspections.id) | (→ Issues.id) |
| 1 | 1 |
| 2 | 1 |
| 3 | 1 |
| 4 | 1 |
| 5 | 1 |
| 5 | 3 |