Table chouette_v17.chouette.accesslink
Access Link

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('accesslink_id_seq'::regclass) 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
comment varchar 255  √  null Comment
linkdistance numeric 19,2  √  null Distance between AccesPoint and StopArea
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 Default duration to cross this link
frequenttravellerduration time 15,6  √  null Duration of travel for frequent travellers
occasionaltravellerduration time 15,6  √  null Duration of travel for occasional travellers
mobilityrestrictedtravellerduration time 15,6  √  null Duration of travel for mobility restricted travellers
linktype varchar 255  √  null Link type : Underground, Overground or Mixed
intuserneeds int4 10  √  null binary mapping of userNeed list
linkorientation varchar 255  √  null Link orientation : accesspoint_to_stoparea or stoparea_to_accesspoint
accesspointid int8 19  √  null
accesspoint.id aclk_acpt_fkey C
AccessPoint reference
stopareaid int8 19  √  null
stoparea.id aclk_area_fkey C
StopArea reference

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

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

Close relationships  within of separation: