Table chouette_v17.chouette.stoppoint
stop point on route

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('stoppoint_id_seq'::regclass)
facility.stoppointid faci_stpt_fkey C
journeypattern_stoppoint.stoppointid jpsp_stoppoint_fkey C
ptlink.endoflinkid ptlk_endstpt_fkey R
ptlink.startoflinkid ptlk_startstpt_fkey R
vehiclejourneyatstop.stoppointid vjas_sp_fkey C
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
position int4 10  √  null Rank of stop point in route
stopareaid int8 19  √  null
stoparea.id stoppoint_area_fkey R
StopArea reference
routeid int8 19  √  null
route.id stoppoint_route_fkey C
Route reference

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc stoppoint_pkey
objectid Must be unique Asc stoppoint_objectid_key

Close relationships  within of separation: