circulation

486 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('money.billable_xact_id_seq'::regclass)
circulation.parent_circ circulation_parent_circ_fkey R
circulation_limit_group_map.circ circulation_limit_group_map_circ_fkey C
emergency_closing_circulation.circulation emergency_closing_circulation_circulation_fkey C
usr_circ_history.source_circ usr_circ_history_source_circ_fkey N
usr int4 10 null
usr.id action_circulation_usr_fkey R
xact_start timestamptz 35,6 now()
xact_finish timestamptz 35,6 √ null
unrecovered bool 1 √ null
target_copy int8 19 null
circ_lib int4 10 null
org_unit.id action_circulation_circ_lib_fkey N
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 now()
duration interval 49,6 √ null
fine_interval interval 49,6 '1 day'::interval
recurring_fine numeric 6,2 √ null
max_fine numeric 6,2 √ null
phone_renewal bool 1 false
desk_renewal bool 1 false
opac_renewal bool 1 false
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
workstation.id circulation_workstation_fkey N
checkin_workstation int4 10 √ null
workstation.id circulation_checkin_workstation_fkey N
copy_location int4 10 1
copy_location.id circulation_copy_location_fkey R
checkin_scan_time timestamptz 35,6 √ null
auto_renewal bool 1 false
auto_renewal_remaining int4 10 √ null
parent_circ int8 19 √ null
circulation.id circulation_parent_circ_fkey R

Indexes

Constraint Name Type Sort Column(s)
circulation_pkey Primary key Asc id
action_circulation_target_copy_idx Performance Asc target_copy
circ_all_usr_idx Performance Asc usr
circ_checkin_staff_idx Performance Asc checkin_staff
circ_checkin_time Performance Asc checkin_time
circ_circ_lib_idx Performance Asc circ_lib
circ_circ_staff_idx Performance Asc circ_staff
circ_open_date_idx Performance Asc xact_start
circ_open_xacts_idx Performance Asc usr
circ_outstanding_idx Performance Asc usr
circ_parent_idx Must be unique Asc parent_circ
only_one_concurrent_checkout_per_copy Must be unique Asc target_copy

Check Constraints

Constraint Name Constraint
circulation_stop_fines_check ((stop_fines = ANY (ARRAY['CHECKIN'::text, 'CLAIMSRETURNED'::text, 'LOST'::text, 'MAXFINES'::text, 'RENEW'::text, 'LONGOVERDUE'::text, 'CLAIMSNEVERCHECKEDOUT'::text])))

Relationships

Close relationships within degrees of separation