View lawprod.MSCM.LOCATION_APP_MAP_VW Generated by
SchemaSpy
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
LOCATION_ID number 22
LOCATION.LOCATION_ID Implied Constraint R
APP_NAME varchar2 30

Analyzed at Wed May 18 12:10 CDT 2011

View Definition:
SELECT DISTINCT MAP.LOCATION_ID, APP_CONFIG.APP_NAME FROM LOCATION_TYPE_MAP MAP, LOCATION_TYPE TYP, APP_CONFIG WHERE MAP.LOCATION_TYPE_ID = TYP.LOCATION_TYPE_ID AND TYP.APP_ID = APP_CONFIG.APP_ID
 
Possibly Referenced Tables/Views:
APP_CONFIG LOCATION_TYPE LOCATION_TYPE_MAP 


Close relationships: