SchemaSpy Analysis of chouette_v17.chouette - ColumnsCHOUETTE Generated by
SchemaSpy
Generated by SchemaSpy on lun. nov. 07 16:59 CET 2011
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

chouette_v17.chouette contains 260 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
accesslink id bigserial 19  √  nextval('accesslink_id_seq'::regclass) Internal identification
accesspoint id bigserial 19  √  nextval('accesspoint_id_seq'::regclass) Internal identification
company id bigserial 19  √  nextval('company_id_seq'::regclass) Internal identification
connectionlink id bigserial 19  √  nextval('connectionlink_id_seq'::regclass) Internal identification
facility id bigserial 19  √  nextval('facility_id_seq'::regclass) Internal identification
groupofline id bigserial 19  √  nextval('groupofline_id_seq'::regclass) Internal identification
journeypattern id bigserial 19  √  nextval('journeypattern_id_seq'::regclass) Internal identification
line id bigserial 19  √  nextval('line_id_seq'::regclass) Internal identification
ptlink id bigserial 19  √  nextval('ptlink_id_seq'::regclass) Internal identification
ptnetwork id bigserial 19  √  nextval('ptnetwork_id_seq'::regclass) Internal identification
route id bigserial 19  √  nextval('route_id_seq'::regclass) Internal identification
stoparea id bigserial 19  √  nextval('stoparea_id_seq'::regclass) Internal identification
stoppoint id bigserial 19  √  nextval('stoppoint_id_seq'::regclass) Internal identification
timeslot id bigserial 19  √  nextval('timeslot_id_seq'::regclass) Internal identification
timetable id bigserial 19  √  nextval('timetable_id_seq'::regclass) Internal identification
vehiclejourney id bigserial 19  √  nextval('vehiclejourney_id_seq'::regclass) Internal identification
facility freeaccess bool 1  √  null Indicate if facility is on free (true) or restricted(false) access
vehiclejourneyatstop isarrival bool 1  √  false Last stop of the vehicle journey
vehiclejourneyatstop isdeparture bool 1  √  false First stop of the vehicle journey
accesslink liftavailability bool 1  √  null Indicate if a lift is available
accesspoint liftavailability bool 1  √  null Indicate if a lift is available
connectionlink liftavailability bool 1  √  null Indicate if a lift is available
accesslink mobilityrestrictedsuitability bool 1  √  null Indicate if the link is suitable for mobility restricted persons
accesspoint mobilityrestrictedsuitability bool 1  √  null Indicate if the link is suitable for mobility restricted persons
connectionlink mobilityrestrictedsuitability bool 1  √  null Indicate if the link is suitable for mobility restricted persons
line mobilityrestrictedsuitable bool 1  √  null Indicate whenever the line is suitable for mobility restricted persons
accesslink stairsavailability bool 1  √  null Indicate if stairs are available
accesspoint stairsavailability bool 1  √  null Indicate if stairs are available
connectionlink stairsavailability bool 1  √  null Indicate if stairs are available
timeslot creationtime date 13  √  null Creation date and time
timetable_date date date 13  √  null calendar date
timetable_period periodend date 13  √  null end date of period
timetable_period periodstart date 13  √  null start date of period
ptnetwork versiondate date 13  √  null PTNetwork version date
facilityfeature choicecode int4 10  √  null encoded value for facility
stoparea farecode int4 10  √  null Fare code
timetable intdaytypes int4 10  √  null coded DayTypeEnum list (Monday,Tuesday, ...)
accesslink intuserneeds int4 10  √  null binary mapping of userNeed list
connectionlink intuserneeds int4 10  √  null binary mapping of userNeed list
accesslink objectversion int4 10  √  null Version of this object
accesspoint objectversion int4 10  √  null Version of this object
company objectversion int4 10  √  1 Version of this object
connectionlink objectversion int4 10  √  1 Version of this object
facility objectversion int4 10  √  null Version of this object
groupofline objectversion int4 10  √  null Version of this object
journeypattern objectversion int4 10  √  1 Version of this object
line objectversion int4 10  √  1 Version of this object
ptlink objectversion int4 10  √  null Version of this object
ptnetwork objectversion int4 10  √  null Version of this object
route objectversion int4 10  √  null Version of this object
stoparea objectversion int4 10  √  null Version of this object
stoppoint objectversion int4 10  √  null Version of this object
timeslot objectversion int4 10  √  1 Version of this object
timetable objectversion int4 10  √  null Version of this object
vehiclejourney objectversion int4 10  √  null Version of this object
stoppoint position int4 10  √  null Rank of stop point in route
timetable_date position int4 10 order of date
timetable_period position int4 10 order of date
accesslink accesspointid int8 19  √  null AccessPoint reference
connectionlink arrivalid int8 19  √  null End stoparea internal id
stopareastoparea childid int8 19 Child reference in hierarchy
line companyid int8 19  √  null Company reference
vehiclejourney companyid int8 19  √  null Company foreign key
facility connectionlinkid int8 19  √  null ConnectionLink reference
connectionlink departureid int8 19  √  null Start stoparea internal id
ptlink endoflinkid int8 19  √  null End StopPoint reference
facilityfeature facilityid int8 19 Facility reference
groupofline_line groupoflineid int8 19 GroupOfLine reference
line groupoflineid int8 19  √  null GroupOfLine reference
journeypattern_stoppoint journeypatternid int8 19 JourneyPattern Reference
vehiclejourney journeypatternid int8 19  √  null JourneyPattern foreign key
facility lineid int8 19  √  null Line reference
groupofline_line lineid int8 19 Line reference
route lineid int8 19  √  null Line reference
routingconstraints_lines lineid int8 19 Line reference
vehiclejourney number int8 19  √  null Number of the vehicle journey
route oppositerouteid int8 19  √  null Opposite route reference
stoparea parentid int8 19  √  null (deprecated) Main parent StopArea internal id for v1.6 compatibility
stopareastoparea parentid int8 19 Parent reference in hierarchy
vehiclejourneyatstop position int8 19  √  null order in JourneyPattern
line ptnetworkid int8 19  √  null PTNetwork reference
journeypattern routeid int8 19  √  null Route Reference
ptlink routeid int8 19  √  null Route reference
stoppoint routeid int8 19  √  null Route reference
vehiclejourney routeid int8 19  √  null Route foreign key
ptlink startoflinkid int8 19  √  null Start StopPoint reference
accesslink stopareaid int8 19  √  null StopArea reference
facility stopareaid int8 19  √  null StopArea reference
routingconstraints_lines stopareaid int8 19 Routing constraint reference
stoppoint stopareaid int8 19  √  null StopArea reference
facility stoppointid int8 19  √  null StopPoint reference
journeypattern_stoppoint stoppointid int8 19 StopPoint Reference
vehiclejourneyatstop stoppointid int8 19 StopPoint foreign key (2nd part of primary key)
vehiclejourney timeslotid int8 19  √  null TimeSlot foreign key
timetable_date timetableid int8 19 timetable foreign key
timetable_period timetableid int8 19 timetable foreign key
timetablevehiclejourney timetableid int8 19 Timetable foreign key
line userneeds int8 19  √  null bit encoded list of userneeds enum value
timetablevehiclejourney vehiclejourneyid int8 19 VehicleJourney foreign key
vehiclejourneyatstop vehiclejourneyid int8 19 VehicleJourney foreign key (1st part of primary key)
accesslink linkdistance numeric 19,2  √  null Distance between AccesPoint and StopArea
connectionlink linkdistance numeric 19,2  √  null Distance between StopAreas
ptlink linkdistance numeric 19,2  √  null Distance between AccesPoint and StopArea
accesspoint x numeric 19,2  √  null X coordinate
facility x numeric 19,2  √  null X coordinate
stoparea x numeric 19,2  √  null X coordinate
accesspoint y numeric 19,2  √  null Y coordinate
facility y numeric 19,2  √  null Y coordinate
stoparea y numeric 19,2  √  null Y coordinate
accesspoint latitude numeric 19,16  √  null Latitude
facility latitude numeric 19,16  √  null Latitude
stoparea latitude numeric 19,16  √  null Latitude
accesspoint longitude numeric 19,16  √  null Longitude
facility longitude numeric 19,16  √  null Longitude
stoparea longitude numeric 19,16  √  null Longitude
vehiclejourneyatstop arrivaltime time 15,6  √  null Arrival time
timeslot beginningslottime time 15,6  √  null Beginning slot time
accesslink defaultduration time 15,6  √  null Default duration to cross this link
connectionlink defaultduration time 15,6  √  null average duration of travel
vehiclejourneyatstop departuretime time 15,6  √  null Departure time
vehiclejourneyatstop elapseduration time 15,6  √  null elapse duration
timeslot endslottime time 15,6  √  null End slot time
timeslot firstdeparturetimeinslot time 15,6  √  null First departure time in slot
accesslink frequenttravellerduration time 15,6  √  null Duration of travel for frequent travellers
connectionlink frequenttravellerduration time 15,6  √  null duration of travel for frequent traveller
vehiclejourneyatstop headwayfrequency time 15,6  √  null headway frequency
timeslot lastdeparturetimeinslot time 15,6  √  null Last departure time in slot
accesslink mobilityrestrictedtravellerduration time 15,6  √  null Duration of travel for mobility restricted travellers
connectionlink mobilityrestrictedtravellerduration time 15,6  √  null duration of travel for mobiliy restricted traveller
accesslink occasionaltravellerduration time 15,6  √  null Duration of travel for occasional travellers
connectionlink occasionaltravellerduration time 15,6  √  null duration of travel for occasional traveler
vehiclejourneyatstop waitingtime time 15,6  √  null Waiting time
accesspoint closingtime timestamp 29,6  √  null Closing time
accesslink creationtime timestamp 29,6  √  null Creation date and time
accesspoint creationtime timestamp 29,6  √  null Creation date and time
company creationtime timestamp 29,6  √  null Creation date and time
connectionlink creationtime timestamp 29,6  √  null Creation date and time
facility creationtime timestamp 29,6  √  null Creation date and time
groupofline creationtime timestamp 29,6  √  null Creation date and time
journeypattern creationtime timestamp 29,6  √  null Creation date and time
line creationtime timestamp 29,6  √  null Creation date and time
ptlink creationtime timestamp 29,6  √  null Creation date and time
ptnetwork creationtime timestamp 29,6  √  null Creation date and time
route creationtime timestamp 29,6  √  null Creation date and time
stoparea creationtime timestamp 29,6  √  null Creation date and time
stoppoint creationtime timestamp 29,6  √  null Creation date and time
timetable creationtime timestamp 29,6  √  null Creation date and time
vehiclejourney creationtime timestamp 29,6  √  null Creation date and time
accesspoint openningtime timestamp 29,6  √  null Opening time
stoparea areatype varchar 255  √  null Type of Area : BoardingPosition, Quay, CommercialStopPoint, StopPlace or ITL)
vehiclejourneyatstop boardingalightingpossibility varchar 255  √  null boardingAlightingPossibility
company code varchar 255  √  null Zip code
accesslink comment varchar 255  √  null Comment
accesspoint comment varchar 255  √  null Comment
connectionlink comment varchar 255  √  null Comment
facility comment varchar 255  √  null Comment
groupofline comment varchar 255  √  null Comment
journeypattern comment varchar 255  √  null Comment
line comment varchar 255  √  null Comment
ptlink comment varchar 255  √  null Comment
ptnetwork comment varchar 255  √  null Comment
route comment varchar 255  √  null Comment
stoparea comment varchar 255  √  null Comment
timetable comment varchar 255  √  null Comment
vehiclejourney comment varchar 255  √  null Comment
vehiclejourneyatstop connectingserviceid varchar 255  √  null connectingServiceId
accesspoint containedin varchar 255  √  null Unused data
facility containedin varchar 255  √  null
accesspoint countrycode varchar 255  √  null Zip code
facility countrycode varchar 255  √  null Zip code
stoparea countrycode varchar 255  √  null Zip code
accesslink creatorid varchar 255  √  null Creator identification
accesspoint creatorid varchar 255  √  null Creator identification
company creatorid varchar 255  √  null Creator identification
connectionlink creatorid varchar 255  √  null Creator identification
facility creatorid varchar 255  √  null Creator identification
groupofline creatorid varchar 255  √  null Creator identification
journeypattern creatorid varchar 255  √  null Creator identification
line creatorid varchar 255  √  null Creator identification
ptlink creatorid varchar 255  √  null Creator identification
ptnetwork creatorid varchar 255  √  null Creator identification
route creatorid varchar 255  √  null Creator identification
stoparea creatorid varchar 255  √  null Creator identification
stoppoint creatorid varchar 255  √  null Creator identification
timeslot creatorid varchar 255  √  null Creator identification
timetable creatorid varchar 255  √  null Creator identification
vehiclejourney creatorid varchar 255  √  null Creator identification
facility description varchar 255  √  null Facility description
ptnetwork description varchar 255  √  null description
route direction varchar 255  √  null Direction : North, East, ...
company email varchar 255  √  null Email
vehiclejourney facility varchar 255  √  null facility
company fax varchar 255  √  null FAX number
accesslink linkorientation varchar 255  √  null Link orientation : accesspoint_to_stoparea or stoparea_to_accesspoint
accesslink linktype varchar 255  √  null Link type : Underground, Overground or Mixed
connectionlink linktype varchar 255  √  null Type (Underground,Overground or Mixed)
accesspoint longlattype varchar 255  √  null Model used for Longitude and Latitude (Standard, WGS84 or WGS92)
facility longlattype varchar 255  √  null Model used for Longitude and Latitude (Standard, WGS84 or WGS92)
stoparea longlattype varchar 255  √  null Model used for Longitude and Latitude (Standard, WGS84 or WGS92)
accesslink name varchar 255  √  null Name
accesspoint name varchar 255  √  null Name
company name varchar 255  √  null Name
connectionlink name varchar 255  √  null Name
facility name varchar 255  √  null Name
groupofline name varchar 255  √  null Name
journeypattern name varchar 255  √  null Name
line name varchar 255  √  null Name
ptlink name varchar 255  √  null Name
ptnetwork name varchar 255  √  null Name
route name varchar 255  √  null Name
stoparea name varchar 255  √  null Name
timeslot name varchar 255  √  null Name
stoparea nearesttopicname varchar 255  √  null Nearest topic name
line number varchar 255  √  null Number of the line (characters)
route number varchar 255  √  null Number
accesslink objectid varchar 255 Neptune identification
accesspoint objectid varchar 255 Neptune identification
company objectid varchar 255 Neptune identification
connectionlink objectid varchar 255 Neptune identification
facility objectid varchar 255 Neptune identification
groupofline objectid varchar 255 Neptune identification
journeypattern objectid varchar 255 Neptune identification
line objectid varchar 255 Neptune identification
ptlink objectid varchar 255 Neptune identification
ptnetwork objectid varchar 255 Neptune identification
route objectid varchar 255 Neptune identification
stoparea objectid varchar 255 Neptune identification
stoppoint objectid varchar 255 Neptune identification
timeslot objectid varchar 255 Neptune identification
timetable objectid varchar 255 Neptune identification
vehiclejourney objectid varchar 255 Neptune identification
company operatingdepartmentname varchar 255  √  null Operating department
company organizationalunit varchar 255  √  null Organizational Unit
company phone varchar 255  √  null Phone number
accesspoint projectiontype varchar 255  √  null Projection used for coordinates
facility projectiontype varchar 255  √  null Projection used for coordinates
stoparea projectiontype varchar 255  √  null Projection used for coordinates
vehiclejourney publishedjourneyidentifier varchar 255  √  null Identifier for travelers
vehiclejourney publishedjourneyname varchar 255  √  null Name for travelers
journeypattern publishedname varchar 255  √  null Public name for travelers
line publishedname varchar 255  √  null Public name for travelers
route publishedname varchar 255  √  null Published name
company registrationnumber varchar 255  √  null Registration number
journeypattern registrationnumber varchar 255  √  null Registration number
line registrationnumber varchar 255  √  null Registration number
ptnetwork registrationnumber varchar 255  √  null Registration unique number
stoparea registrationnumber varchar 255  √  null Registration number
company shortname varchar 255  √  null Short name
ptnetwork sourceidentifier varchar 255  √  null data producer identifier
ptnetwork sourcename varchar 255  √  null data producer name
vehiclejourney statusvalue varchar 255  √  null Service Status
accesspoint streetname varchar 255  √  null Address
facility streetname varchar 255  √  null Address
stoparea streetname varchar 255  √  null Address
vehiclejourney transportmode varchar 255  √  null Transport mode
line transportmodename varchar 255  √  null Transport Mode (Bus, Train, ...)
accesspoint type varchar 255  √  null Access Point Type : free description
vehiclejourney vehicletypeidentifier varchar 255  √  null Vehicle type
timetable version varchar 255  √  null version
route wayback varchar 255  √  null Orientation : A or R