Table chouette_v17.chouette.vehiclejourney
Vehicle journey

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('vehiclejourney_id_seq'::regclass)
timetablevehiclejourney.vehiclejourneyid vjtm_vj_fkey C
vehiclejourneyatstop.vehiclejourneyid vjas_vj_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
comment varchar 255  √  null Comment
statusvalue varchar 255  √  null Service Status
transportmode varchar 255  √  null Transport mode
publishedjourneyname varchar 255  √  null Name for travelers
publishedjourneyidentifier varchar 255  √  null Identifier for travelers
facility varchar 255  √  null facility
vehicletypeidentifier varchar 255  √  null Vehicle type
number int8 19  √  null Number of the vehicle journey
routeid int8 19  √  null
route.id vj_route_fkey C
Route foreign key
journeypatternid int8 19  √  null
journeypattern.id vj_jp_fkey C
JourneyPattern foreign key
timeslotid int8 19  √  null
timeslot.id vj_timeslot_fkey N
TimeSlot foreign key
companyid int8 19  √  null
company.id vj_company_fkey N
Company foreign key

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

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

Close relationships  within of separation: