all_circulation

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
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 int8 19 √ null
copy_location int4 10 √ null
copy_owning_lib int4 10 √ null
copy_circ_lib int4 10 √ null
copy_bib_record int8 19 √ null
xact_start timestamptz 35,6 √ null
xact_finish timestamptz 35,6 √ 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
checkin_scan_time timestamptz 35,6 √ null
parent_circ int8 19 √ null
auto_renewal bool 1 √ null
auto_renewal_remaining int4 10 √ null
usr int4 10 √ null

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views