41 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| fk_trip_id_creator |
|
|
Restrict delete | ||
| fk_trip_id_car |
|
|
Restrict delete | ||
| fk_trip_id_updater |
|
|
Restrict delete | ||
| fk_trip_id_tenant |
|
|
Restrict delete | ||
| fk_trip_user_id_updater |
|
|
Restrict delete | ||
| fk_trip_user_id_tripusertype |
|
|
Restrict delete | ||
| fk_trip_user_id_creator |
|
|
Restrict delete | ||
| fk_trip_user_id_user |
|
|
Restrict delete | ||
| fk_trip_user_id_tenant |
|
|
Restrict delete | ||
| fk_trip_user_id_trip |
|
|
Restrict delete | ||
| fk_carmodel_id_manufacturer |
|
|
Restrict delete | ||
| fk_absencetype_id_updater |
|
|
Restrict delete | ||
| fk_absencetype_id_creator |
|
|
Restrict delete | ||
| fk_mileage_id_car |
|
|
Restrict delete | ||
| fk_mileage_id_mileagetype |
|
|
Restrict delete | ||
| fk_mileage_id_updater |
|
|
Restrict delete | ||
| fk_mileage_id_tenant |
|
|
Restrict delete | ||
| fk_mileage_id_creator |
|
|
Restrict delete | ||
| fk_car_registration_id_tenant |
|
|
Restrict delete | ||
| fk_car_registration_id_updater |
|
|
Restrict delete | ||
| fk_car_registration_id_creator |
|
|
Restrict delete | ||
| fk_car_registration_id_car |
|
|
Restrict delete | ||
| fk_staff_contract_id_jobtitle |
|
|
Restrict delete | ||
| fk_staff_contract_id_tenant |
|
|
Restrict delete | ||
| fk_staff_contract_id_updater |
|
|
Restrict delete | ||
| fk_staff_contract_id_staff |
|
|
Restrict delete | ||
| fk_staff_contract_id_creator |
|
|
Restrict delete | ||
| fk_car_id_tenant |
|
|
Restrict delete | ||
| fk_car_id_creator |
|
|
Restrict delete | ||
| fk_car_id_carmodel |
|
|
Restrict delete | ||
| fk_car_id_updater |
|
|
Restrict delete | ||
| fk_tripusertype_id_accountingtype |
|
|
Restrict delete | ||
| fk_staff_id_updater |
|
|
Restrict delete | ||
| fk_staff_id_creator |
|
|
Restrict delete | ||
| fk_staff_id_tenant |
|
|
Restrict delete | ||
| fk_staff_id_user |
|
|
Restrict delete | ||
| fk_absence_id_approvaltype |
|
|
Restrict delete | ||
| fk_absence_id_creator |
|
|
Restrict delete | ||
| fk_absence_id_user |
|
|
Restrict delete | ||
| fk_absence_id_absencetype |
|
|
Restrict delete | ||
| fk_absence_id_updater |
|
|
Restrict delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|---|---|
| trip | c_trip_stop_after_start | ((started_at < stopped_at)) |
| trip | c_trip_stopkm_after_startkm | ((km_start <= km_stop)) |
| trip_user | c_trip_user_stop_after_start | ((started_at < stopped_at)) |
| trip_user | c_trip_user_stopkm_after_startkm | ((km_start <= km_stop)) |
| car_registration | c_car_registration_to_after_from | ((valid_from < valid_to)) |
| staff_contract | c_staff_contract_to_after_from | ((valid_from < valid_to)) |
| absence | c_absence_stopped_after_started | ((started_at < stopped_at)) |