hold_groups

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
hold_group_id INT UNSIGNED 10 √ null
hold_groups_target_holds.hold_group_id hold_group_target_holds_ibfk_1 C
old_reserves.hold_group_id old_reserves_ibfk_hg N
reserves.hold_group_id reserves_ibfk_hg N
borrowernumber INT 10 √ NULL
borrowers.borrowernumber hold_groups_ibfk_1 C

foreign key, linking this to the borrowers table
visual_hold_group_id INT 10 √ NULL

visual ID for this hold group, in the context of the related patron

Indexes

Constraint Name Type Sort Column(s)
hold_groups_s_pk Primary key Asc hold_group_id
hold_groups_borrowernumber Performance Asc borrowernumber
PRIMARY Must be unique Asc hold_group_id

Relationships

Close relationships within degrees of separation