Table webco_3.9.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
calendar_authentication.obj_oid fkccalauthentication_obj_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_allocation.patron_oid fkcpir_allocation_patron_oid
pir_person_location.person_oid fkcpir_location_person_oid
pir_request_log.patron_oid fkpir_request_log_patron_oid
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_authorization.person fkauth_person
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 timestamp 29,6  √  null
deleted bool 1  √  null
origin varchar 2147483647  √  null
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 timestamp 29,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 varchar 2147483647  √  null
postal_code varchar 2147483647  √  null
state varchar 2147483647  √  null
status varchar 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 int8 19  √  null

Table contained 1 rows at Wed May 07 11:05 EDT 2014

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
deleted Performance Asc person_deleted_idx  
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: