Table chouette_v17.chouette.accesspoint
Access point

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('accesspoint_id_seq'::regclass)
accesslink.accesspointid aclk_acpt_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
comment varchar 255  √  null Comment
countrycode varchar 255  √  null Zip code
streetname varchar 255  √  null Address
longitude numeric 19,16  √  null Longitude
latitude numeric 19,16  √  null Latitude
longlattype varchar 255  √  null Model used for Longitude and Latitude (Standard, WGS84 or WGS92)
x numeric 19,2  √  null X coordinate
y numeric 19,2  √  null Y coordinate
projectiontype varchar 255  √  null Projection used for coordinates
containedin varchar 255  √  null Unused data
openningtime timestamp 29,6  √  null Opening time
closingtime timestamp 29,6  √  null Closing time
type varchar 255  √  null Access Point Type : free description
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

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

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

Close relationships  within of separation: