person

6 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
obj_oid int8 19 null
account.person_oid fkperson_oidC
account_credit.created_by fkacct_cred_created_by
account_debit.created_by fkacct_deb_created_by
allocation.agent_oid fkcalloc_agent_oid
allocation.contact_person fkcalloc_contact_personN
allocation.original_agent_oid fkallocation_original_agent_oidN
allocation.patron_oid fkcalloc_patron_oidR
allocation_accompanying_person.person_oid allocation_accompanying_person_person_oid_fkeyC
authentication.obj_oid fkcauthentication_obj_oidC
department.billing_contact_oid fkcdepartment_billing_contact_oidN
file_attachment.upload_person_oid fkfile_attachment_upload_person_oidR
hold.person_oid fkchold_person_oidC
inventory_item.inventoried_assigned_person_oid inventory_item_inventoried_assigned_person_oid_fkeyN
inventory_item.scanning_agent_oid inventory_item_scanning_agent_oid_fkeyN
inventory_note.agent_oid inventory_note_agent_oid_fkeyN
invoice.created_by fkcinvoice_created_by
invoice.modified_by fkcinvoice_modified_byN
invoice_line.created_by fkinv_line_created_by
invoice_line.modified_by fkinv_line_modified_by
maintenance_schedule.person_oid fkmaintsched_person_oidN
maintenance_type.default_person_oid fkmainttype_person_oidN
organization.admin_id fkcorg_admin_idN
patron_custom_data.person_oid patron_custom_data_person_oid_fkeyC
person_checkout_center_signature.person_oid person_checkout_center_signature_person_oid_fkeyC
person_role.person_oid fkcapability_person_oidC
resource.assigned_person_oid fkcres_personN
resource_schedule.return_agent_oid fkcresource_schedule_return_agent_oid
resource_type_certification.person_oid resource_type_certification_person_oid_fkeyC
sched_employee.person_oid sched_employee_person_oid_fkeyC
sched_staff.person_oid sched_staff_person_oid_fkeyC
sched_staff_availability.person_oid sched_staff_availability_person_oid_fkeyC
section_member.member_oid fkc_section_member_member_oidC
subscription.person_oid fksubscription_person_oidC
task_person.person_oid task_person_person_oid_fkeyC
ticket.agent_oid fkticket_agent
ticket.patron_oid fkticket_patronN
ticket.responsible_op_oid fkticket_responsible_op
ticket_assignment_rule.person_oid tar_person_oidC
ticket_log.agent_oid fkcticket_log_agent_oid
turndown.patron_oid turndown_patron_oid_fkeyN
wco_group.contact_oid fkcwco_group_contact_oidN
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 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 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
other_name varchar 2147483647 √ null
patron_class_oid int8 19 null
patron_class.obj_oid fkcpatron_class_oidR
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
weekly_max_hours float4 8,8 √ null
sortable_name varchar 2147483647 √ null
avatar varchar 2147483647 √ null
image_url varchar 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
person_pkey Primary key Asc obj_oid
person_barcode_key Must be unique Asc barcode
person_external_id_key Must be unique Asc external_id
person_first_name_idx Performance Asc first_name
person_last_name_idx Performance Asc last_name
person_origin_idx Performance Asc origin
person_other_name_idx Performance Asc other_name
person_status_idx Performance Asc status
person_userid_idx Must be unique Asc userid
person_userid_key Must be unique Asc userid

Relationships

Close relationships within degrees of separation