club_holds

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
club_holds_to_patron_holds.club_hold_id clubs_holds_paton_holds_ibfk_1C
club_id INT 10 null
clubs.id clubs_holds_ibfk_1C

id for the club the hold was generated for
biblio_id INT 10 null
biblio.biblionumber clubs_holds_ibfk_2C

id for the bibliographic record the hold has been placed against
item_id INT 10 √ null
items.itemnumber clubs_holds_ibfk_3C

If item-level, the id for the item the hold has been placed agains
date_created TIMESTAMP 19 CURRENT_TIMESTAMP

Timestamp for the placed hold

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
clubs_holds_ibfk_1 Performance Asc club_id
clubs_holds_ibfk_2 Performance Asc biblio_id
clubs_holds_ibfk_3 Performance Asc item_id

Relationships

Close relationships within degrees of separation