Table osm.public.planet_osm_roads 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
osm_id int4 10  √  null
access text 2147483647  √  null
addr:flats text 2147483647  √  null
addr:housenumber text 2147483647  √  null
addr:interpolation text 2147483647  √  null
admin_level text 2147483647  √  null
aerialway text 2147483647  √  null
aeroway text 2147483647  √  null
amenity text 2147483647  √  null
area text 2147483647  √  null
barrier text 2147483647  √  null
bicycle text 2147483647  √  null
bridge text 2147483647  √  null
boundary text 2147483647  √  null
building text 2147483647  √  null
construction text 2147483647  √  null
cutting text 2147483647  √  null
disused text 2147483647  √  null
embankment text 2147483647  √  null
foot text 2147483647  √  null
highway text 2147483647  √  null
historic text 2147483647  √  null
horse text 2147483647  √  null
junction text 2147483647  √  null
landuse text 2147483647  √  null
layer text 2147483647  √  null
learning text 2147483647  √  null
leisure text 2147483647  √  null
lock text 2147483647  √  null
man_made text 2147483647  √  null
military text 2147483647  √  null
motorcar text 2147483647  √  null
name text 2147483647  √  null
natural text 2147483647  √  null
oneway text 2147483647  √  null
operator text 2147483647  √  null
power text 2147483647  √  null
power_source text 2147483647  √  null
place text 2147483647  √  null
railway text 2147483647  √  null
ref text 2147483647  √  null
religion text 2147483647  √  null
residence text 2147483647  √  null
route text 2147483647  √  null
service text 2147483647  √  null
shop text 2147483647  √  null
sport text 2147483647  √  null
tourism text 2147483647  √  null
tracktype text 2147483647  √  null
tunnel text 2147483647  √  null
waterway text 2147483647  √  null
width text 2147483647  √  null
wood text 2147483647  √  null
z_order int4 10  √  null
way_area float4 8,8  √  null
way geometry 2147483647  √  null

Table contained 256 412 rows at jeu. janv. 13 02:29 CET 2011

Indexes:
Column(s) Type Sort Constraint Name
way Performance Asc planet_osm_roads_index
osm_id Performance Asc planet_osm_roads_pkey