Table chouette_v17.chouette.stoparea
StopArea

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 bigserial 19  √  nextval('stoparea_id_seq'::regclass)
accesslink.stopareaid aclk_area_fkey C
connectionlink.arrivalid colk_endarea_fkey C
connectionlink.departureid colk_startarea_fkey C
facility.stopareaid faci_area_fkey C
routingconstraints_lines.stopareaid routingconstraint_stoparea_fkey C
stoparea.parentid area_parent_fkey N
stopareastoparea.childid stoparea_child_fkey C
stopareastoparea.parentid stoparea_parent_fkey C
stoppoint.stopareaid stoppoint_area_fkey R
Internal identification
objectid varchar 255 Neptune identification
objectversion int4 10  √  null Version of this object
creationtime timestamp 29,6  √  null Creation date and time
creatorid varchar 255  √  null Creator identification
name varchar 255  √  null Name
comment varchar 255  √  null Comment
areatype varchar 255  √  null Type of Area : BoardingPosition, Quay, CommercialStopPoint, StopPlace or ITL)
registrationnumber varchar 255  √  null Registration number
nearesttopicname varchar 255  √  null Nearest topic name
farecode int4 10  √  null Fare code
longitude numeric 19,16  √  null Longitude
latitude numeric 19,16  √  null Latitude
longlattype varchar 255  √  null Model used for Longitude and Latitude (Standard, WGS84 or WGS92)
x numeric 19,2  √  null X coordinate
y numeric 19,2  √  null Y coordinate
projectiontype varchar 255  √  null Projection used for coordinates
countrycode varchar 255  √  null Zip code
streetname varchar 255  √  null Address
parentid int8 19  √  null
stoparea.id area_parent_fkey N
(deprecated) Main parent StopArea internal id for v1.6 compatibility

Analyzed at lun. nov. 07 16:59 CET 2011

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc stoparea_pkey
areatype Performance Asc areatype
longitude + latitude Performance Asc/Asc coordinates
objectid Must be unique Asc stoparea_objectid_key

Close relationships  within of separation: