Table chouette_v17.chouette.connectionlink
Connection link between 2 stopareas

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('connectionlink_id_seq'::regclass)
facility.connectionlinkid faci_colk_fkey C
Internal identification
objectid varchar 255 Neptune identification
objectversion int4 10  √  1 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
linkdistance numeric 19,2  √  null Distance between StopAreas
departureid int8 19  √  null
stoparea.id colk_startarea_fkey C
Start stoparea internal id
arrivalid int8 19  √  null
stoparea.id colk_endarea_fkey C
End stoparea internal id
liftavailability bool 1  √  null Indicate if a lift is available
mobilityrestrictedsuitability bool 1  √  null Indicate if the link is suitable for mobility restricted persons
stairsavailability bool 1  √  null Indicate if stairs are available
defaultduration time 15,6  √  null average duration of travel
frequenttravellerduration time 15,6  √  null duration of travel for frequent traveller
occasionaltravellerduration time 15,6  √  null duration of travel for occasional traveler
mobilityrestrictedtravellerduration time 15,6  √  null duration of travel for mobiliy restricted traveller
linktype varchar 255  √  null Type (Underground,Overground or Mixed)
intuserneeds int4 10  √  null binary mapping of userNeed list

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc connectionlink_pkey

Close relationships  within of separation: