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 |
|
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 |