SchemaSpy Analysis of chouette_v17.chouetteCHOUETTE Generated by
SchemaSpy
Generated by SchemaSpy on lun. nov. 07 16:59 CET 2011
Database Type: PostgreSQL - 8.3.8 SourceForge.net


XML Representation
Insertion Order Deletion Order (for database loading/purging scripts)

Table Children Parents Columns Comments
accesslink 2 20 Access Link
accesspoint 1 22 Access point
company 2 14 company operating a public transport service
connectionlink 1 2 19 Connection link between 2 stopareas
facility 1 4 22 Facility
facilityfeature 1 2 Facility Features secondary table
groupofline 2 7 group of lines
groupofline_line 2 2 Lines affected to groupOfLines
journeypattern 2 1 10 Journey pattern
journeypattern_stoppoint 2 2 StopPoint on JourneyPattern cross reference
line 4 3 16 Public Transport Line
ptlink 3 11 Link between two successive stop points on a same route
ptnetwork 1 12 Public Transport Network
route 4 1 13 Route
routingconstraints_lines 2 2 Routing constraint applicable on lines
stoparea 9 1 20 StopArea
stopareastoparea 2 2 StopArea hierarchical graph
stoppoint 5 2 8 stop point on route
timeslot 1 10 time slot
timetable 3 8 Timetables
timetable_date 1 3 Applicable Calendar days for Timetable
timetable_period 1 4 Applicable Periods for Timetable
timetablevehiclejourney 2 2 Timetable on Vehicle journeys cross reference
vehiclejourney 2 4 17 Vehicle journey
vehiclejourneyatstop 2 12 Vehicle Journey at Stop
         
25 Tables     260  
0 Views     0