Constraints

17 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
FK_9d705fc89dbd1f6e3278f1dc6e3
route.agency_id
agency.id
Restrict delete
FK_fde3bb4aa31c5c155daf2a0b2e4
trip.unit_id
unit.id
Restrict delete
FK_d14b8e00cec02139f3cf9d86ad8
trip.calendar_id
calendar.id
Restrict delete
FK_7403b82a4b74cc97d12e3c06fa4
trip.route_id
route.id
Restrict delete
FK_fa24178bb7c49eab35e38fd3da3
unit.stop_id
stop.id
Restrict delete
FK_27680dfb45ddb580bf061ca8d15
unit.location_log_id
location_log.id
Restrict delete
FK_e39b008f7e49680470837aed94e
unit.driver_id
driver.id
Restrict delete
FK_d785e5e94fe935532e8fe77f541
location_log.unit_id
unit.id
Restrict delete
FK_732fa4b746b5fd36d24e72576e7
driver.user_id
user.id
Restrict delete
FK_feeef086ecf7a6228e796b0ddb8
route_stop_link.stop_id
stop.id
Restrict delete
FK_f95edb10f5a768e0daefe050920
route_stop_link.route_id
route.id
Restrict delete
FK_38258ee3c8faf7161ead2fe7d7e
stop_time.trip_id
trip.id
Restrict delete
FK_3659d774760d54d8cb8216533c6
stop_time.stop_id
stop.id
Restrict delete
FK_3cb53b18d5c552431839f7bb023
user_role_link.role_id
role.id
Restrict delete
FK_70100cf400e9257ce5cfe7d221e
user_role_link.user_id
user.id
Restrict delete
FK_60070a9927cef9f3987b6fe174e
role_permission_link.permission_id
permission.id
Restrict delete
FK_f2e23da3efc50030b43a3014a10
role_permission_link.role_id
role.id
Restrict delete

Check Constraints

Table Constraint Name Constraint
spatial_ref_sys spatial_ref_sys_srid_check (((srid > 0) AND (srid <= 998999)))