club_holds_to_patron_holds - testsql

Columns

Related columns Constraint Comments

Search:

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

Showing 1 to 6 of 6 entries

Table contained 0 rows

Indexes

Search:

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

Showing 1 to 4 of 4 entries

Relationships

Close relationships within degrees of separation

One
Two degrees