Table chouette_v17.chouette.vehiclejourneyatstop
Vehicle Journey at Stop

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
vehiclejourneyid int8 19
vehiclejourney.id vjas_vj_fkey C
VehicleJourney foreign key (1st part of primary key)
stoppointid int8 19
stoppoint.id vjas_sp_fkey C
StopPoint foreign key (2nd part of primary key)
connectingserviceid varchar 255  √  null connectingServiceId
boardingalightingpossibility varchar 255  √  null boardingAlightingPossibility
position int8 19  √  null order in JourneyPattern
arrivaltime time 15,6  √  null Arrival time
departuretime time 15,6  √  null Departure time
waitingtime time 15,6  √  null Waiting time
elapseduration time 15,6  √  null elapse duration
headwayfrequency time 15,6  √  null headway frequency
isdeparture bool 1  √  false First stop of the vehicle journey
isarrival bool 1  √  false Last stop of the vehicle journey

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

Indexes:
Column(s) Type Sort Constraint Name
vehiclejourneyid + stoppointid Primary key Asc/Asc vehiclejourneyatstop_pkey

Close relationships  within of separation: