Table webco_4.3.3.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_freelancer.person_oid fkcallocation_freelancer_person_oid
allocation_person.person_oid fkcalloc_person_person_oid
authentication.obj_oid fkcauthentication_obj_oid
authset.person_oid fkauthset_person_oid
department.billing_contact_oid fkcdepartment_billing_contact_oid
file_attachment.upload_person_oid fkfile_attachment_upload_person_oid
freelancer_person_location.person_oid fkcfreelancer_person_location_person_oid
group_authorization.person_oid group_authorization_person_oid_fkey
group_member.person_oid fkcgroup_member_person_oid
hold.person_oid fkchold_person_oid
inventory_event.agent_oid inventory_event_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_location_signature.person_oid person_location_signature_person_oid_fkey
person_role.person_oid fkperson_role_person_oid
pir_person_location.person_oid fkcpir_location_person_oid
resource.assigned_person_oid fkcres_person
resource_schedule.return_agent_oid fkcresource_schedule_return_agent_oid
sched_staff.person_oid sched_staff_person_oid_fkey
sched_staff_availability.person_oid sched_staff_availability_person_oid_fkey
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.instructor_oid fkcwco_group_instructor_oid
wco_group.teaching_assistant_oid fkcwco_group_teaching_assistant_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
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

Table contained 5 rows at Fri Sep 23 14:49 CDT 2016

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  
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: