SchemaSpy Analysis of testdb.public - Constraints Generated by
SchemaSpy
19 Foreign Key Constraints:

Constraint Name Child Column Parent Column Delete Rule
com_tu_fk_loc_actual com_transport_unit.c_actual_location com_location.c_pk Restrict delete 
com_tu_fk_loc_target com_transport_unit.c_target_location com_location.c_pk Restrict delete 
com_tu_fk_tu_parent com_transport_unit.c_parent com_transport_unit.c_pk Restrict delete 
com_tu_fk_tut com_transport_unit.c_transport_unit_type com_transport_unit_type.c_pk Restrict delete 
fk6pn2579hr73ige890tnrtlids com_type_stacking_rule.c_transport_unit_type com_transport_unit_type.c_pk Restrict delete 
fk7hgjsbhte1esjljdnkmxpkk78 com_transport_unit_log.c_rev com_srv_revision.c_pk Restrict delete 
fk9wojgpvaignw39k200ha80eug com_type_stacking_rule.c_allowed_transport_unit_type com_transport_unit_type.c_pk Restrict delete 
fk_lg_acc com_location_group.c_account com_account.c_identifier Restrict delete 
fk_lg_lg_inlocker com_location_group.c_in_locker com_location_group.c_pk Restrict delete 
fk_lg_lg_outlocker com_location_group.c_out_locker com_location_group.c_pk Restrict delete 
fk_lg_lg_parent com_location_group.c_parent com_location_group.c_pk Restrict delete 
fk_loc_acc com_location.c_account com_account.c_identifier Restrict delete 
fk_loc_lg com_location.c_location_group com_location_group.c_pk Restrict delete 
fk_loc_lt com_location.c_location_type com_location_type.c_pk Restrict delete 
fk_locm_locpk com_location_message.c_location_id com_location.c_pk Restrict delete 
fk_locm_msgpk com_location_message.c_message_id com_message.c_pk Restrict delete 
fk_tu_error_pk com_unit_error.c_tu_id com_transport_unit.c_pk Restrict delete 
fkb1he5781gaupx0napfkoy09iy com_type_placing_rule.c_allowed_location_type com_location_type.c_pk Restrict delete 
fkexme0g9srxcxt8m3jv2101k1d com_type_placing_rule.c_tut_id com_transport_unit_type.c_pk Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected