SchemaSpy Analysis of webco_4.4.1.public - Constraints Generated by
SchemaSpy
142 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_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_person_allocation_oid_fkey allocation_person.allocation_oid allocation.obj_oid
allocation_repeat_rule_allocation_oid_fkey allocation_repeat_rule.allocation_oid allocation.obj_oid
allocation_route_allocation_oid_fkey allocation_route.allocation_oid allocation.obj_oid
allocation_route_message_allocation_oid_fkey allocation_route_message.allocation_oid allocation.obj_oid
allocation_route_sink_oid_fkey allocation_route.sink_oid resource.obj_oid
allocation_route_source_oid_fkey allocation_route.source_oid resource.obj_oid
allocation_task_allocation_oid_fkey allocation_task.allocation_oid allocation.obj_oid
authorization_group_fkeys group_authorization.group_oid
group_authorization.person_oid
group_member.group_oid
group_member.person_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_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
email_template_message_type_oid_fkey email_template.message_type_oid message_type.obj_oid
fk_email_template_organization_oid email_template.organization_oid organization.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_authorization_authorization_oid authset_authorization.authorization_oid operator_authorization.obj_oid
fkauthset_authorization_authset_oid authset_authorization.authset_oid authset.obj_oid
fkauthset_checkout_center_authset_oid authset_checkout_center.authset_oid authset.obj_oid
fkauthset_checkout_center_checkout_center_oid authset_checkout_center.checkout_center_oid checkout_center.obj_oid
fkauthset_organization_oid authset.organization_oid organization.obj_oid
fkauthset_person_oid authset.person_oid person.obj_oid
fkauthset_role_oid authset.operator_role_oid operator_role.obj_oid
fkauto_email_message_type_oid auto_email.message_type_oid message_type.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
fkcalloc_person_person_oid allocation_person.person_oid person.obj_oid
fkcauthentication_obj_oid authentication.obj_oid person.obj_oid
fkccheckout_center_schedule_cehckout_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
fkcgroup_member_group_oid group_member.group_oid wco_group.obj_oid
fkcgroup_member_person_oid group_member.person_oid person.obj_oid
fkcheckout_center_auto_email_auto_email_oid checkout_center_auto_email.auto_email_oid auto_email.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
fkcpir_checkout_center_checkout_center_oid pir_person_checkout_center.checkout_center_oid checkout_center.obj_oid
fkcpir_checkout_center_person_oid pir_person_checkout_center.person_oid person.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_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_open_group_oid resource_type.open_group_oid wco_group.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_facility_oid wco_group.facility_oid resource.obj_oid
fkcwco_group_instructor_oid wco_group.instructor_oid person.obj_oid
fkcwco_group_organization_oid wco_group.organization_oid organization.obj_oid
fkcwco_group_teaching_assistant_oid wco_group.teaching_assistant_oid person.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
fkextcheckout_cernter_oid checkout_center_auto_email.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_rule_schedule_message_type_oid scheduled_message_rule.scheduled_message_type_oid scheduled_message_type.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_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
group_authorization_group_oid_fkey group_authorization.group_oid wco_group.obj_oid
group_authorization_person_oid_fkey group_authorization.person_oid person.obj_oid
group_authorization_rtype_oid_fkey group_authorization.rtype_oid resource_type.obj_oid
group_resource_type_group_oid_fkey group_resource_type.group_oid wco_group.obj_oid
group_resource_type_rtype_oid_fkey group_resource_type.rtype_oid resource_type.obj_oid
group_set_member_group_oid_fkey group_set_member.group_oid wco_group.obj_oid
group_set_member_group_set_oid_fkey group_set_member.group_set_oid group_set.obj_oid
inventory_event_agent_oid_fkey inventory_event.agent_oid person.obj_oid
inventory_event_resource_oid_fkey inventory_event.resource_oid resource.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
message_type_entity_message_type_oid_fkey message_type_entity.message_type_oid message_type.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_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
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