action.unfulfilled_hold_innermost_loop (view)

↑ action schema

This is a database view, not a base table. It has no triggers, indexes, or FK constraints of its own. Querying this view may be more efficient than joining the underlying tables directly.

Columns

Column Type Nullable Notes

Column	Type	Nullable
hold	`integer`	Yes
circ_lib	`integer`	Yes
count	`bigint`	Yes

hold

integer

Yes

circ_lib

integer

Yes

count

bigint

Yes

View Definition

 SELECT DISTINCT l.hold,
    l.circ_lib,
    l.count
   FROM action.unfulfilled_hold_loops l
     JOIN action.unfulfilled_hold_min_loop m USING (hold)
  WHERE l.count = m.min;