Constraints

30 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
backup_role_user_id_fkey
backup_role.user_id
user.id
Cascade on delete
timestamp_state_state_type_id_fkey
timestamp_state.state_type_id
timestamp_state_type.id
Restrict delete
nomination_berth_berth_id_fkey
nomination_berth.berth_id
berth.id
Cascade on delete
nomination_berth_nomination_id_fkey
nomination_berth.nomination_id
nomination.id
Cascade on delete
vis_voyage_plan_rtz_state_fkey
vis_voyage_plan.rtz_state
vis_rtz_state.id
Restrict delete
berth_reservation_berth_reservation_type_id_fkey
berth_reservation.berth_reservation_type_id
berth_reservation_type.id
Restrict delete
berth_reservation_slot_reservation_id_fkey
berth_reservation.slot_reservation_id
slot_reservation.id
Cascade on delete
berth_reservation_berth_id_fkey
berth_reservation.berth_id
berth.id
Restrict delete
timestamp_definition_time_type_id_fkey
timestamp_definition.time_type_id
timestamp_time_type.id
Cascade on delete
timestamp_definition_state_id_fkey
timestamp_definition.state_id
timestamp_state.id
Cascade on delete
nomination_nomination_status_id_fkey
nomination.nomination_status_id
nomination_status.id
Restrict delete
api_key_bound_user_id_fkey
api_key.bound_user_id
user.id
Restrict delete
port_call_slot_reservation_id_fkey
port_call.slot_reservation_id
slot_reservation.id
Null on delete
port_call_imo_fkey
port_call.imo
vessel.imo
Restrict delete
role_permission_role_id_fkey
role_permission.role_id
role.id
Cascade on delete
role_permission_permission_id_fkey
role_permission.permission_id
permission.id
Cascade on delete
timestamp_port_call_id_fkey
timestamp.port_call_id
port_call.id
Restrict delete
timestamp_state_id_fkey
timestamp.state_id
timestamp_state.id
Restrict delete
timestamp_time_type_id_fkey
timestamp.time_type_id
timestamp_time_type.id
Restrict delete
slot_reservation_slot_reservation_status_id_fkey
slot_reservation.slot_reservation_status_id
slot_reservation_status.id
Restrict delete
slot_reservation_nomination_id_fkey
slot_reservation.nomination_id
nomination.id
Null on delete
slot_reservation_port_call_id_fkey
slot_reservation.port_call_id
port_call.id
Null on delete
slot_reservation_berth_id_fkey
slot_reservation.berth_id
berth.id
Restrict delete
public_role_id_fkey
user.role_id
role.id
Cascade on delete
user_registration_code_id_fkey
user.registration_code_id
registration_codes.id
Null on delete
pushnotificationtoken_user_id_fkey
push_notification_token.user_id
user.id
Cascade on delete
pinned_vessel_user_id_fkey
pinned_vessel.user_id
user.id
Cascade on delete
timestamp_api_key_weight_timestamp_state_id_fkey
timestamp_api_key_weight.timestamp_state_id
timestamp_state.id
Cascade on delete
timestamp_api_key_weight_api_key_id_fkey
timestamp_api_key_weight.api_key_id
api_key.id
Cascade on delete
timestamp_api_key_weight_timestamp_time_type_id_fkey
timestamp_api_key_weight.timestamp_time_type_id
timestamp_time_type.id
Cascade on delete

Check Constraints

Table Constraint Name Constraint