Coverage Summary
Source: public/tour-coverage-scan/coverage-summary.json. Run npm run scan:coverage to refresh.
Tables scanned
21
Master tours
22,403
Best coverage
analytics_overview_p (97.88%)
Lowest coverage
depreciation_schedule_p (0.00%)
| Table | Join column | Present | Missing | % complete |
|---|---|---|---|---|
| depreciation_schedule_p | tourId | 1 | 22,402 | 0.00% |
| revisit_bookings_p | tourId | 37 | 22,366 | 0.17% |
| tour_rooms_surfaces_gvx | tourId | 38 | 22,365 | 0.17% |
| tour_rooms_fixtures_1_gvx | tourId | 38 | 22,365 | 0.17% |
| tour_room_damage_gvx | tourId | 38 | 22,365 | 0.17% |
| tour_external_features_gvx | tourId | 41 | 22,362 | 0.18% |
| tour_booking_technician_p | tourId | 88 | 22,315 | 0.39% |
| calendar_event_p | tourId | 88 | 22,315 | 0.39% |
| agent_inquiries_p | tourId | 471 | 21,932 | 2.10% |
| tours_assetment_p | tourId | 1,130 | 21,273 | 5.04% |
| tours_children_p | tourId | 6,647 | 15,756 | 29.67% |
| matterport_floorplans_p | tourId | 7,479 | 14,924 | 33.38% |
| bookings_p | tourId | 12,008 | 10,395 | 53.60% |
| tour_room_floorplan_assets_p | tourId | 17,295 | 5,108 | 77.20% |
| tours_matterport_p | tourId | 17,520 | 4,883 | 78.20% |
| tours_estimates_p | tourId | 17,556 | 4,847 | 78.36% |
| tour_room_panoramic_assets_p | tourId | 19,752 | 2,651 | 88.17% |
| tour_rooms_p | tourId | 19,823 | 2,580 | 88.48% |
| tour_external_panoramic_assets_p | tourId | 20,573 | 1,830 | 91.83% |
| address_metadata_p | tourId | 21,589 | 814 | 96.37% |
| analytics_overview_p | tourId | 21,929 | 474 | 97.88% |