Constraints

29 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
payment_clinic_id_fkey
payment.clinic_id
clinic.id
Restrict delete
payment_created_by_fkey
payment.created_by
app_user.id
Restrict delete
session_app_user_id_fkey
session_app.user_id
app_user.id
Cascade on delete
session_app_clinic_id_fkey
session_app.clinic_id
clinic.id
Restrict delete
treatment_clinic_id_fkey
treatment.clinic_id
clinic.id
Restrict delete
treatment_staff_id_fkey
treatment.staff_id
staff.id
Restrict delete
treatment_patient_id_fkey
treatment.patient_id
patient.id
Cascade on delete
session_patient_id_fkey
session.patient_id
patient.id
Cascade on delete
session_appointment_fkey
session.appointment
appointment.id
Restrict delete
session_clinic_id_fkey
session.clinic_id
clinic.id
Restrict delete
session_payment_id_fkey
session.payment_id
payment.id
Null on delete
session_treatment_id_fkey
session.treatment_id
treatment.id
Restrict delete
session_clinic_service_id_fkey
session.clinic_service_id
clinic_service.id
Restrict delete
app_user_clinic_id_fkey
app_user.clinic_id
clinic.id
Restrict delete
estudio_clinic_id_fkey
estudio.clinic_id
clinic.id
Restrict delete
estudio_treatment_id_fkey
estudio.treatment_id
treatment.id
Cascade on delete
payment_gym_service_id_fkey
payment_gym.service_id
gym_service.id
Restrict delete
payment_gym_alumno_id_fkey
payment_gym.alumno_id
alumno_gym.id
Restrict delete
payment_gym_id_fkey
payment_gym.id
payment.id
Cascade on delete
note_treatment_id_fkey
note.treatment_id
treatment.id
Cascade on delete
appointment_session_id_fkey
appointment.session_id
session.id
Restrict delete
appointment_created_by_fkey
appointment.created_by
app_user.public_id
Restrict delete
appointment_med_staff_id_fkey
appointment.med_staff_id
staff.id
Restrict delete
staff_id_fkey
staff.id
app_user.id
Cascade on delete
alumno_gym_clinic_id_fkey
alumno_gym.clinic_id
clinic.id
Restrict delete
patient_obra_social_id_fkey
patient.obra_social_id
obra_social.id
Null on delete
patient_clinic_id_fkey
patient.clinic_id
clinic.id
Restrict delete
gym_service_clinic_id_fkey
gym_service.clinic_id
clinic.id
Restrict delete
clinic_service_clinic_id_fkey
clinic_service.clinic_id
clinic.id
Restrict delete

Check Constraints

Table Constraint Name Constraint
payment payment_amount_check ((amount > (0)::numeric))
session session_debt_check ((debt >= (0)::numeric))
obra_social must_be_positive ((surcharge > (0)::numeric))
staff staff_salario_check ((salario > (0)::numeric))
gym_service gym_service_price_check ((price > (0)::numeric))
clinic_service clinic_service_price_check ((price > (0)::numeric))