SchemaSpy Analysis of webco_5.0.public - Constraints Generated by
SchemaSpy
170 Foreign Key Constraints:
SourceForge.net

Constraint Name Child Column Parent Column
agreement_form_config_checkout_center_oid agreement_form_config.checkout_center_oid checkout_center.obj_oid
allocation_accompanying_person_allocation_oid_fkey allocation_accompanying_person.allocation_oid allocation.obj_oid
allocation_accompanying_person_person_oid_fkey allocation_accompanying_person.person_oid person.obj_oid
allocation_copy_of_fkey allocation.copy_of allocation.obj_oid
allocation_group_allocation_oid_fkey allocation_group.allocation_oid allocation.obj_oid
allocation_item_building_pass_allocation_oid_fkey allocation_item_building_pass.allocation_oid allocation.obj_oid
allocation_repeat_rule_allocation_oid_fkey allocation_repeat_rule.allocation_oid allocation.obj_oid
calendar_allocation_fields_checkout_center_oid_fkey calendar_allocation_fields.checkout_center_oid checkout_center.obj_oid
checkout_center_custom_agreement_form_oid_fkey checkout_center.custom_agreement_form_oid agreement_form_config.obj_oid
checkout_center_default_task_profile_checkout_center_oid_fkey checkout_center_default_task_profile.checkout_center_oid checkout_center.obj_oid
checkout_center_default_task_profile_task_profile_oid_fkey checkout_center_default_task_profile.task_profile_oid task_profile.obj_oid
checkout_center_email_template_set_oid_fkey checkout_center.email_template_set_oid email_template_set.obj_oid
checkout_center_org_oid_fkey checkout_center.org_oid organization.obj_oid
checkout_center_pir_pickup_option_checkout_center_oid_fkey checkout_center_pir_pickup_option.checkout_center_oid checkout_center.obj_oid
custom_property_booleans_custom_property_oid_fkey custom_property_booleans.custom_property_oid custom_property.obj_oid
custom_property_integers_custom_property_oid_fkey custom_property_integers.custom_property_oid custom_property.obj_oid
custom_property_money_custom_property_oid_fkey custom_property_money.custom_property_oid custom_property.obj_oid
custom_property_strings_custom_property_oid_fkey custom_property_strings.custom_property_oid custom_property.obj_oid
custom_property_timestamps_custom_property_oid_fkey custom_property_timestamps.custom_property_oid custom_property.obj_oid
email_template_message_type_oid_fkey email_template.message_type_oid message_type.obj_oid
email_template_organization_oid_fkey email_template.organization_oid organization.obj_oid
email_template_set_organization_oid_fkey email_template_set.organization_oid organization.obj_oid
email_template_set_template_email_template_oid_fkey email_template_set_template.email_template_oid email_template.obj_oid
email_template_set_template_email_template_set_oid_fkey email_template_set_template.email_template_set_oid email_template_set.obj_oid
email_template_set_template_message_type_oid_fkey email_template_set_template.message_type_oid message_type.obj_oid
fk_taxrates_organization_oid tax_rate.organization_oid organization.obj_oid
fkallocation_original_agent_oid allocation.original_agent_oid person.obj_oid
fkapp_default_loc_oid wco_application.default_checkout_center_oid checkout_center.obj_oid
fkapp_default_org_oid wco_application.default_org_oid organization.obj_oid
fkauthset_path_head_oid authset_path.head_oid authset.obj_oid
fkauthset_path_tail_oid authset_path.tail_oid authset.obj_oid
fkauto_email_message_type_oid auto_email.message_type_oid message_type.obj_oid
fkc_section_member_member_oid section_member.member_oid person.obj_oid
fkc_section_member_section_oid section_member.section_oid section.obj_oid
fkcalloc_agent_oid allocation.agent_oid person.obj_oid
fkcalloc_checkout_center_oid allocation.checkout_center_oid checkout_center.obj_oid
fkcalloc_contact_person allocation.contact_person person.obj_oid
fkcalloc_deliver_to_oid allocation.deliver_to_oid resource.obj_oid
fkcalloc_group_rule_oid allocation_group.rule_oid allocation_repeat_rule.obj_oid
fkcalloc_group_src_alloc_oid allocation_group.source_allocation_oid allocation.obj_oid
fkcalloc_log_alloc_oid allocation_log.allocation_oid allocation.obj_oid
fkcalloc_patron_oid allocation.patron_oid person.obj_oid
fkcalloc_payee_oid allocation.payee_oid person.obj_oid
fkcalloc_paying_department_oid allocation.paying_department_oid department.obj_oid
fkcapability_authorization_authorization_oid person_role_capability.system_capability_oid system_capability.obj_oid
fkcapability_authorization_capability_oid person_role_capability.person_role_oid person_role.obj_oid
fkcapability_checkout_center_capability_oid person_role_checkout_center.person_role_oid person_role.obj_oid
fkcapability_checkout_center_checkout_center_oid person_role_checkout_center.checkout_center_oid checkout_center.obj_oid
fkcapability_organization_oid person_role.organization_oid organization.obj_oid
fkcapability_person_oid person_role.person_oid person.obj_oid
fkcapability_role_oid person_role.system_role_oid system_role.obj_oid
fkcauthentication_obj_oid authentication.obj_oid person.obj_oid
fkcauthset_delegation_authset_oid authset_delegation.authset_oid authset.obj_oid
fkcauthset_delegation_org_oid authset_delegation.org_oid organization.obj_oid
fkccheckout_center_schedule_checkout_center checkout_center_schedule.checkout_center_oid checkout_center.obj_oid
fkccheckout_center_schedule_parent checkout_center_schedule.parent_oid checkout_center_schedule.obj_oid
fkcchekout_center_schedule_node_checkout_center_schedule checkout_center_schedule_node.checkout_center_schedule_oid checkout_center_schedule.obj_oid
fkcdepartment_billing_contact_oid department.billing_contact_oid person.obj_oid
fkcdepartment_code_department_oid department_code.department_oid department.obj_oid
fkcdepartment_oid account_code.department_oid department.obj_oid
fkcheckout_center_auto_email_auto_email_oid entity_auto_email.auto_email_oid auto_email.obj_oid
fkchold_cc_oid hold.checkout_center_oid checkout_center.obj_oid
fkchold_invoice_oid hold.invoice_oid invoice.obj_oid
fkchold_organization_oid hold.organization_oid organization.obj_oid
fkchold_person_oid hold.person_oid person.obj_oid
fkcinvoice_alloc_oid invoice.allocation_oid allocation.obj_oid
fkcinvoice_cc_oid invoice.cc_oid checkout_center.obj_oid
fkcinvoice_created_by invoice.created_by person.obj_oid
fkcinvoice_modified_by invoice.modified_by person.obj_oid
fkcinvoice_org_oid invoice.org_oid organization.obj_oid
fkcinvoice_paying_dept_oid invoice.paying_dept_oid department.obj_oid
fkcinvoice_person_oid invoice.person_oid person.obj_oid
fkcinvoice_real_payee invoice.real_payee person.obj_oid
fkcorg_admin_id organization.admin_id person.obj_oid
fkcpatron_class_oid allocation.patron_class_oid patron_class.obj_oid
fkcres_department resource.assigned_department_oid department.obj_oid
fkcres_loc_res resource.location_resource_oid resource.obj_oid
fkcres_person resource.assigned_person_oid person.obj_oid
fkcresource_schedule_alloc_oid resource_schedule.allocation_oid allocation.obj_oid
fkcresource_schedule_proposed_resource_oid resource_schedule.proposed_resource_oid resource.obj_oid
fkcresource_schedule_return_agent_oid resource_schedule.return_agent_oid person.obj_oid
fkcresource_schedule_scheduled_resource_oid resource_schedule.scheduled_resource_oid resource.obj_oid
fkcresource_type_org_oid resource_type.org_oid organization.obj_oid
fkcticket_log_agent_oid ticket_log.agent_oid person.obj_oid
fkcticket_log_ticket_oid ticket_log.ticket_oid ticket.obj_oid
fkcwco_group_contact_oid wco_group.contact_oid person.obj_oid
fkcwco_group_organization_oid wco_group.organization_oid organization.obj_oid
fkcwco_log_agent_oid wco_log.agent_oid person.obj_oid
fkcwco_log_cc_oid wco_log.checkout_center_oid checkout_center.obj_oid
fkcwco_log_org_oid wco_log.org_oid organization.obj_oid
fkcwco_log_reps_agent_oid wco_log.responsible_agent_oid person.obj_oid
fkcwco_station_checkout_center_oid wco_station.checkout_center_oid checkout_center.obj_oid
fkfile_attachment_upload_person_oid file_attachment.upload_person_oid person.obj_oid
fkholding_bibliographic_record holding.bibliographic_record_oid bibliographic_record.obj_oid
fkholding_resource holding.resource_oid resource.obj_oid
fkinv_line_created_by invoice_line.created_by person.obj_oid
fkinv_line_modified_by invoice_line.modified_by person.obj_oid
fkinv_line_res invoice_line.resource_oid resource.obj_oid
fkpatron_class_oid circulation_policy.patron_class_oid patron_class.obj_oid
fkres_cont_res resource.containing_resource_oid resource.obj_oid
fkscheduled_message_type_message_type_oid scheduled_message_type.message_type_oid message_type.obj_oid
fksubscription_notification_subscription subscription_contact.subscription_oid subscription.obj_oid
fksubscription_person_oid subscription.person_oid person.obj_oid
fkticket_agent ticket.agent_oid person.obj_oid
fkticket_location ticket.location_oid resource.obj_oid
fkticket_patron ticket.patron_oid person.obj_oid
fkticket_res ticket.resource_oid resource.obj_oid
fkticket_responsible_op ticket.responsible_op_oid person.obj_oid
fkticket_vendor ticket.vendor_oid person.obj_oid
inventory_item_inventoried_assigned_department_oid_fkey inventory_item.inventoried_assigned_department_oid department.obj_oid
inventory_item_inventoried_assigned_person_oid_fkey inventory_item.inventoried_assigned_person_oid person.obj_oid
inventory_item_inventoried_home_location_oid_fkey inventory_item.inventoried_home_location_oid resource.obj_oid
inventory_item_inventory_oid_fkey inventory_item.inventory_oid inventory.obj_oid
inventory_item_resource_oid_fkey inventory_item.resource_oid resource.obj_oid
inventory_item_scanning_agent_oid_fkey inventory_item.scanning_agent_oid person.obj_oid
inventory_note_agent_oid_fkey inventory_note.agent_oid person.obj_oid
inventory_note_inventory_oid_fkey inventory_note.inventory_oid inventory.obj_oid
inventory_note_parent_note_oid_fkey inventory_note.parent_note_oid inventory_note.obj_oid
inventory_note_resource_oid_fkey inventory_note.resource_oid resource.obj_oid
inventory_organization_oid_fkey inventory.organization_oid organization.obj_oid
inventory_selector_checkout_center_oid_fkey inventory_selector.checkout_center_oid checkout_center.obj_oid
inventory_selector_home_location_oid_fkey inventory_selector.home_location_oid resource.obj_oid
inventory_selector_inventory_oid_fkey inventory_selector.inventory_oid inventory.obj_oid
inventory_selector_resource_oid_fkey inventory_selector.resource_oid resource.obj_oid
inventory_selector_resource_type_oid_fkey inventory_selector.resource_type_oid resource_type.obj_oid
invoice_line_invoice_oid_fkey invoice_line.invoice_oid invoice.obj_oid
invoice_line_tax_rate_invoice_line_oid_fkey invoice_line_tax_rate.invoice_line_oid invoice_line.obj_oid
invoice_line_tax_rate_tax_rate_oid_fkey invoice_line_tax_rate.tax_rate_oid tax_rate.obj_oid
invoice_tax_rate_invoice_oid_fkey invoice_tax_rate.invoice_oid invoice.obj_oid
invoice_tax_rate_tax_rate_oid_fkey invoice_tax_rate.tax_rate_oid tax_rate.obj_oid
invoices_pending_export_invoice_oid_fkey invoices_pending_export.invoice_oid invoice.obj_oid
ldap_rule_ldap_profile_oid_fkey ldap_rule.ldap_profile_oid ldap_profile.obj_oid
ldap_rule_patron_class_oid_fkey ldap_rule.patron_class_oid patron_class.obj_oid
organization_email_template_set_oid_fkey organization.email_template_set_oid email_template_set.obj_oid
person_checkout_center_signature_checkout_center_oid_fkey person_checkout_center_signature.checkout_center_oid checkout_center.obj_oid
person_checkout_center_signature_person_oid_fkey person_checkout_center_signature.person_oid person.obj_oid
resource_checkout_center_oid_fkey resource.checkout_center_oid checkout_center.obj_oid
resource_rtype_oid_fkey resource.rtype_oid resource_type.obj_oid
resource_type_certification_person_oid_fkey resource_type_certification.person_oid person.obj_oid
resource_type_certification_resource_type_oid_fkey resource_type_certification.resource_type_oid resource_type.obj_oid
resource_type_fallback_fallback_oid_fkey resource_type_fallback.fallback_oid resource_type.obj_oid
resource_type_fallback_type_oid_fkey resource_type_fallback.type_oid resource_type.obj_oid
sched_scheduling_group_member_scheduling_group_oid_fkey sched_scheduling_group_member.scheduling_group_oid sched_scheduling_group.obj_oid
sched_scheduling_group_member_staff_oid_fkey sched_scheduling_group_member.staff_oid sched_staff.obj_oid
sched_scheduling_group_staffed_location_oid_fkey sched_scheduling_group.staffed_location_oid sched_staffed_location.obj_oid
sched_shift_staffed_location_oid_fkey sched_shift.staffed_location_oid sched_staffed_location.obj_oid
sched_staff_availability_person_oid_fkey sched_staff_availability.person_oid person.obj_oid
sched_staff_person_oid_fkey sched_staff.person_oid person.obj_oid
sched_staff_staffed_location_oid_fkey sched_staff.staffed_location_oid sched_staffed_location.obj_oid
sched_staffed_location_org_oid_fkey sched_staffed_location.org_oid organization.obj_oid
sched_staffing_limit_staff_oid_fkey sched_staffing_limit.staff_oid sched_staff.obj_oid
staff_assignment_sched_group_oid sched_staff_assignment.scheduling_group_oid sched_scheduling_group.obj_oid
staff_assignment_shift_oid sched_staff_assignment.shift_oid sched_shift.obj_oid
staff_assignment_staff_oid sched_staff_assignment.staff_oid sched_staff.obj_oid
staff_assignment_unppublished_sched_group_oid sched_staff_assignment.unpublished_scheduling_group_oid sched_scheduling_group.obj_oid
staff_assignment_unpub_staff_oid sched_staff_assignment.unpublished_staff_oid sched_staff.obj_oid
system_role_cap_auth system_role_capability.system_capability_oid system_capability.obj_oid
system_role_cap_role system_role_capability.system_role_oid system_role.obj_oid
task_allocation_oid_fkey task.allocation_oid allocation.obj_oid
task_organization_oid_fkey task.organization_oid organization.obj_oid
task_person_person_oid_fkey task_person.person_oid person.obj_oid
task_person_task_oid_fkey task_person.task_oid task.obj_oid
task_profile_organization_oid_fkey task_profile.organization_oid organization.obj_oid
task_profile_task_type_task_profile_oid_fkey task_profile_task_type.task_profile_oid task_profile.obj_oid
task_profile_task_type_task_type_oid_fkey task_profile_task_type.task_type_oid task_type.obj_oid
task_task_type_oid_fkey task.task_type_oid task_type.obj_oid
task_type_organization_oid_fkey task_type.organization_oid organization.obj_oid
turndown_allocation_oid_fkey turndown.allocation_oid allocation.obj_oid
turndown_checkout_center_oid_fkey turndown.checkout_center_oid checkout_center.obj_oid
turndown_patron_oid_fkey turndown.patron_oid person.obj_oid

Check Constraints:

Table Constraint Name Constraint
None detected