View slot9.WORLD.TSTA.PROPERTIES_ASSOC_CNT_VW
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
MODULE varchar2 8  √  null
PROPERTY_ID number 38  √  null
COUNT number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

View Definition:
SELECT 'Business', pro_property_id, COUNT (pro_property_id) FROM business_properties GROUP BY 1, pro_property_id UNION SELECT 'Person', property_id, COUNT (property_id) FROM people_properties GROUP BY 1, property_id
 
Possibly Referenced Tables/Views:
BUSINESS_PROPERTIES PEOPLE_PROPERTIES