Table chouette_v17.chouette.route
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('route_id_seq'::regclass)
journeypattern.routeid jp_route_fkey C
ptlink.routeid ptlink_route_fkey C
stoppoint.routeid stoppoint_route_fkey C
vehiclejourney.routeid vj_route_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
name varchar 255  √  null Name
oppositerouteid int8 19  √  null Opposite route reference
publishedname varchar 255  √  null Published name
number varchar 255  √  null Number
direction varchar 255  √  null Direction : North, East, ...
comment varchar 255  √  null Comment
wayback varchar 255  √  null Orientation : A or R
lineid int8 19  √  null
line.id route_line_fkey C
Line reference

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

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

Close relationships  within of separation: