Table chouette_v17.chouette.facility
Facility

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('facility_id_seq'::regclass)
facilityfeature.facilityid facility_feature_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
stopareaid int8 19  √  null
stoparea.id faci_area_fkey C
StopArea reference
lineid int8 19  √  null
line.id faci_line_fkey C
Line reference
connectionlinkid int8 19  √  null
connectionlink.id faci_colk_fkey C
ConnectionLink reference
stoppointid int8 19  √  null
stoppoint.id faci_stpt_fkey C
StopPoint reference
description varchar 255  √  null Facility description
freeaccess bool 1  √  null Indicate if facility is on free (true) or restricted(false) access
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)
countrycode varchar 255  √  null Zip code
streetname varchar 255  √  null Address
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

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

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

Close relationships  within of separation: