aged_circulation

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
usr_post_code text 2147483647 √ null
usr_home_ou int4 10 null
usr_profile int4 10 null
usr_birth_year int4 10 √ null
copy_call_number int4 10 null
copy_owning_lib int4 10 null
copy_circ_lib int4 10 null
copy_bib_record int8 19 null
id int8 19 null
xact_start timestamptz 35,6 null
xact_finish timestamptz 35,6 √ null
unrecovered bool 1 √ null
target_copy int8 19 null
circ_lib int4 10 null
circ_staff int4 10 null
checkin_staff int4 10 √ null
checkin_lib int4 10 √ null
renewal_remaining int4 10 null
grace_period interval 49,6 null
due_date timestamptz 35,6 √ null
stop_fines_time timestamptz 35,6 √ null
checkin_time timestamptz 35,6 √ null
create_time timestamptz 35,6 null
duration interval 49,6 √ null
fine_interval interval 49,6 null
recurring_fine numeric 6,2 √ null
max_fine numeric 6,2 √ null
phone_renewal bool 1 null
desk_renewal bool 1 null
opac_renewal bool 1 null
duration_rule text 2147483647 null
recurring_fine_rule text 2147483647 null
max_fine_rule text 2147483647 null
stop_fines text 2147483647 √ null
workstation int4 10 √ null
checkin_workstation int4 10 √ null
copy_location int4 10 null
checkin_scan_time timestamptz 35,6 √ null
auto_renewal bool 1 null
auto_renewal_remaining int4 10 √ null
parent_circ int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
aged_circulation_pkey Primary key Asc id
action_aged_circulation_parent_circ_idx Performance Asc parent_circ
action_aged_circulation_target_copy_idx Performance Asc target_copy
aged_circ_circ_lib_idx Performance Asc circ_lib
aged_circ_copy_circ_lib_idx Performance Asc copy_circ_lib
aged_circ_copy_location_idx Performance Asc copy_location
aged_circ_copy_owning_lib_idx Performance Asc copy_owning_lib
aged_circ_start_idx Performance Asc xact_start

Relationships

Close relationships within degrees of separation