user_users


Description

https://dev.folio.org/reference/api/#mod-users

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id varchar 36 null
circulation_check_ins.performed_by_user_id circulation_check_ins_performed_by_user_id_fkeyR
circulation_request_preference.user_id circulation_request_preference_user_id_fkeyR
circulation_requests.requester_id circulation_requests_requester_id_fkeyR
feesfines_accounts.user_id feesfines_accounts_user_id_fkeyR
feesfines_feefineactions.user_id feesfines_feefineactions_user_id_fkeyR
feesfines_manualblocks.user_id feesfines_manualblocks_user_id_fkeyR
inventory_service_points_users.user_id inventory_service_points_users_user_id_fkeyR
invoice_invoices.approved_by invoice_invoices_approved_by_fkeyR
patron_blocks_user_summary.user_id patron_blocks_user_summary_user_id_fkeyR
perm_users.user_id perm_users_user_id_fkeyR
srs_records.created_by_user_id srs_records_created_by_user_id_fkeyR
srs_records.updated_by_user_id srs_records_updated_by_user_id_fkeyR
user_proxiesfor.proxy_user_id user_proxiesfor_proxy_user_id_fkeyR
user_proxiesfor.user_id user_proxiesfor_user_id_fkeyR
active bool 1 √ null
barcode varchar 41 √ null
created_date timestamptz 35,6 √ null
enrollment_date timestamptz 35,6 √ null
expiration_date timestamptz 35,6 √ null
external_system_id varchar 9 √ null
patron_group varchar 36 √ null
user_groups.id user_users_patron_group_fkeyR
updated_date timestamptz 35,6 √ null
username varchar 23 √ null
data json 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
user_users_pkey Primary key Asc id
user_users_active_idx Performance Asc active
user_users_barcode_idx Performance Asc barcode
user_users_created_date_idx Performance Asc created_date
user_users_enrollment_date_idx Performance Asc enrollment_date
user_users_expiration_date_idx Performance Asc expiration_date
user_users_external_system_id_idx Performance Asc external_system_id
user_users_patron_group_idx Performance Asc patron_group
user_users_updated_date_idx Performance Asc updated_date
user_users_username_idx Performance Asc username

Relationships

Close relationships within degrees of separation