club_holds_to_patron_holds


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
club_hold_id INT 10 null
club_holds.id clubs_holds_paton_holds_ibfk_1 C
patron_id INT 10 null
borrowers.borrowernumber clubs_holds_paton_holds_ibfk_2 C
hold_id INT 10 √ null
reserves.reserve_id clubs_holds_paton_holds_ibfk_3 C
error_code enum('damaged', 'ageRestricted', 'itemAlreadyOnHold', 'tooManyHoldsForThisRecord', 'tooManyReservesToday', 'tooManyReserves', 'notReservable', 'cannotReserveFromOtherBranches', 'libraryNotFound', 'libraryNotPickupLocation', 'cannotBeTransferred') 30 √ null
error_message VARCHAR 100 √ null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
clubs_holds_paton_holds_ibfk_1 Performance Asc club_hold_id
clubs_holds_paton_holds_ibfk_2 Performance Asc patron_id
clubs_holds_paton_holds_ibfk_3 Performance Asc hold_id

Relationships

Close relationships within degrees of separation