Table HLPDTEST.STATEGPS.T_GOOGLE_MAPS_GEOCODE_MAPPING Generated by
SchemaSpy
Legend: SourceForge.net
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
ID number 22
T_DELETE_ROW_ACTION_UPDATE.ID Implied Constraint R
ADDRESS varchar2 2000  √  null
GEOCODE varchar2 2000  √  null
STREET_NUMBER varchar2 200  √  null
SUBLOCALITY_LEVEL_1 varchar2 200  √  null
ROUTE varchar2 200  √  null
NEIGHBORHOOD varchar2 200  √  null
LOCALITY varchar2 200  √  null
ADMINISTRATIVE_AREA_LEVEL_2 varchar2 200  √  null
ADMINISTRATIVE_AREA_LEVEL_1 varchar2 200  √  null
POSTAL_CODE varchar2 200  √  null
COUNTRY varchar2 200  √  null
ADDRESS1 varchar2 200  √  null
ADDRESS2 varchar2 200  √  null
ADDRESS3 varchar2 200  √  null
ADDRESS4 varchar2 200  √  null
CITY varchar2 200  √  null
STATE varchar2 200  √  null
COUNTY varchar2 200  √  null
STATUS varchar2 200  √  null

Table contained 750 rows at Thu Aug 13 01:05 IST 2020

Indexes:
Column(s) Type Sort Constraint Name
ID Primary key Asc T_GOOGLE_MAPS_GEOCODE_MAPP_PK
ADDRESS Performance Asc T_GMAPS_GEOCODES_ADDREES_INDX

Close relationships: