Coverage Summary
Source: public/tour-coverage-scan/coverage-summary.json. Run npm run scan:coverage to refresh.
Tables scanned
27
Master tours
22,217
Best coverage
analytics_overview_p (98.03%)
Lowest coverage
reports_visitors_p (0.00%)
| Table | Join column | Present | Missing | % complete |
|---|---|---|---|---|
| reports_visitors_p | tourId | 0 | 22,217 | 0.00% |
| reports_rooms_p | tourId | 0 | 22,217 | 0.00% |
| reports_sources_p | tourId | 0 | 22,217 | 0.00% |
| reports_visitor_locations_p | tourId | 0 | 22,217 | 0.00% |
| reports_heatmap_p | tourId | 0 | 22,217 | 0.00% |
| visitor_p | tourId | 0 | 22,217 | 0.00% |
| tour_rooms_surfaces_gvx | tourId | 1 | 22,216 | 0.00% |
| tour_rooms_fixtures_1_gvx | tourId | 1 | 22,216 | 0.00% |
| tour_room_damage_gvx | tourId | 1 | 22,216 | 0.00% |
| depreciation_schedule_p | tourId | 1 | 22,216 | 0.00% |
| tour_external_features_gvx | tourId | 0 | 22,217 | 0.00% |
| revisit_bookings_p | tourId | 37 | 22,180 | 0.17% |
| tour_booking_technician_p | tourId | 88 | 22,129 | 0.40% |
| calendar_event_p | tourId | 88 | 22,129 | 0.40% |
| agent_inquiries_p | tourId | 383 | 21,834 | 1.72% |
| tours_assetment_p | tourId | 1,130 | 21,087 | 5.09% |
| tours_children_p | tourId | 6,637 | 15,580 | 29.87% |
| matterport_floorplans_p | tourId | 7,276 | 14,941 | 32.75% |
| tour_external_panoramic_assets_p | tourId | 9,361 | 12,856 | 42.13% |
| bookings_p | tourId | 11,825 | 10,392 | 53.23% |
| tour_room_floorplan_assets_p | tourId | 17,295 | 4,922 | 77.85% |
| tours_estimates_p | tourId | 17,422 | 4,795 | 78.42% |
| tours_matterport_p | tourId | 17,520 | 4,697 | 78.86% |
| tour_room_panoramic_assets_p | tourId | 19,276 | 2,941 | 86.76% |
| tour_rooms_p | tourId | 19,620 | 2,597 | 88.31% |
| address_metadata_p | tourId | 21,405 | 812 | 96.35% |
| analytics_overview_p | tourId | 21,779 | 438 | 98.03% |