Constraints

14 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
DQProcess_status_dqprocess_id_fkey
DQProcess_status.dqprocess_id
DQProcess.id
Cascade on delete
VerifyClientStatus_datos_distribuidoras_id_fkey
VerifyClientStatus.datos_distribuidoras_id
DatosDistribuidoras.id
Restrict delete
DatosDistribuidoras_client_division_id_fkey
DatosDistribuidoras.client_division_id
ClientDivision.id
Restrict delete
VerifyUbigeoStatus_datos_distribuidoras_id_fkey
VerifyUbigeoStatus.datos_distribuidoras_id
DatosDistribuidoras.id
Restrict delete
VerifyProductStatus_datos_distribuidoras_id_fkey
VerifyProductStatus.datos_distribuidoras_id
DatosDistribuidoras.id
Restrict delete
FileShippingStatus_datos_distribuidoras_id_fkey
FileShippingStatus.datos_distribuidoras_id
DatosDistribuidoras.id
Restrict delete
FileShippingStatus_global_file_shipping_failure_reason_id_fkey
FileShippingStatus.global_file_shipping_failure_reason_id
GlobalFileShippingFailureReason.id
Restrict delete
User_default_global_role_id_fkey
User.default_global_role
GlobalRole.role
Restrict delete
ClientDivision_client_id_fkey
ClientDivision.client_id
Client.id
Restrict delete
UserRole_user_id_fkey
UserRole.user_id
User.id
Restrict delete
UserRole_global_role_fkey
UserRole.global_role
GlobalRole.role
Restrict delete
ControlDayStatus_datos_distribuidoras_id_fkey
ControlDayStatus.datos_distribuidoras_id
DatosDistribuidoras.id
Restrict delete
VerifyUmStatus_datos_distribuidoras_id_fkey
VerifyUmStatus.datos_distribuidoras_id
DatosDistribuidoras.id
Restrict delete
VerifySkuStatus_datos_distribuidoras_id_fkey
VerifySkuStatus.datos_distribuidoras_id
DatosDistribuidoras.id
Restrict delete

Check Constraints

Table Constraint Name Constraint
FileShippingStatus consistent_is_ok ((((is_ok = true) AND (global_file_shipping_failure_reason_id IS NULL)) OR ((is_ok = false) AND (global_file_shipping_failure_reason_id IS NOT NULL))))