SchemaSpy Analysis of chouette_v17.chouette - ColumnsCHOUETTE | Generated by SchemaSpy |
Generated by SchemaSpy on lun. nov. 07 16:59 CET 2011 |
| ||||||
|
chouette_v17.chouette contains 260 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default | Comments |
---|---|---|---|---|---|---|---|
company | objectversion | int4 | 10 | √ | 1 | Version of this object | |
connectionlink | objectversion | int4 | 10 | √ | 1 | Version of this object | |
journeypattern | objectversion | int4 | 10 | √ | 1 | Version of this object | |
line | objectversion | int4 | 10 | √ | 1 | Version of this object | |
timeslot | objectversion | int4 | 10 | √ | 1 | Version of this object | |
vehiclejourneyatstop | isarrival | bool | 1 | √ | false | Last stop of the vehicle journey | |
vehiclejourneyatstop | isdeparture | bool | 1 | √ | false | First stop of the vehicle journey | |
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 | |
accesslink | accesspointid | int8 | 19 | √ | null | AccessPoint reference | |
stoparea | areatype | varchar | 255 | √ | null | Type of Area : BoardingPosition, Quay, CommercialStopPoint, StopPlace or ITL) | |
connectionlink | arrivalid | int8 | 19 | √ | null | End stoparea internal id | |
vehiclejourneyatstop | arrivaltime | time | 15,6 | √ | null | Arrival time | |
timeslot | beginningslottime | time | 15,6 | √ | null | Beginning slot time | |
vehiclejourneyatstop | boardingalightingpossibility | varchar | 255 | √ | null | boardingAlightingPossibility | |
stopareastoparea | childid | int8 | 19 | Child reference in hierarchy | |||
facilityfeature | choicecode | int4 | 10 | √ | null | encoded value for facility | |
accesspoint | closingtime | timestamp | 29,6 | √ | null | Closing time | |
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 | |
line | companyid | int8 | 19 | √ | null | Company reference | |
vehiclejourney | companyid | int8 | 19 | √ | null | Company foreign key | |
vehiclejourneyatstop | connectingserviceid | varchar | 255 | √ | null | connectingServiceId | |
facility | connectionlinkid | int8 | 19 | √ | null | ConnectionLink reference | |
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 | 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 | |
timeslot | creationtime | date | 13 | √ | 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 | |
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 | |
timetable_date | date | date | 13 | √ | null | calendar date | |
accesslink | defaultduration | time | 15,6 | √ | null | Default duration to cross this link | |
connectionlink | defaultduration | time | 15,6 | √ | null | average duration of travel | |
connectionlink | departureid | int8 | 19 | √ | null | Start stoparea internal id | |
vehiclejourneyatstop | departuretime | time | 15,6 | √ | null | Departure time | |
facility | description | varchar | 255 | √ | null | Facility description | |
ptnetwork | description | varchar | 255 | √ | null | description | |
route | direction | varchar | 255 | √ | null | Direction : North, East, ... | |
vehiclejourneyatstop | elapseduration | time | 15,6 | √ | null | elapse duration | |
company | varchar | 255 | √ | null | |||
ptlink | endoflinkid | int8 | 19 | √ | null | End StopPoint reference | |
timeslot | endslottime | time | 15,6 | √ | null | End slot time | |
vehiclejourney | facility | varchar | 255 | √ | null | facility | |
facilityfeature | facilityid | int8 | 19 | Facility reference | |||
stoparea | farecode | int4 | 10 | √ | null | Fare code | |
company | fax | varchar | 255 | √ | null | FAX number | |
timeslot | firstdeparturetimeinslot | time | 15,6 | √ | null | First departure time in slot | |
facility | freeaccess | bool | 1 | √ | null | Indicate if facility is on free (true) or restricted(false) access | |
accesslink | frequenttravellerduration | time | 15,6 | √ | null | Duration of travel for frequent travellers | |
connectionlink | frequenttravellerduration | time | 15,6 | √ | null | duration of travel for frequent traveller | |
groupofline_line | groupoflineid | int8 | 19 | GroupOfLine reference | |||
line | groupoflineid | int8 | 19 | √ | null | GroupOfLine reference | |
vehiclejourneyatstop | headwayfrequency | time | 15,6 | √ | null | headway frequency | |
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 | |
journeypattern_stoppoint | journeypatternid | int8 | 19 | JourneyPattern Reference | |||
vehiclejourney | journeypatternid | int8 | 19 | √ | null | JourneyPattern foreign key | |
timeslot | lastdeparturetimeinslot | time | 15,6 | √ | null | Last departure time in slot | |
accesspoint | latitude | numeric | 19,16 | √ | null | Latitude | |
facility | latitude | numeric | 19,16 | √ | null | Latitude | |
stoparea | latitude | numeric | 19,16 | √ | null | Latitude | |
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 | |
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 | |||
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 | |
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 | longitude | numeric | 19,16 | √ | null | Longitude | |
facility | longitude | numeric | 19,16 | √ | null | Longitude | |
stoparea | longitude | numeric | 19,16 | √ | null | Longitude | |
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 | 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 | 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 | 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 | |
vehiclejourney | number | int8 | 19 | √ | null | Number of the vehicle journey | |
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 | |||
accesslink | objectversion | int4 | 10 | √ | null | Version of this object | |
accesspoint | objectversion | int4 | 10 | √ | null | Version of this object | |
facility | objectversion | int4 | 10 | √ | null | Version of this object | |
groupofline | objectversion | int4 | 10 | √ | null | 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 | |
timetable | objectversion | int4 | 10 | √ | null | Version of this object | |
vehiclejourney | objectversion | int4 | 10 | √ | null | Version of this object | |
accesslink | occasionaltravellerduration | time | 15,6 | √ | null | Duration of travel for occasional travellers | |
connectionlink | occasionaltravellerduration | time | 15,6 | √ | null | duration of travel for occasional traveler | |
accesspoint | openningtime | timestamp | 29,6 | √ | null | Opening time | |
company | operatingdepartmentname | varchar | 255 | √ | null | Operating department | |
route | oppositerouteid | int8 | 19 | √ | null | Opposite route reference | |
company | organizationalunit | varchar | 255 | √ | null | Organizational Unit | |
stoparea | parentid | int8 | 19 | √ | null | (deprecated) Main parent StopArea internal id for v1.6 compatibility | |
stopareastoparea | parentid | int8 | 19 | Parent reference in hierarchy | |||
timetable_period | periodend | date | 13 | √ | null | end date of period | |
timetable_period | periodstart | date | 13 | √ | null | start date of period | |
company | phone | varchar | 255 | √ | null | Phone number | |
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 | |||
vehiclejourneyatstop | position | int8 | 19 | √ | null | order in JourneyPattern | |
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 | |
line | ptnetworkid | int8 | 19 | √ | null | PTNetwork reference | |
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 | |
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 | |
company | shortname | varchar | 255 | √ | null | Short name | |
ptnetwork | sourceidentifier | varchar | 255 | √ | null | data producer identifier | |
ptnetwork | sourcename | varchar | 255 | √ | null | data producer name | |
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 | |
ptlink | startoflinkid | int8 | 19 | √ | null | Start StopPoint reference | |
vehiclejourney | statusvalue | varchar | 255 | √ | null | Service Status | |
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) | |||
accesspoint | streetname | varchar | 255 | √ | null | Address | |
facility | streetname | varchar | 255 | √ | null | Address | |
stoparea | streetname | varchar | 255 | √ | null | Address | |
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 | |||
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 | |
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) | |||
vehiclejourney | vehicletypeidentifier | varchar | 255 | √ | null | Vehicle type | |
timetable | version | varchar | 255 | √ | null | version | |
ptnetwork | versiondate | date | 13 | √ | null | PTNetwork version date | |
vehiclejourneyatstop | waitingtime | time | 15,6 | √ | null | Waiting time | |
route | wayback | varchar | 255 | √ | null | Orientation : A or R | |
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 |