SchemaSpy Analysis of oscar_bc - Constraints Generated by
SchemaSpy
27 Foreign Key Constraints:
SourceForge.net

Constraint Name Child Column Parent Column
ClientLink_ibfk_1 ClientLink.facilityId Facility.id
ClientLink_ibfk_2 ClientLink.clientId demographic.demographic_no
ClientLink_ibfk_3 ClientLink.linkProviderNo provider.provider_no
ClientLink_ibfk_4 ClientLink.unlinkProviderNo provider.provider_no
FK_intake_answer_element_intake_answer_validation intake_answer_element.intake_answer_validation_id intake_answer_validation.intake_answer_validation_id
FK_intake_answer_element_intake_node_template intake_answer_element.intake_node_template_id intake_node_template.intake_node_template_id
FK_intake_answer_intake intake_answer.intake_id intake.intake_id
FK_intake_answer_intake_node intake_answer.intake_node_id intake_node.intake_node_id
FK_intake_intake_node intake.intake_node_id intake_node.intake_node_id
FK_intake_node_intake_node intake_node.parent_intake_node_id intake_node.intake_node_id
FK_intake_node_intake_node_label intake_node.intake_node_label_id intake_node_label.intake_node_label_id
FK_intake_node_intake_node_template intake_node.intake_node_template_id intake_node_template.intake_node_template_id
FK_intake_node_template_intake_node_label intake_node_template.intake_node_label_id intake_node_label.intake_node_label_id
FK_intake_node_template_intake_node_type intake_node_template.intake_node_type_id intake_node_type.intake_node_type_id
FK_pcr_demographic program_client_restriction.demographic_no demographic.demographic_no
FK_pcr_program program_client_restriction.program_id program.id
FK_pcr_provider program_client_restriction.provider_no provider.provider_no
FK_room_facility room.facility_id Facility.id
HnrDataValidation_ibfk_1 HnrDataValidation.facilityId Facility.id
HnrDataValidation_ibfk_2 HnrDataValidation.clientId demographic.demographic_no
HnrDataValidation_ibfk_3 HnrDataValidation.validatorProviderNo provider.provider_no
IntegratorConsent_ibfk_1 IntegratorConsent.facilityId Facility.id
IntegratorConsent_ibfk_2 IntegratorConsent.demographicId demographic.demographic_no
IntegratorConsent_ibfk_3 IntegratorConsent.providerNo provider.provider_no
IntegratorConsentComplexExitInterview_ibfk_1 IntegratorConsentComplexExitInterview.facilityId Facility.id
IntegratorConsentComplexExitInterview_ibfk_2 IntegratorConsentComplexExitInterview.demographicId demographic.demographic_no
program_ibfk_1 program.facilityId Facility.id

Check Constraints:

Table Constraint Name Constraint
None detected