usr

379 rows


Description

User objects

This table contains the core User objects that describe both staff members and patrons. The difference between the two types of users is based on the user’s permissions.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('actor.usr_id_seq'::regclass)
claim_event.creator claim_event_creator_fkey R
distribution_formula_application.creator distribution_formula_application_creator_fkey R
fund_allocation.allocator fund_allocation_allocator_fkey R
fund_allocation_percent.allocator fund_allocation_percent_allocator_fkey R
fund_transfer.transfer_user fund_transfer_transfer_user_fkey R
invoice.closed_by invoice_closed_by_fkey R
lineitem.creator lineitem_creator_fkey R
lineitem.editor lineitem_editor_fkey R
lineitem.selector lineitem_selector_fkey R
lineitem_detail.receiver lineitem_detail_receiver_fkey R
lineitem_note.creator lineitem_note_creator_fkey R
lineitem_note.editor lineitem_note_editor_fkey R
lineitem_usr_attr_definition.usr lineitem_usr_attr_definition_usr_fkey R
picklist.creator picklist_creator_fkey R
picklist.editor picklist_editor_fkey R
picklist.owner picklist_owner_fkey R
po_note.creator po_note_creator_fkey R
po_note.editor po_note_editor_fkey R
provider_note.creator provider_note_creator_fkey R
provider_note.editor provider_note_editor_fkey R
purchase_order.creator purchase_order_creator_fkey R
purchase_order.editor purchase_order_editor_fkey R
purchase_order.owner purchase_order_owner_fkey R
serial_claim_event.creator serial_claim_event_creator_fkey R
shipment_notification.processed_by shipment_notification_processed_by_fkey N
user_request.usr user_request_usr_fkey R
batch_hold_event.staff batch_hold_event_staff_fkey C
circulation.usr action_circulation_usr_fkey R
curbside.delivery_staff curbside_delivery_staff_fkey C
curbside.patron curbside_patron_fkey C
curbside.stage_staff curbside_stage_staff_fkey C
emergency_closing.creator emergency_closing_creator_fkey C
fieldset.owner fieldset_owner_fkey R
fieldset_group.creator fieldset_group_creator_fkey C
hold_notification.notify_staff hold_notification_notify_staff_fkey R
hold_request.fulfillment_staff hold_request_fulfillment_staff_fkey R
hold_request.requestor hold_request_requestor_fkey R
hold_request.usr hold_request_usr_fkey R
in_house_use.staff in_house_use_staff_fkey R
ingest_queue.who ingest_queue_who_fkey N
non_cat_in_house_use.staff non_cat_in_house_use_staff_fkey R
non_cataloged_circulation.patron non_cataloged_circulation_patron_fkey R
non_cataloged_circulation.staff non_cataloged_circulation_staff_fkey R
usr_circ_history.usr usr_circ_history_usr_fkey R
event.context_user event_context_user_fkey R
card.usr card_usr_fkey R
passwd.usr passwd_usr_fkey C
stat_cat_entry_usr_map.target_usr actor_sceum_tu_fkey C
toolbar.usr toolbar_usr_fkey C
usr_activity.usr usr_activity_usr_fkey N
usr_address.usr usr_address_usr_fkey R
usr_message.editor usr_message_editor_fkey R
usr_message.usr usr_message_usr_fkey R
usr_org_unit_opt_in.staff usr_org_unit_opt_in_staff_fkey R
usr_org_unit_opt_in.usr usr_org_unit_opt_in_usr_fkey R
usr_password_reset.usr usr_password_reset_usr_fkey R
usr_privacy_waiver.usr usr_privacy_waiver_usr_fkey C
usr_saved_search.owner usr_saved_search_owner_fkey C
usr_setting.usr usr_setting_usr_fkey C
usr_standing_penalty.staff usr_standing_penalty_staff_fkey N
usr_standing_penalty.usr usr_standing_penalty_usr_fkey C
call_number.creator asset_call_number_creator_fkey R
call_number.editor asset_call_number_editor_fkey R
call_number_note.creator asset_call_number_note_creator_fkey N
copy.creator asset_copy_creator_fkey N
copy.editor asset_copy_editor_fkey N
copy_alert.ack_staff copy_alert_ack_staff_fkey N
copy_alert.create_staff copy_alert_create_staff_fkey N
copy_note.creator asset_copy_note_creator_fkey N
copy_template.creator copy_template_creator_fkey R
copy_template.editor copy_template_editor_fkey R
course_module_course_users.usr course_module_course_users_usr_fkey R
record_entry.creator biblio_record_entry_creator_fkey R
record_entry.editor biblio_record_entry_editor_fkey R
record_note.creator biblio_record_note_creator_fkey R
record_note.editor biblio_record_note_editor_fkey R
reservation.capture_staff reservation_capture_staff_fkey R
reservation.usr booking_reservation_usr_fkey R
filter_dialog_filter_set.creator config_filter_dialog_filter_set_creator_fkey C
biblio_record_entry_bucket.owner biblio_record_entry_bucket_owner_fkey C
call_number_bucket.owner call_number_bucket_owner_fkey C
carousel.creator carousel_creator_fkey R
carousel.editor carousel_editor_fkey R
copy_bucket.owner copy_bucket_owner_fkey C
user_bucket.owner user_bucket_owner_fkey C
user_bucket_item.target_user user_bucket_item_target_user_fkey C
billable_xact.usr money_billable_xact_usr_fkey R
collections_tracker.collector collections_tracker_collector_fkey R
collections_tracker.usr collections_tracker_usr_fkey R
usr_grp_map.usr usr_grp_map_usr_fkey C
usr_object_perm_map.usr usr_object_perm_map_usr_fkey C
usr_perm_map.usr usr_perm_map_usr_fkey C
usr_work_ou_map.usr usr_work_ou_map_usr_fkey C
output_folder.owner output_folder_owner_fkey R
report.owner report_owner_fkey R
report_folder.owner report_folder_owner_fkey R
schedule.runner schedule_runner_fkey R
template.owner template_owner_fkey R
template_folder.owner template_folder_owner_fkey R
distribution_note.creator distribution_note_creator_fkey R
issuance.creator issuance_creator_fkey R
issuance.editor issuance_editor_fkey R
item.creator item_creator_fkey R
item.editor item_editor_fkey R
item_note.creator item_note_creator_fkey R
routing_list_user.reader routing_list_user_reader_fkey C
subscription_note.creator subscription_note_creator_fkey R
unit.creator serial_unit_creator_fkey N
unit.editor serial_unit_editor_fkey N
user_stage.requesting_usr user_stage_requesting_usr_fkey N
session.creator session_creator_fkey R
verification_attempt.usr verification_attempt_usr_fkey R
queue.owner queue_owner_fkey R
session_tracker.usr session_tracker_usr_fkey R
card int4 10 √ null
profile int4 10 null
grp_tree.id actor_usr_profile_fkey R
usrname text 2147483647 null
email text 2147483647 √ null
passwd text 2147483647 null
standing int4 10 1
standing.id usr_standing_fkey R
ident_type int4 10 null
identification_type.id usr_ident_type_fkey R
ident_value text 2147483647 √ null
ident_type2 int4 10 √ null
identification_type.id usr_ident_type2_fkey R
ident_value2 text 2147483647 √ null
net_access_level int4 10 1
net_access_level.id usr_net_access_level_fkey R
photo_url text 2147483647 √ null
prefix text 2147483647 √ null
first_given_name text 2147483647 null
second_given_name text 2147483647 √ null
family_name text 2147483647 null
suffix text 2147483647 √ null
guardian text 2147483647 √ null
pref_prefix text 2147483647 √ null
pref_first_given_name text 2147483647 √ null
pref_second_given_name text 2147483647 √ null
pref_family_name text 2147483647 √ null
pref_suffix text 2147483647 √ null
name_keywords text 2147483647 √ null
name_kw_tsvector tsvector 2147483647 √ null
alias text 2147483647 √ null
day_phone text 2147483647 √ null
evening_phone text 2147483647 √ null
other_phone text 2147483647 √ null
mailing_address int4 10 √ null
usr_address.id actor_usr_mailing_address_fkey R
billing_address int4 10 √ null
usr_address.id actor_usr_billing_address_fkey R
home_ou int4 10 null
org_unit.id actor_usr_home_ou_fkey R
dob date 13 √ null
active bool 1 true
master_account bool 1 false
super_user bool 1 false
barred bool 1 false
deleted bool 1 false
juvenile bool 1 false
usrgroup serial 10 √ nextval('actor.usr_usrgroup_seq'::regclass)
claims_returned_count int4 10 0
credit_forward_balance numeric 6,2 0.00
last_xact_id text 2147483647 'none'::text
create_date timestamptz 35,6 now()
expire_date timestamptz 35,6 (now() + '3 years'::interval)
claims_never_checked_out_count int4 10 0
last_update_time timestamptz 35,6 √ null
locale text 2147483647 √ null
i18n_locale.code usr_locale_fkey R

Indexes

Constraint Name Type Sort Column(s)
usr_pkey Primary key Asc id
actor_usr_billing_address_idx Performance Asc billing_address
actor_usr_day_phone_idx Performance
actor_usr_day_phone_idx_numeric Performance
actor_usr_email_idx Performance
actor_usr_evening_phone_idx Performance
actor_usr_evening_phone_idx_numeric Performance
actor_usr_family_name_idx Performance
actor_usr_family_name_unaccent_idx Performance
actor_usr_first_given_name_idx Performance
actor_usr_first_given_name_unaccent_idx Performance
actor_usr_guardian_idx Performance
actor_usr_guardian_unaccent_idx Performance
actor_usr_home_ou_idx Performance Asc home_ou
actor_usr_ident_value2_idx Performance
actor_usr_ident_value_idx Performance
actor_usr_mailing_address_idx Performance Asc mailing_address
actor_usr_other_phone_idx Performance
actor_usr_other_phone_idx_numeric Performance
actor_usr_pref_family_name_idx Performance
actor_usr_pref_family_name_unaccent_idx Performance
actor_usr_pref_first_given_name_idx Performance
actor_usr_pref_first_given_name_unaccent_idx Performance
actor_usr_pref_second_given_name_idx Performance
actor_usr_pref_second_given_name_unaccent_idx Performance
actor_usr_second_given_name_idx Performance
actor_usr_second_given_name_unaccent_idx Performance
actor_usr_usrgroup_idx Performance Asc usrgroup
actor_usr_usrname_idx Performance
actor_usr_usrname_unaccent_idx Performance
usr_card_key Must be unique Asc card
usr_usrname_key Must be unique Asc usrname

Relationships

Close relationships within degrees of separation