users__t


Columns

Column Type Size Nulls Auto Default Children Parents Comments
__id int8 19 √ null
__cf bool 1 true
__start timestamptz 35,6 null
__source varchar 63 null
__origin varchar 63 ''::character varying
id uuid 2147483647 null
internal_contact.ic_user_fk internal_contact_ic_user_fk_fkeyR
check_in__t.performed_by_user_id check_in__t_performed_by_user_id_fkeyR
loan__t.proxy_user_id loan__t_proxy_user_id_fkeyR
patron_action_session__t.patron_id patron_action_session__t_patron_id_fkeyR
request__t.cancelled_by_user_id request__t_cancelled_by_user_id_fkeyR
request__t.requester_id request__t_requester_id_fkeyR
scheduled_notice__t.recipient_user_id scheduled_notice__t_recipient_user_id_fkeyR
user_request_preference__t.user_id user_request_preference__t_user_id_fkeyR
manualblocks__t.user_id manualblocks__t_user_id_fkeyR
service_point_user__t.user_id service_point_user__t_user_id_fkeyR
invoices__t.approved_by invoices__t_approved_by_fkeyR
internal_contact.ic_user_fk internal_contact_ic_user_fk_fkeyR
notify_data__t.recipient_id notify_data__t_recipient_id_fkeyR
purchase_order__t.approved_by_id purchase_order__t_approved_by_id_fkeyR
item_checked_in_event__t.user_id item_checked_in_event__t_user_id_fkeyR
item_claimed_returned_event__t.user_id item_claimed_returned_event__t_user_id_fkeyR
item_declared_lost_event__t.user_id item_declared_lost_event__t_user_id_fkeyR
loan_due_date_changed_event__t.user_id loan_due_date_changed_event__t_user_id_fkeyR
synchronization_jobs__t.user_id synchronization_jobs__t_user_id_fkeyR
permissions_users__t.user_id permissions_users__t_user_id_fkeyR
dashboard.dshb_owner_fk dashboard_dshb_owner_fk_fkey1R
records_lb.created_by_user_id records_lb_created_by_user_id_fkeyR
records_lb.updated_by_user_id records_lb_updated_by_user_id_fkeyR
snapshots_lb.created_by_user_id snapshots_lb_created_by_user_id_fkeyR
snapshots_lb.updated_by_user_id snapshots_lb_updated_by_user_id_fkeyR
job_executions__t.user_id job_executions__t_user_id_fkeyR
proxyfor__t.proxy_user_id proxyfor__t_proxy_user_id_fkeyR
proxyfor__t.user_id proxyfor__t_user_id_fkeyR
username varchar 23 √ null
external_system_id varchar 10 √ null
barcode varchar 41 √ null
updated_date timestamptz 35,6 √ null
active bool 1 √ null
patron_group uuid 2147483647 √ null
groups__t.id users__t_patron_group_fkeyR
expiration_date timestamptz 35,6 √ null
created_date timestamptz 35,6 √ null
enrollment_date timestamptz 35,6 √ null

Indexes

Constraint Name Type Sort Column(s)
users__t_pkey Primary key Asc id
users__t___origin_idx Performance Asc __origin
users__t___source_idx Performance Asc __source
users__t___start_idx Performance Asc __start
users__t_active_idx Performance Asc active
users__t_barcode_idx Performance Asc barcode
users__t_created_date_idx Performance Asc created_date
users__t_enrollment_date_idx Performance Asc enrollment_date
users__t_expiration_date_idx Performance Asc expiration_date
users__t_external_system_id_idx Performance Asc external_system_id
users__t_id_idx Performance Asc id
users__t_patron_group_idx Performance Asc patron_group
users__t_updated_date_idx Performance Asc updated_date
users__t_username_idx Performance Asc username

Relationships

Close relationships within degrees of separation