SchemaSpy Analysis of chouette_v17.chouette - ConstraintsCHOUETTE Generated by
SchemaSpy
38 Foreign Key Constraints:
SourceForge.net

Constraint Name Child Column Parent Column Delete Rule
aclk_acpt_fkey accesslink.accesspointid accesspoint.id Cascade on delete 
aclk_area_fkey accesslink.stopareaid stoparea.id Cascade on delete 
area_parent_fkey stoparea.parentid stoparea.id Null on delete 
colk_endarea_fkey connectionlink.arrivalid stoparea.id Cascade on delete 
colk_startarea_fkey connectionlink.departureid stoparea.id Cascade on delete 
faci_area_fkey facility.stopareaid stoparea.id Cascade on delete 
faci_colk_fkey facility.connectionlinkid connectionlink.id Cascade on delete 
faci_line_fkey facility.lineid line.id Cascade on delete 
faci_stpt_fkey facility.stoppointid stoppoint.id Cascade on delete 
facility_feature_fkey facilityfeature.facilityid facility.id Cascade on delete 
groupofline_group_fkey groupofline_line.groupoflineid groupofline.id Cascade on delete 
groupofline_line_fkey groupofline_line.lineid line.id Cascade on delete 
jp_route_fkey journeypattern.routeid route.id Cascade on delete 
jpsp_jp_fkey journeypattern_stoppoint.journeypatternid journeypattern.id Cascade on delete 
jpsp_stoppoint_fkey journeypattern_stoppoint.stoppointid stoppoint.id Cascade on delete 
line_company_fkey line.companyid company.id Null on delete 
line_glines_fkey line.groupoflineid groupofline.id Null on delete 
line_ptnetwork_fkey line.ptnetworkid ptnetwork.id Null on delete 
ptlink_route_fkey ptlink.routeid route.id Cascade on delete 
ptlk_endstpt_fkey ptlink.endoflinkid stoppoint.id Restrict delete 
ptlk_startstpt_fkey ptlink.startoflinkid stoppoint.id Restrict delete 
route_line_fkey route.lineid line.id Cascade on delete 
routingconstraint_line_fkey routingconstraints_lines.lineid line.id Cascade on delete 
routingconstraint_stoparea_fkey routingconstraints_lines.stopareaid stoparea.id Cascade on delete 
stoparea_child_fkey stopareastoparea.childid stoparea.id Cascade on delete 
stoparea_parent_fkey stopareastoparea.parentid stoparea.id Cascade on delete 
stoppoint_area_fkey stoppoint.stopareaid stoparea.id Restrict delete 
stoppoint_route_fkey stoppoint.routeid route.id Cascade on delete 
tm_date_fkey timetable_date.timetableid timetable.id Cascade on delete 
tm_period_fkey timetable_period.timetableid timetable.id Cascade on delete 
vj_company_fkey vehiclejourney.companyid company.id Null on delete 
vj_jp_fkey vehiclejourney.journeypatternid journeypattern.id Cascade on delete 
vj_route_fkey vehiclejourney.routeid route.id Cascade on delete 
vj_timeslot_fkey vehiclejourney.timeslotid timeslot.id Null on delete 
vjas_sp_fkey vehiclejourneyatstop.stoppointid stoppoint.id Cascade on delete 
vjas_vj_fkey vehiclejourneyatstop.vehiclejourneyid vehiclejourney.id Cascade on delete 
vjtm_tm_fkey timetablevehiclejourney.timetableid timetable.id Cascade on delete 
vjtm_vj_fkey timetablevehiclejourney.vehiclejourneyid vehiclejourney.id Cascade on delete 

Check Constraints:

Table Constraint Name Constraint
None detected