21 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| fk_locm_locpk |
|
|
Restrict delete | ||
| fk_locm_msgpk |
|
|
Restrict delete | ||
| fk7hgjsbhte1esjljdnkmxpkk78 |
|
|
Restrict delete | ||
| com_tu_fk_loc_target |
|
|
Restrict delete | ||
| com_tu_fk_tut |
|
|
Restrict delete | ||
| com_tu_fk_tu_parent |
|
|
Restrict delete | ||
| com_tu_fk_loc_actual |
|
|
Restrict delete | ||
| fk_tureservation_pk |
|
|
Restrict delete | ||
| fk_loc_lg |
|
|
Restrict delete | ||
| fk_loc_lt |
|
|
Restrict delete | ||
| fk_loc_acc |
|
|
Restrict delete | ||
| fk_lg_lg_parent |
|
|
Restrict delete | ||
| fk_lg_acc |
|
|
Restrict delete | ||
| fk_lg_lg_inlocker |
|
|
Restrict delete | ||
| fk_lg_lg_outlocker |
|
|
Restrict delete | ||
| fk6pn2579hr73ige890tnrtlids |
|
|
Restrict delete | ||
| fk9wojgpvaignw39k200ha80eug |
|
|
Restrict delete | ||
| fkpytlbvxglik830qw889qt5t6 |
|
|
Restrict delete | ||
| fkb1he5781gaupx0napfkoy09iy |
|
|
Restrict delete | ||
| fkexme0g9srxcxt8m3jv2101k1d |
|
|
Restrict delete | ||
| fk_tu_error_pk |
|
|
Restrict delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|---|---|
| com_transport_unit_log | com_transport_unit_log_c_weight_uom_check | ((c_weight_uom >= 0) AND (c_weight_uom <= 3)) |
| com_transport_unit | com_transport_unit_c_weight_uom_check | ((c_weight_uom >= 0) AND (c_weight_uom <= 3)) |
| com_location_group | com_location_group_c_group_state_in_check | ((c_group_state_in)::text = ANY ((ARRAY['AVAILABLE'::character varying, 'NOT_AVAILABLE'::character varying])::text[])) |
| com_location_group | com_location_group_c_group_state_out_check | ((c_group_state_out)::text = ANY ((ARRAY['AVAILABLE'::character varying, 'NOT_AVAILABLE'::character varying])::text[])) |