Table webco_4.7.public.person Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
obj_oid int8 19
allocation.agent_oid fkcalloc_agent_oid
allocation.contact_person fkcalloc_contact_person
allocation.original_agent_oid fkallocation_original_agent_oid
allocation.patron_oid fkcalloc_patron_oid
allocation.payee_oid fkcalloc_payee_oid
allocation_person.person_oid fkcalloc_person_person_oid
authentication.obj_oid fkcauthentication_obj_oid
department.billing_contact_oid fkcdepartment_billing_contact_oid
file_attachment.upload_person_oid fkfile_attachment_upload_person_oid
hold.person_oid fkchold_person_oid
inventory_item.inventoried_assigned_person_oid inventory_item_inventoried_assigned_person_oid_fkey
inventory_item.scanning_agent_oid inventory_item_scanning_agent_oid_fkey
inventory_note.agent_oid inventory_note_agent_oid_fkey
invoice.created_by fkcinvoice_created_by
invoice.modified_by fkcinvoice_modified_by
invoice.person_oid fkcinvoice_person_oid
invoice.real_payee fkcinvoice_real_payee
invoice_line.created_by fkinv_line_created_by
invoice_line.modified_by fkinv_line_modified_by
organization.admin_id fkcorg_admin_id
person_checkout_center_signature.person_oid person_checkout_center_signature_person_oid_fkey
person_role.person_oid fkcapability_person_oid
resource.assigned_person_oid fkcres_person
resource_schedule.return_agent_oid fkcresource_schedule_return_agent_oid
resource_type_certification.person_oid resource_type_certification_person_oid_fkey
sched_staff.person_oid sched_staff_person_oid_fkey
sched_staff_availability.person_oid sched_staff_availability_person_oid_fkey
section_member.member_oid fkc_section_member_member_oid
subscription.person_oid fksubscription_person_oid
ticket.agent_oid fkticket_agent
ticket.patron_oid fkticket_patron
ticket.responsible_op_oid fkticket_responsible_op
ticket.vendor_oid fkticket_vendor
ticket_log.agent_oid fkcticket_log_agent_oid
turndown.patron_oid turndown_patron_oid_fkey
wco_group.contact_oid fkcwco_group_contact_oid
wco_log.agent_oid fkcwco_log_agent_oid
wco_log.responsible_agent_oid fkcwco_log_reps_agent_oid
modified timestamptz 35,6  √  null
origin varchar 2147483647
academic_career varchar 2147483647  √  null
academic_level varchar 2147483647  √  null
title varchar 2147483647  √  null
barcode varchar 2147483647  √  null
city varchar 2147483647  √  null
contact_note varchar 2147483647  √  null
country varchar 2147483647  √  null
department varchar 2147483647  √  null
email varchar 2147483647  √  null
email_local varchar 2147483647  √  null
expires timestamptz 35,6  √  null
fax varchar 2147483647  √  null
first_name varchar 2147483647  √  null
last_name varchar 2147483647  √  null
late_returns int8 19  √  null
note varchar 2147483647  √  null
organization_oid int8 19  √  null
other_name varchar 2147483647  √  null
patron_class_oid int8 19
patron_class.obj_oid fkcpatron_class_oid
postal_code varchar 2147483647  √  null
state varchar 2147483647  √  null
status wcof_tag 2147483647  √  null
street varchar 2147483647  √  null
street2 varchar 2147483647  √  null
suppress_email bool 1  √  null
telephone varchar 2147483647  √  null
telephone_local varchar 2147483647  √  null
unused_reservations int8 19  √  null
userid varchar 2147483647  √  null
external_id varchar 2147483647  √  null
person_type varchar 2147483647  √  null
client_name varchar 2147483647  √  null
vendor_name varchar 2147483647  √  null
weekly_max_hours float4 8,8  √  null
sortable_name varchar 2147483647  √  null
avatar varchar 2147483647  √  null

Table contained 6 rows at Thu Feb 14 09:20 CST 2019

Indexes:
Column(s) Type Sort Constraint Name Anomalies
obj_oid Primary key Asc person_pkey  
barcode Must be unique Asc person_barcode_key This unique column is also nullable
origin Performance Asc person_ext_origin_idx  
external_id Must be unique Asc person_external_id_key This unique column is also nullable
first_name Performance Asc person_first_name_idx  
last_name Performance Asc person_last_name_idx  
origin Performance Asc person_origin_idx  
other_name Performance Asc person_other_name_idx  
status Performance Asc person_status_idx  
userid Must be unique Asc person_userid_idx This unique column is also nullable
userid Must be unique Asc person_userid_key This unique column is also nullable

Close relationships  within of separation: