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