SchemaSpy Analysis of webco_4.1.0.public - Constraints Generated by
SchemaSpy
152 Foreign Key Constraints:
SourceForge.net

Constraint Name Child Column Parent Column
agreement_form_config_location_oid agreement_form_config.location_oid location.obj_oid
allocation_group_allocation_oid_fkey allocation_group.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_location_oid_fkey calendar_allocation_fields.location_oid location.obj_oid
dat_location_dat_oid_fkey dat_location.dat_oid default_allocation_times.obj_oid
dat_location_location_oid_fkey dat_location.location_oid location.obj_oid
dat_organization_dat_oid_fkey dat_organization.dat_oid default_allocation_times.obj_oid
dat_organization_org_oid_fkey dat_organization.org_oid organization.obj_oid
fk_taxrates_organization_oid tax_rate.organization_oid organization.obj_oid
fkallocation_freelancer_assigned_af_oid allocation_freelancer_assigned.allocation_freelancer_oid allocation_freelancer.obj_oid
fkallocation_freelancer_role_af_oid allocation_freelancer_role.allocation_freelancer_oid allocation_freelancer.obj_oid
fkallocation_original_agent_oid allocation.original_agent_oid person.obj_oid
fkallocation_staffing_allocation_oid allocation_staffing.allocation_oid allocation.obj_oid
fkallocation_staffing_role_oid allocation_staffing.role_oid role.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_location_authset_oid authset_location.authset_oid authset.obj_oid
fkauthset_location_location_oid authset_location.location_oid location.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
fkbiblio_record_oid bibliographic_record_helix.bibliographic_record_oid bibliographic_record.obj_oid
fkcalloc_agent_oid allocation.agent_oid person.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_location_oid allocation.location_oid location.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
fkcallocation_freelancer_allocation_oid allocation_freelancer.allocation_oid allocation.obj_oid
fkcallocation_freelancer_person_oid allocation_freelancer.person_oid person.obj_oid
fkcallocation_freelancer_role_oid allocation_freelancer_role.role_oid role.obj_oid
fkcallocation_reminder_interval_location allocation_reminder_interval.location_oid location.obj_oid
fkcauthentication_obj_oid authentication.obj_oid person.obj_oid
fkccirculation_policy_rtype_oid circulation_policy.rtype_oid resource_type.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
fkcfreelancer_person_location_location_oid freelancer_person_location.location_oid location.obj_oid
fkcfreelancer_person_location_person_oid freelancer_person_location.person_oid person.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
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 location.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
fkclocation_schedule_location location_schedule.location_oid location.obj_oid
fkclocation_schedule_node_location_schedule location_schedule_node.location_schedule_oid location_schedule.obj_oid
fkclocation_schedule_parent location_schedule.parent_oid location_schedule.obj_oid
fkcorg_admin_id organization.admin_id person.obj_oid
fkcpir_location_location_oid pir_person_location.location_oid location.obj_oid
fkcpir_location_person_oid pir_person_location.person_oid person.obj_oid
fkcpir_request_log_location_oid pir_request_log.location_oid location.obj_oid
fkcres_loc_res resource.location_resource_oid resource.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_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_loc_oid wco_log.loc_oid location.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_location_oid wco_station.location_oid location.obj_oid
fkextlocation_oid location_auto_email.location_oid location.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
fkloc_rtype location.rtype_oid resource_type.obj_oid
fkmail_event_alloc_oid mail_event.allocation_oid allocation.obj_oid
fkmail_event_alloc_reminder_interval_oid mail_event.allocation_reminder_interval_oid allocation_reminder_interval.obj_oid
fkorg_rtype organization.rtype_oid resource_type.obj_oid
fkperson_role_person_oid person_role.person_oid person.obj_oid
fkperson_role_role_oid person_role.role_oid role.obj_oid
fkpir_request_log_allocation_oid pir_request_log.allocation_oid allocation.obj_oid
fkpir_request_log_patron_oid pir_request_log.patron_oid person.obj_oid
fkpir_request_log_unsaved_allocation_oid pir_request_log.unsaved_allocation_oid allocation.obj_oid
fkres_cont_res resource.containing_resource_oid resource.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
location_org_oid_fkey location.org_oid organization.obj_oid
location_pir_pickup_option_location_oid_fkey location_pir_pickup_option.location_oid location.obj_oid
person_location_signature_location_oid_fkey person_location_signature.location_oid location.obj_oid
person_location_signature_person_oid_fkey person_location_signature.person_oid person.obj_oid
published_sched_sched_group_oid sched_published_shift.scheduling_group_oid sched_scheduling_group.obj_oid
resource_location_oid_fkey resource.location_oid location.obj_oid
resource_rtype_oid_fkey resource.rtype_oid resource_type.obj_oid
resource_schedule_scheduled_resource_oid_fkey resource_schedule.scheduled_resource_oid resource.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_published_shift_staffed_location_oid_fkey sched_published_shift.staffed_location_oid sched_staffed_location.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_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
sched_unpublished_shift_staffed_location_oid_fkey sched_unpublished_shift.staffed_location_oid sched_staffed_location.obj_oid
shift_staff_oid sched_published_shift.staff_oid sched_staff.obj_oid
turndown_allocation_oid_fkey turndown.allocation_oid allocation.obj_oid
turndown_patron_oid_fkey turndown.patron_oid person.obj_oid
unpub_sched_sched_group_oid sched_unpublished_shift.scheduling_group_oid sched_scheduling_group.obj_oid
unpub_shift_staff_oid sched_unpublished_shift.staff_oid sched_staff.obj_oid
unpub_shift_staffed_loc_oid sched_unpublished_shift.published_shift_oid sched_published_shift.obj_oid

Check Constraints:

Table Constraint Name Constraint
None detected